|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Crash on objConnection.Open myConnString
Dim myConnString
myConnString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\Inetpub\wwwroot\database\dbProperty.mdb" Dim objRecordset, objConnection, strSQL strSQL = "SELECT * FROM tblProperty WHERE Expire >= #" & Date & "# " strSQL = strSQL & " ORDER BY ListDate ASC" Set objConnection = Server.CreateObject("ADODB.Connection") Set objRecordset = Server.CreateObject("ADODB.Recordset") objConnection.Open myConnString objRecordset.CursorLocation = 3 objRecordset.CursorType = 3 objRecordset.Open strSQL, objConnection ------------------------------------------ Above is my code I am using ASP and Access, the site was working great, I have other sites using ASP and Access on the same box that are working fine. But this one is no crashing at the line: objConnection.Open myConnString I cant seem to figure this out. Sometimes it works and most of the time it crashes. |
|
#2
|
|||
|
|||
|
Help!!
I cant figure out why this is happening. |
![]() |
| Viewing: Dev Shed Forums > Databases > Database Management > Crash on objConnection.Open myConnString |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|