>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...
What driver do you use? MS ODBC for Oracle (v.2.573.x and younger) doesn't support DSNless connection strings anymore. And as far as I remember "native" ODBC driver from Oracle never did it as well.