>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.