| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Define OLEDB connection string
I am having trouble defining an OLEDB connection string to
an Oracle database. I have no problem using an ODBC connection. Works (ODBC) obj.Connection = "ODBC;DRIVER={Microsoft ODBC for Oracle};SERVER=IFAS;UID=scott;PWD=tiger" Doesn't work (OLEDB) obj.Connection = "OLEDB; Provider=MSDAORA; Data Source=ifas; User ID=scott; Password=tiger;" Does a DSN need to be created for OLEDB connections? What am I missing? TIA... John |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use a connection string? | Excel Discussion (Misc queries) | |||
| PivotTable and connection string | Excel Programming | |||
| Can't get connection string right | Excel Programming | |||
| Can't get connection string right | Excel Programming | |||
| What is the connection string ? | Excel Programming | |||
Threaded Mode
