connection-string

Django - Custom SQL in the connection string

Hello, I have had some issues with downtime as a result of hitting the max_user_connections limit in MySql. The default connection timeout is 8 hours, so once we hit the limit (and having no access to kill the connections on our shared hosting) I simply had to wait 8 hours for the connections to time out. I would like to add the follow...

Dynamic Connecton String Based on Session Variable

Hey all, I have an application that does projection of data for my client over a length of time. In order to allow the client to 'play' w/ other scenarios w/o messing up production data, they are able to choose alternative databases (basically What-If scenarios) at any point, which are a copy of the production database as of a given ti...

Connection string error

Having a problem with IIS on Windows Server 2003 (using a classic ASP web application) The database server (SQL Server 2005) is on the same machine. I create a recordset, and set its activeconnection as follows: Dim RS Set RS = Server.CreateObject("ADODB.Recordset") RS.ActiveConnection = "Provider=SQLOLEDB;Network Library=DBMSSOCN;Data...

Best way to manage connection strings in a project containing both Classic ASP and ASP.Net 1.1 code?

I have a project that I have inherited that is primarily a Classic ASP application; however, intermixed in the the application are a handful of ASP.net pages. Some of the ASP.net pages are 1.1 and do not use a code behind model. The classic ASP pages have a number of /include directories where there's a file for database connections. ...

modifying Linq-to-SQL connection in dbml?

Am I understanding correctly, and the database connection string for Linq to SQL is typically stored in the app.config file, in the connectionStrings section? Are there other places it might be done, typically? Thanks! ...

SQL Server Compact 'Data Directory' macro in Connection String - more info needed

So, as described on this msdn page, when you define a Connection String for SQL Server Compact 3.5, you can use the "Data Directory" macro, like this: quote from this msdn page: Data Directory Support SQL Server Compact 3.5 now supports the Data Directory macro. This means that if you add the string |DataDirectory| (enclosed in p...

Can we have generalized connection string for SQL Server and SQL Server Express?

I have a WCF service that is deployed on a machine. This WCF service can be configured to either SQL Server or SQL Server Express. NOTE : The SQL database location can be other machine other then where WCF service is deployed. I put following information in XML file: user id password ServerName MachineName In case of SQL Server Ex...

cannot open user default database. login failed error

Hi, I am getting this "cannot open user default database. login failed" error. What I did was using ORM to create DataContext, in the code first call TableExists function to check if the version_tbl existed, if not, then call scripts to exec sql commands to create version_tbl. Then create a new dataContext, but problem is after the ca...

SQL Server instance name with IP address

I have a very strange situation happening and I'm hoping someone here knows why. I have TCP/IP enabled for all ports on the default port 1433. All tests are consistent with SQL Server Management Studio and my program. This works: ComputerName\InstanceName 127.0.0.1 127.0.0.1,1433 192.168.1.100 192.168.1.100,1433 This does NOT wor...

SQLCe local db in temp- path in connectionstring?

Hi, I have SQL Ce db in my app, which is included in my app directory. While debugging its OK, but when published and run with setup.exe, it retrieves "file not found" in temporary directory the app is ran from. I would like to run from standard location, but I dont know how to change it. I am using this string: SqlCeConnection connect...

Hibernate: Connect to MySQL without Username or Password

I am developing a hibernate application that connects to a MySQL database. The customers would like to only specify a connection string, ie: jdbc:mysql://username:passwd@server:port/db_name However, Hibernate will not connect using just this string. It also wants the username and password connection properties set. Is there any way ...

Connectiong from C# to MySQL without any third party components?

Hi, I was always connecting to SQL which was simple, but now I would need to connect to a MySQL server. I thought System.data.odbc connection will work, but it doesnt connect. I do not udnerstand whather I really need to download and install any third party stuff like Connector or even MyODBC, I thought ODBC in .NET is enough. Could you ...

Reg Expression in C#

Hi All, <add key="Key1" value="Provider=SQLOLEDB.1;data source=serveripaddress;Initial Catalog=DB1;user id=uid;Password=***"/> I gave the above string,I want to get the serveripaddress,DB1,uid and **** these values from that string. ...

Share a Connection string between multiple web projects

OK I have two web projects WebProject1 & WebProject2. Both require database connectivity so this is all in a C#.NET project called Common. Now my question is currently the connection string for both is the same and at the moment it's hard coded into the DB class (In the Common project), but I want to move it out to a config file. I wo...

Load csv into oleDB and force all inferred datatypes to string

Im trying to load a csv file into a datatable using oledb. This is no problem but unfortunately one of the fields which looks numeric has a string value in about 3% of the fields and so is not being populated. because im converting the csv into xml i really don't care about inferring datatypes and simply need the data in a string as i ...

Why do I get this error when I try to open an MDF database via path/filename in Entity Framework?

I'm migrating an application from LINQ-to-SQL to Entity Framework and have changed the line: using (var db = new MainDataContext(SystemHelpers.GetDatabaseConnectionString())) to using (var db = new MainDataEntities(SystemHelpers.GetDatabaseConnectionString())) where SystemHelpers.GetDatabaseConnectionString()) is a file path to an...

Data Entities Connection String Problem

I must have changed something somewhere, but damned if I can figure out what it is. I have a DAL that handles all my data access (as is a DAL's wont) to my SQL Server DB. This includes the Entity Model, the repository classes and the connection string in the App.Config file. Somewhere along the piece, I must have changed something and...

In C# , how can I read a connection string stored in my web.config file connection string?

In C# class library, how can I read a connection string stored in my web.config file connection string tag? As in: <connectionStrings> <add name="CLessConStringLocal" connectionString="server=localhost;database=myDb;uid=sa;pwd=mypassword;"/> </connectionStrings> ...

CoverageInfo.getCoverageStatus() vs CoverageInfo.isCoverageSufficient(), are they the same?

In trying to determing a if a specific connection is supported, I'm cofused about the difference between CoverageInfo.getCoverageStatus() and CoverageInfo.isCoverageSufficient(). For example: // check mds with getCoverageStatus() and bitwise check boolean hasMdsCoverage1 = (CoverageInfo.getCoverageStatus() & CoverageInfo.COVERAGE_MDS) =...

I m using one database with the same name in SQL Server 2000 and SQL Server 2005.

I am using one database with the same name in SQL Server 2000 and SQL Server 2005. How can I manage the connection string in the web.config file so that we can differentiate the connection. While we are using the same user name and password for the both databases. ...