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!

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

Connecting to Oracle

Status
Not open for further replies.
VICKEL1

VICKEL1

Programmer
May 16, 2005
15
GB
I am connecting to an Oracle database using a connebction string. However, I am getting the error

Run time error '-2147217871 (80040e31)'

[Oracle][ODBC][Ora]ORA-01013: user requested cancel of current operation.

My connection string is

Set con = CreateObject("ADODB.Connection")
Set rs = CreateObject("ADODB.Recordset")
con.Open "Driver={Oracle ODBC Driver}; Dbq=Oracle; Uid=userid; Pwd=password;Connect Timeout=0;Command Timeout=0"

Any help would be appreciated.

 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Locked
  • Question
Copy data between SQL and Oracle 1
Replies
8
Views
1K
remeng
remeng
K
  • Locked
  • Question
How to resolve define worksheets array
Replies
1
Views
794
combo
combo
rf92d
  • Locked
  • Question
Hi referring to thread707-107529
Replies
0
Views
566
rf92d
rf92d
rf92d
  • Locked
  • Question
hi referring to thread707-103495
Replies
9
Views
790
Andrzejek
Andrzejek
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
2K
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top