After upgrading to MAS90 and Hightower Time and Billing Pro V3.70, I can no longer maintain a stable connection to the Employee table, T24_EmplyMstrFile.
This is my ConnectionString:
conConnectionBest.Open "Driver={MAS 90 32-Bit ODBC Driver};UID=;PWD=;Directory=C:\Program Files\Best\MAS90\;CacheSize=4;DirtyReads=1;BurstMode=1;Company=" & UCase(strCompany)
And I am opening the recordset as follows:
Dim cmdTempBest
Dim rsTempBest
Set cmdTempBest = Server.CreateObject("ADODB.Command"
Set OpenRecordsetBest = Server.CreateObject("ADODB.Recordset"
cmdTempBest.CommandText = strSQL
cmdTempBest.CommandType = 1
cmdTempBest.ActiveConnection = conConnectionBest
OpenRecordsetBest.CursorType = 0
OpenRecordsetBest.LockType = 3
OpenRecordsetBest.Open cmdTempBest
Then, I get this error:
Error Type:
Provider (0x8000FFFF)
Catastrophic failure
C:\INETPUB\ line 14
(line 14 is "conConnectionBest.Open "Driver={..."
Any ideas, anyone?
Thanks for your help!
This is my ConnectionString:
conConnectionBest.Open "Driver={MAS 90 32-Bit ODBC Driver};UID=;PWD=;Directory=C:\Program Files\Best\MAS90\;CacheSize=4;DirtyReads=1;BurstMode=1;Company=" & UCase(strCompany)
And I am opening the recordset as follows:
Dim cmdTempBest
Dim rsTempBest
Set cmdTempBest = Server.CreateObject("ADODB.Command"
Set OpenRecordsetBest = Server.CreateObject("ADODB.Recordset"
cmdTempBest.CommandText = strSQL
cmdTempBest.CommandType = 1
cmdTempBest.ActiveConnection = conConnectionBest
OpenRecordsetBest.CursorType = 0
OpenRecordsetBest.LockType = 3
OpenRecordsetBest.Open cmdTempBest
Then, I get this error:
Error Type:
Provider (0x8000FFFF)
Catastrophic failure
C:\INETPUB\ line 14
(line 14 is "conConnectionBest.Open "Driver={..."
Any ideas, anyone?
Thanks for your help!