|
-
Aug 2nd, 1999, 06:29 AM
#1
Thread Starter
Member
I'm using VB5 to connect to Oracle8 and am having a problem with my driver (Oracle 8.00.5). Here's the message from the immediate window:
0
IM006: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
0
IM006: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
0
20 Resume without error
IM006: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
0
IM006: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
I looked up the error and here's what I found:
IM006--Driver's SQLSetConnectOption failed--(returned by the Driver Manager)
During SQLConnect, the Driver Manager called the driver's
SQLSetConnectOption function and the driver returned an error. (Function
returns SQL_SUCCESS_WITH_INFO).
I don't really have a clue as to what to do next. Here's my connection code in VB if you need it:
Public Sub Main()
On Error GoTo connect_err
sOracleConnectString = "UID=" & msOracleUser & ";PWD=" &
msOraclePassword & ";Dsn=test"
With gcOracleConnection
.Connect = sOracleConnectString
.LoginTimeout = 60
.CursorDriver = rdUseClientBatch
.EstablishConnection prompt:=rdDriverNoPrompt
End With
MsgBox "You Are Connected The Database.", vbInformation +
vbOKOnly, "Phone Log Information"
If vbOK Then
frmSplash.Show
End If
connect_err:
Dim er As rdoError
Debug.Print Err, Error
For Each er In rdoErrors
Debug.Print er.Description, er.Number
Next er
Resume Next
End Sub
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|