sql server connection

K

kanan

hi
I would appreciate if somebody can give me the exact syntax for connectiing to a sql server 7.0 with windows 200
authentication. my sql server is XXSQL1 and database name is XYZ. Iam getting syntax error with various combinations
thank
Kanan
 
A

Andy Wiggins

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 said:
hi,
I would appreciate if somebody can give me the exact syntax for
Click to expand...
connectiing to a sql server 7.0 with windows 2000
authentication. my sql server is XXSQL1 and database name is XYZ. Iam
Click to expand...
getting syntax error with various combinations.
 
Top