ODBC Connection Errors 1

[trevord]

I am having trouble establishing multiple connections through one database at the same time. When accessing the database at the same time users receive the following message:

Provider error '80004005'

Unspecified error

/SignIn.asp, line 11

' Create and open ADO connection object.
set cnn1 = Server.CreateObject("ADODB.Connection&quot
OpenStr = "driver={Microsoft Access Driver (*.mdb)};" & _
"dbq=" & Server.MapPath("database/database.mdb&quot
cnn1.Open OpenStr ,"",""

(Line 11 deals with cnn1.Open OpenStr ,"","&quot

I tried establishing multiple connections i.e cnn1, cnn2. Any assistance would be appreciated.

 

[vasah20]

Access has some problems with multiple connections... it's not anything with your code. I also heard that ODBC for Access can flake out on you... try using OLEDB.

See:

http://www.learnasp.com/learn/accessSQLserver.asp

http://www.15seconds.com/issue/010514.htm

for some more information.

good luck
leo