Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get Version of ODBC from VFP
Message
From
29/08/2010 18:55:19
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01479042
Message ID:
01479134
Views:
79
This message has been marked as a message which has helped to the initial question of the thread.
>>Where does your nHandle come from? It must not be a VFP ODBC handle (the one returned by a call to SQLCONNECT() - sorry if I mislead you into that). Use the function GetConnect from the news2news sample to create a valid ODBC connection handle in order to query the driver (by the way, I believe you're looking for InfoType 7).
>
>Yes, I was using the handle returned from VFP function SQLSTRINGCONNECT. My bad. I will try to use the GetConnect() from the sample; the only thing I don't know is what you use for the DSN name parameter. The syntax of calling GetConnect() is GetConnect("dsn", user, password). What do you use for DSN? Thank you again for your help.

DSN stands for Data Source Name, created in the ODBC Data Source Administrator in Administrative Tools. I haven't try if you can input a DSN-less string, there...
----------------------------------
António Tavares Lopes
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform