Database connection problems

[ccampbell]

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/WebSite/checklogin.asp, line 22

is the error that I am getting, here is my code, I am usign a global.asa file

dim rs, c, cstring, sql
cstring =Application("ConnectionString&quot
sqlEasyQuery = "SELECT * FROM CARRIER WHERE ID_NUMBER ='" & Request.Form("id&quot & "' AND PASSWORD ='" & Request.Form("pass&quot & "';"
set c = server.CreateObject("adodb.connection&quot
set rs = server.CreateObject("adodb.recordset&quot
c.Open cstring

in my global.asa file I have to following
Application("ConnectionString&quot = "Provider=MSDASQL.1;Password=;User ID=sa;DRIVER=SQL Server;SERVER=TEST;UID=sa;APP=Microsoft Development Environment;DATABASE=Test2"";"

can anyone help me? My global.asa file and my asp file are in the same directory and for some reason I can't get a connection to the database.

 

[onpnt]

I may be wrong but shouldn't APP be this
APP=Microsoft Open Database Connectivity
and not
APP=Microsoft Development Environment

worth a try. everything looks fine from here but it is late in the day A language that doesn't affect the way you think about programming is not worth knowing.

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

 

[ccampbell]

Didn't make a difference. I have even tried to simplify the connection string by making it

Application("ConnectionString&quot = "driver=SQLServer;server=TEST;UID=sa;PWD=;database=Test2"";"

still no luck. Any other ideas?