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.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement