|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Cant connect *.mdb with password to Windows2000 server. |
|
From: |
John |
|
Date: |
5/9/2001 10:17:56 AM |
|
IP: |
203.147.25.123 |
The code work well with PWS but when I upload to Windows 2000 server ...error occurs.
My code:
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&Server.MapPath("pwd2.mdb")
Set rs = Server.CreateObject("ADODB.Recordset")
sql2="Select * From tblPWD Where name='"&UserName&"'"
**** No password:It work ****
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="&Server.MapPath("pwd2.mdb")
Set rs = Server.CreateObject("ADODB.Recordset")
sql2="Select * From tblPWD Where name='"&UserName&"'" & ";uid=admin;password=pas"
**** With password:It don't work!. Error like this ****
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x4a4 Thread 0x4c8 DBC 0x21b3844 Jet'.
/sactivity/temp/Check2.asp, line 14
******
Thanks
|
Follow Up - Re: Cant connect *.mdb with password to Windows2000 server. - Chris Williams 5/9/2001 6:20:55 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
