Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default What Is The Right Provider?

Thanks, I would appreciate that!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,588
Default What Is The Right Provider?

Jim,

Either of these work for me:

sConnString = "Provider=MSDAORA;Password=" & Password & _
";User Id=" & User & _
";Data Source=" & Instance


sConnString = "Provider=OraOLEDB.Oracle;User Id =" & User & _
";Password=" & Password & _
";Data Source=" & Instance


Tim.

--
Tim Williams
Palo Alto, CA


"Jim Heavey" wrote in message
...
Thanks, I would appreciate that!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 can i get in contact with a template provider?? Jan Excel Discussion (Misc queries) 1 April 30th 09 05:52 PM
check for OLE DB provider? cesw[_6_] Excel Programming 3 December 1st 05 11:08 PM
Provider Issue with Version Change? cesw[_7_] Excel Programming 0 December 1st 05 08:34 PM
OLE DB Provider Valmir Meneses Excel Programming 0 January 29th 04 05:06 PM
Excel schema using Jet OLEDB Provider? mike Excel Programming 1 December 22nd 03 09:25 AM


All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"