Tagged Questions
16
votes
5answers
21k views
SQL Express Connection string - Relative to application location
I am using a SQL express databases as part of a unit test project in c#.
My databases is located in ./Databases/MyUnitTestDB.mdf
I would like to use a relative path or variable in the app.config ...
12
votes
4answers
106k views
How to fix “The ConnectionString property has not been initialized”
When I start my application I get: The ConnectionString property has not been initialized.
Web.config:
<connectionStrings>
<add name="MyDB"
connectionString="Data ...
11
votes
3answers
39k views
What is the point of “Initial Catalog” in a SQL Server connection string?
Every SQL Server connection string I ever see looks something like this:
Data Source=MyLocalSqlServerInstance;Initial Catalog=My Nifty Database;
Integrated Security=SSPI;
Do I need the Initial ...
2
votes
2answers
9k views
ASP.NET MVC3: Connection string - Keyword not supported: 'initial catalog'
I am using Webmatrix.data's Database entity to create a database connection, however it doesnt like my connection string. I am running it from MVC ASP.net.
Ive tried changing it to server / ...
1
vote
1answer
9k views
problem with [SqlException (0x80131904): Invalid object name 'dbo.TableName'.]
I was looking in google and stackoverflow and i did not find the answer, how can I connect to my database table through that connection string in VS 2010 ?
<add
name="ArticleDBContext"
...
3
votes
1answer
496 views
Transferring saved data connections between Visual Studio installations
I use the data and schema comparison tools in Visual Studio a great deal. I just finished installing VS 2010 on a new VM and realized, of course, that all the saved data connections from my previous ...
2
votes
3answers
1k views
Java newbie needs help in database connection
I'm new to Java and even newer to java database connections. I've managed to create a database connection and query a table when I put it in the Main class. Now that I've moved it into a new class ...
2
votes
6answers
11k views
Open Microsoft.practices.EnterpriseLibrary database with just a connection string
I am using the Microsoft.Practices.EnterpriseLibrary Database tools and I'm having trouble creating a new database using just the connection string information.
Ideally I would like to do the ...
1
vote
2answers
68 views
In what format does SqlCeConnection expect its connection string arg?
I have a call to SqlCeConnection.Open() that's failing. The exception message I'm getting is pretty generic: "System.Data.SqlserverCe.SqlCeException" (more generic than pretty)
The pertinent code ...
0
votes
1answer
174 views
How create multiple db context intances by conntecting strings?
In C#, MVC code first application I have
public class CarContext : DbContext { }
class in first version of application. And connection string is like
<add name="CarContext" ...
14
votes
3answers
13k views
Quick ways to test OLE DB Connection String
For debugging purpose I'd like to know ways to test OLE DB connection string quickly.
I've found this free software, it works on my machine, tested successfully.
Is there a even quicker way to do ...
4
votes
1answer
1k views
where to store database string connection in java web app?
I'm about to begin my first project with java
Let me tell how I used to handle these things...
So far now, I've been workin on asp with a com+ componente made with VB6.
The component is registered ...
1
vote
1answer
5k views
how to connect to access 2007 with c#
hey,
i am new at connecting to dataBases and for some reason each time i use those following lines my program collapse:
string connectionString = ...
1
vote
4answers
4k views
C# Modify Connection String that exists inside a library
I have a Class Library, which inside just has a DataSet (MySQL connector) and a Connector class.
I use this class in multiple projects to connect to the database, and I always had the password ...
1
vote
1answer
4k views
ODBC 5.1 connection string for MySQL with read-only access
I have read-access to a MySQL database and am trying to connect to it via the MySql ODBC 5.1 driver. I'm getting an authorization failure (401) from the server. The administrator set up my access as ...
3
votes
4answers
15k views
SQL Express connection string hell ASP.Net
SQL Express 2005 is running locally. I have a project written by another person running on the same machine. All I want to do is connect to it, can't be that hard right?
This is the one I use in my ...
2
votes
2answers
7k views
SQL Server 2012: Login to PC-NAME\SQLEXPRESS works, but not to local/(local)
I'd like to login to my SQL Server 2012 Express with servername local or (local) but it doesn't work.
The only servername which works is PC-Name\SQLEXPRESS.
local/(local) has to work somehow because ...
1
vote
1answer
5k views
Web.config entry to connect to SQL Server
Well I'm trying to change the connection of my application from Oracle to SQL Server. I have this in web.config.
<compilation debug="true">
<assemblies>
...
<add ...
0
votes
1answer
1k views
The 'data source' keyword is not supported. (ASP.Net app, Entity-framework 5, Code first, migrations)
I have an OData/WCF Data Services endpoint (ASP.Net site) that I would like to switch from using EF Code first datamodel with SQL Server 2012 as backend to EF Code first datamodel with LocalDB as ...
0
votes
1answer
122 views
Need suggestion on how to work with connection polling in java(jsp&servlet)
I'm developing a simple project.In this project i'm using n no of jsp pages and servlets to interact with the database. How i have to write the connection string. Presently i written the connection ...