Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to Oracle
Message
From
07/09/2004 15:26:27
 
 
To
07/09/2004 15:12:06
Jerry Tovar
Dana Corporation Dana It
Maumee, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00940058
Message ID:
00940065
Views:
26
Try with this
SQLSETPROP(0,"DispLogin",3)
HTH

>We connect to an Oracle database in our application. If I use the Microsoft driver to connect, I get a connection handle returned with no problem.

>But if I use the Oracle driver to connect, I get a dialog asking for a Service Name. After I enter the Service Name, I then get a valid connection handle.

>Below are both of my connection strings, why does the Oracle example force me to re-enter my Service name (myserver), which is already set in the connection string?
>***MS. This works without a prompt.
>myconn = SQLSTRINGCONNECT("driver=Microsoft ODBC for >Oracle;uid=myid;pwd=mypass;server=myserver;")

>***This will connect, but a 'Oracle ODBC driver connect' dialog appears
>***first, forcing me to enter a Service Name, which is blank.
>myconn = SQLSTRINGCONNECT("driver=Oracle ODBC >Driver;uid=myid;pwd=mypass;server=myserver;")
>Thanks,
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform