Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle DSN less connection string?
Message
From
24/02/1999 13:37:08
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00190931
Message ID:
00191050
Views:
17
Thanks Mark! I am reviewing your article now...

>>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...
>
>You do have to have the DSN defined in the registry. You can create this DSN programmatically. See article in KB (purple book) under Articles, then click the Client/Server category.
Previous
Reply
Map
View

Click here to load this message in the networking platform