error saying no default driver specified

[yeen83]

hi,i try to run my asp file on the server.And i got this errors saying that Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I check the microsoft knowledge base and it say i need to edit the registry editor.But problem is i cant edit there.there was nothing known as security.Did anyone exprience this before.Do you know how to solve it?thanks

[BigDaddy]

Can we see the code that you are using to declare your data source?

[glenngv]

did you create a DSN in the System DSN tab of the ODBC Data Sources window in Control Panel?

[yeen83]

Yes i already create that but i still got the error.

[yeen83]

These are the two files for login

1 is as attached another i paste it here:

<%
strConnect = "FileDSN=Overseas;UID=;PWD="
Set ConDB = Server.CreateObject("ADODB.Connection")
ConDB.Open strConnect
%>

[glenngv]

Function ValidateUser
Dim strSQL, objRS, pwdcompare
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strConnect

why did you create another connection object when you have an include file that already created it? I assume this is your include file:

<%
strConnect = "FileDSN=Overseas;UID=;PWD="
Set ConDB = Server.CreateObject("ADODB.Connection")
ConDB.Open strConnect
%>

why dont you just use ConDB in your asp pages?
and you should specify username/password in strConnect.

[yeen83]

becos i have the same condb included for all the asp pages.my database is access file and i do not put ny username or password for it.

[glenngv]

try:

strConnect = "DSN=Overseas"


but I still can't get it why you create another connection object in your asp pages when you already created one in the include file. You could have just do it like this:

Function ValidateUser
Dim strSQL, objRS, pwdcompare
Set objRS = Server.CreateObject("ADODB.RecordSet")
strSQL = "Select * From Users Where User_ID ='" & m_strUserID & "'"
objRS.Open strSQL, ConDB