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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only