Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Faiyth
Starting Member
19 Posts |
 Posted - 2002-02-20 : 13:40:01
|
| This code worked excellently until I put the connection string into global.asa. What am I doing wrong? This is the error I get: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Here's the code in my asp file: Dim objConn Set objConn = Server.CreateObject("ADODB.Connection") objConn.ConnectionString = Application("Web") objConn.Open Set Rst = Server.CreateObject("ADODB.Recordset") strSQL = "Select CompanyName, CustomerID From Customers" Rst.ActiveConnection = objConn Rst.Open strSQL, objConn Here's the code in my global.asa file: Sub Application_OnStart Application.Lock Application("Web") = "CONNECTION STRING" Application.Unlock End Sub If you can help me out at all I'll be very greatful. |
|
|
Faiyth
Starting Member
19 Posts |
Posted - 2002-02-20 : 13:44:48
|
| Actually I asked this in the wrong forum. I was thinking I was having a problem with my SQL server but obviously my problem is with ASP. Sorry! |
 |
|
|
|
|
|
Problems with global.asa