Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get Version of ODBC from VFP
Message
From
30/08/2010 02:58:34
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01479042
Message ID:
01479152
Views:
70
>>>>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...
>
>Thank you very much.

Don't mention it, Dmitry.
----------------------------------
António Tavares Lopes
Previous
Reply
Map
View

Click here to load this message in the networking platform