Problem with the connection string??

budman · March 26th, 2004, 05:53 PM

Ok, I enter info in my database and then try to navigate to a different page that displays the contents of the database and I get an 'Unexpected Error'. However, if I wait 10-25 seconds and refresh, it works fine.

Why is this happening?

bmains · March 27th, 2004, 11:13 PM

Is it an ASP error, HTML error, etc? May be a locking issue?

acdsky · March 29th, 2004, 07:12 AM

Hi

I have expereinced similar issues when using ODBC. I usually now use ADO which I have not had such problems with. e.g

strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.mappath("diary.mdb")
set objCon= Server.CreateObject("ADODB.Connection")
objCon.Open strCon
set rs = Server.CreateObject("ADODB.Recordset")
strSQL = "Select * from table1"
rsDrop.Open strSQL, objCon

I know this is not a solution for your problem but more a work around...