Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle DSN less connection string?
Message
From
24/02/1999 09:56:17
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Oracle DSN less connection string?
Miscellaneous
Thread ID:
00190931
Message ID:
00190931
Views:
49
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
Map
View

Click here to load this message in the networking platform