strConn = "Driver={SQL Native Client};server = .\sqlexpress;" +;
"Database=Docman;Trusted_connection=yes"

lnHandle = SQLSTRINGCONNECT(strConn)
WAIT WINDOW lnHandle
SQLEXEC(lnHandle,"Select * from Docs",'MyCursor')

SELECT MyCursor
BROWSE
_________________________________________________
When I run the code, I get a screen asking me for Server,
gives a dropdown with two options: local and GerardXP (which
is my computer name. If I select GerardXP, it gives a whole pile of
error messages e.bg Sql Sata 01500 Sql SErver Error 4060 Invalid
Connection String Attribute.

It also says Login Failes for GerardXP\followed by MY WINDOWS LOGIN NAME.

REGARDS,
Gerard



>SQL Server can be setup to use only Windows authentication or SQL Server and Windows authentication. What is your connection string? what is the user name in the error above?