Hi all:

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.

-Josh