Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle 7.3 use connect string instead of DSN
Message
From
20/01/2000 11:36:14
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Oracle 7.3 use connect string instead of DSN
Miscellaneous
Thread ID:
00320491
Message ID:
00320491
Views:
61
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
Next
Reply
Map
View

Click here to load this message in the networking platform