Sorry about the slow response. We took a short vacation [holiday] over the weekend and just got back.

Open your ODBC Administrator and go to the Drivers tab. You have to use the exact name listed under the name column. Just do not include the parentheses and their contents that follow the name. You should also see Microsoft ODBC for Oracle as well.

>Marks,
>
>Thanks, it works with your connect string using the Microsoft ODBC Oracle driver.But I need to use the Oracle driver instead of Microsoft ODBC driver.
>Do you know which string to use in Driver : Oracle73 or another one ?
>
>Thanks again.
>
>Pierre
>
>
>>For Oracle, you have to use CONNECTSTRING instead of SERVER.
>>
>>sqlstringconnect('Driver=Microsoft ODBC for Oracle;ConnectString=Shiva.world;UID=rappro;PWD=rappro;')
>>
>>
>>>Hello everybody
>>>
>>>Who can give me the correct syntax of ORACLE connect string.
>>>I want to connect to Oracle Database without using DSN.
>>>
>>>SQL SERVER connect string is
>>>SqlServer_string="driver={SQL Server};Server=PAR_FOXSQL;database=OUTPUT;UID=;PWD="
>>>
>>>I need a similar one for ORACLE 7.3
>>>
>>>I use this connect string :
>>>Oracle_String="driver={Oracle73};Server=Shiva.world;UID=rappro;PWD=rappro"
>>>
>>>Shiva is the alias created with SQL NET Easy Configuration
>>>But it doesn't work, the error "Unable to connect to the Server" appear when I try to use it in the SQLSTRINGCONNECTION function.
>>>
>>>The connection is successful if I create DNS name and use it with SQLCONNECT function.
>>>
>>>Thanks