Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connect VFP to SQL Server w/o ODBC
Message
 
To
27/11/2000 15:05:17
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00445800
Message ID:
00445846
Views:
16
Marc,

If the problem that you are trying to avoid is dealing with the ODBC Control Panel on each workstation the answer is yes. There is a way that you can connect to SQL using ODBC with a DNS-less connection.

Create a database container
Then issue CREATE CONNECTION MyConnection CONNSTRING 'SERVER=(local);DRIVER=sql server;UID=sa;PWD=;DATABASE=northwind'

The above code will create a connection that you can use in your remote views or in SQL pass-through to connect to your SQL Server without dealing with the connection settings on each individual PC.

The above method WILL use ODBC, but it is painless :)

>Is it possible to acces SQL Server tables via VFP without using ODBC?
>OR at least without configure ODBC on each client station??
>If yes, how can I do that?
>Thank you in advance.
Hector Correa
Previous
Reply
Map
View

Click here to load this message in the networking platform