sql server connection
 

Can you get to the database using MsQuery? If you can then record a macro
whilst doing so. Within that macro you will get the syntax you need.

--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"



"kanan" wrote in message
...
hi,
I would appreciate if somebody can give me the exact syntax for
connectiing to a sql server 7.0 with windows 2000
authentication. my sql server is XXSQL1 and database name is XYZ. Iam
getting syntax error with various combinations.
thanks
Kanan