[MS_AccessPros] ADODB Connection String to Oracle

 

Can anyone assist with the typlical syntax used to an Oracle table in the "Data Source" sting? What I have so far is...

Conn.Open "Provider=msdaora; " & _
"Data Source='<Host>:<Port>/<Service Name>/<Schema>.<Table>'; " & _
"User ID='<User>'; Password='<Password>';"

Thanks in advance!
Mike

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 8

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___