Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to connect VFP to Oracle 11g
Message
From
06/05/2013 09:47:06
 
 
To
06/05/2013 09:35:19
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01572759
Message ID:
01572763
Views:
55
>>>I am trying to connect VFP to Oracle 11g with the string SQLSTRINGCONNECT("Driver={Oracle in OraClient11g_home1};Dbq=myTNSServiceName;Uid=myuid;Pwd=mypwd"), but always return handle -1
>>>
>>>The Oracle ODBC driver is Ok, because when I test it, it returns connection successful
>>>
>>>Am I missing something?
>>
>>http://www.connectionstrings.com/
>
>My connection string is the same than that, but does not work.

See whether aerror() is helpful.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform