>SQL Server 2005. I copied a SQL 2005 database from another machine (detached it first. I can connect directly in SFT SQL Server Mgmt Studio, but I cannot connect from VFP using SQLCONNECT(). I've overlooked something. My login is the db_owner and everything else. Any ideas? SQL Server is running on the same machine that I have VFP9 on. It is setup for both SQL Server and Windows Authentication and I can connect to every other database I have attached.
>
>TIA,
>
>Tracy
Why not use SQLSTRINGCONNECT()?
That is DSNless connection and I am sure you could not forget that you use DSN with it :-)
Just because you have to set the driver, database (not mandatory), type of connection (either username and password either trusted_connection=true).
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.