Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle DSN less connection string?
Message
De
24/02/1999 15:56:36
 
 
À
24/02/1999 09:56:17
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00190931
Message ID:
00191132
Vues:
17
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform