Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle DSN less connection string?
Message
From
24/02/1999 15:56:36
 
 
To
24/02/1999 09:56:17
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00190931
Message ID:
00191132
Views:
16
>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.
Virtually yours, Dmitry

mailto: me@duginov.com * www.duginov.com * ICQ UIN 6769428
Previous
Reply
Map
View

Click here to load this message in the networking platform