Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Get Version of ODBC from VFP
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01479042
Message ID:
01479138
Views:
54
>>>>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.
>>>
>>>Can you make a DSN for now in order to test?
>>
>>How do you make it?
>
>1. Create an ODBC data source :
>a. Go to Control Panel > Administrative Tools and open Data Sources ODBC. -- if you're using Windows 64 bit, then
>type odbcad32.exe in the Search box
>
>b. Click on the System DSN tab and click the Add button.
>c. Select SQL Server from the list (usually the last entry)
>d. Click Finish.
>2. Enter some name into the name box and pull down the Server list and select (local) or the server name
>where SQL and the data are installed. Click Next.
>
>3. Select the SQL Server authentication radio button.
>a. If this is not the server.
>1. Click on the Client Configuration button.
>2. If necessary, change the Network Library radio button selection from Named Pipes to TCP/IP and
>click OK.
>4. Enter a username and password of uID and password and click Next. For testing purchases you can
>also use another known account in SQL Server, such as SA.
>5. Uncheck Use ANSI quoted identifiers and click Next and then Finish.
>6. Click on Test Data Source and confirm the test completed successfully.

Thank you very much. I will follow your steps.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform