Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using sqloledb
Message
 
To
30/01/2002 15:41:55
Josh Fedke
National Financial Corporation
Milwaukee, Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00613021
Message ID:
00614011
Views:
19
>I'm trying to create a connection object based a connection string. I want to use something like the following connection string...
>
>Provider=SQLOLEDB.1;Persist Security Info=False;User ID=login_name;Initial Catalog=master;Data Source=ComputerName
>
>where I use an appropriate User ID (there is no password for the ID I'm using) and I put my computer's name in for Computername. I have SQL Server 2000 install on my Win2k Machine. When I use sqlstringconnect() or modify connection (and modify and existing connection based on a dsn) and try to use this connection string, it brings up the "select data source" prompt. It works find if I use a dsn, but I'm told there is a performance advantage in using SQLOLEDB as opposed to ODBC based dsn. Does the connection string have to be based on an ODBC dsn in VFP? Thanks in advance.

SPT commands based on ODBC connection. You could try file #10002 to use SQLOLEDB provider.
Previous
Reply
Map
View

Click here to load this message in the networking platform