sql server connection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
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.
 
Back
Top