General information
Title:
Oracle DSN less connection string?
I am trying to connect to an Oracle 8 server
running Unix.
I was hoping I could simply create a dsn-less connection string
and connect to the server. Do DSN-less connectino still require
one to create an ODBC driver? Anyway, I did create an ODBC dsn
named lexnet.
The Following syntax works:
xx=sqlconnect('lexnet','uname','password')
?xx && returns a 1
sqldisconnect(xx)
But this connection string example does not.
constr="driver={Oracle};server=lexnet;database=lexnet;uid=uname;pwd=password;"
xx=sqlstringconnect(constr)
?? XX && returns a -1
Any ideas why this is not working? Is {Oracle} the correct
name for the driver? Any help will be greatly appreciated...
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