Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Catastophic Failure -- What is THIS?!

Status
Not open for further replies.

DrFrank

Programmer
Feb 22, 2003
6
US
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top