Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Review of Microsoft.Jet.OLEDB.4.0 Connection
I am having a problem connecting to an Access table which is linked to an
oracle database table. Please note that Oracle prompts for the userId and pswd and my goal is to not need to manually enter the Oracle userId and Pwd. Thank you!! strConn = "Provider=Microsoft.Jet.OLEDB.4.0; " _ & "Data Source=" & ThisWorkbook.Path & "\fbDATAWAREHOUSE.mdb" _ & "Jet OLEDB:database; User Id=myId; Password=mypwd" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft.ACE.OLEDB.12.0 - BUG | Excel Discussion (Misc queries) | |||
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the l | Excel Programming | |||
oledb connection string problem in vb.net | Excel Programming | |||
Connection to Excel from .Net using Oledb | Excel Programming | |||
Define OLEDB connection string | Excel Programming |