A More Reliable Connection then ODBC?

[TheMus]

Is there a more relible connection than ODBC. I'm connecting to Oracle and receive a call block error many times.

Thanks

 

[DougP]

I am using a DSN-less connection to SQL Server 7..

But you have to download the "MDAC_type.exe" file from Microsoft in order to use the ADO. Its 7 Megabytes by the way.

' SQL connections
Dim Conn As ADODB.Connection
Dim MyTransSQL As ADODB.Recordset

Set Conn = New ADODB.Connection
Set MyTransSQL = New ADODB.Recordset

Conn.Open "driver=SQL Server;server=smallbserver;uid=sa;pwd=;database=Universal;"

WhattoAdd = "Employee " & Me!Text0

SQLcode = "INSERT INTO TransLog (LogInfo) VALUES (N'" & WhattoAdd & " Date > " &

Format$(Now, "ddd mm/dd/yy&quot & " " & Format(Now, "hh:nn:ss&quot & "')"
MyTransSQL.Open SQLcode, Conn, adOpenStatic, adLockOptimistic

 

[THoey]

Not saying that there may not be a better way, but I haven't had too many problems with ODBC once I figured out how to use it. It might be better to try and figure out if there is really a problem with the way your connection is set up or in the set up of your server / DBMS.

Maybe some more info would ring a bell. There are a lot of *experts* here (and I don't mean that sarcastically).