>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
Have you tried adding the blank password to the connection string? Try adding "Password=;" and see if that helps.
Hector Correa