General information
Title:
Connection String for Oracle
Hi,
Does anyone user the SQLSTRINGCONNECT function to connect to an Oracle Database, if so what is the format of the string needed. I guessed on the following, based on what is used to connect to SQL Server
lnConnect = SQLSTRINGCONNECT("Driver=Oracle ODBC Driver;Server=Phoenix;UID=MyUser;PWD=MyPassword;Database=kan2")
but I always receive a dialog box requesting Service name, User name and Password, although the username and password boxes are prepopulated with the correct info.
Anyone know where I am going wrong?
Thanks,
Joel
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only