Posted to microsoft.public.excel.programming

Brent

external usenet poster

Posts: 109

ADO connection string error??

Here is my code, w/o the username/password:

Dim cn As New ADODB.Connection
..
..
cn.Open "Provider=msdaora;Data Source=qse1.world;User ID=XX;Password=XX"

When I run it in Excel it pauses a few seconds on the cn.Open statement then
gives:

Run-time error '-2147467259(80004005)':
Automation error
Unspecified error

Any suggestions? I have tried just about every form of connection string
and get the same message. Thank you.

Brent

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I use a connection string?	BrandenK	Excel Discussion (Misc queries)	0	September 25th 07 07:10 PM
Hiding SQL Connection String	Hiran de Silva[_2_]	Excel Programming	0	March 12th 06 04:18 PM
Can't get connection string right	Frank Isaacs	Excel Programming	1	October 2nd 03 05:02 AM
Can't get connection string right	Brad Wood[_2_]	Excel Programming	0	September 30th 03 09:38 PM
What is the connection string ?	Jan Karel Pieterse	Excel Programming	0	July 25th 03 11:37 AM

All times are GMT +1. The time now is 10:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us