SQL + VB Beginer need help
You can via ADO and OLEDB as well.
cn.open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=MySchema;Data Source=MYSERVER"
There are many resources on MSDN Online to assist you with ADO at
http://msdn.microsoft.com/library.
Kirk Allen Evans
Quote:
> How to connect to SQL Server ? Only by ODBC or JET with tables linked to
SQL
> Server by ODBC ? or their is any other way to connect to SQL Server7 ?
> --
> Luis Pedro Pereira
> CMC/IN2, SA - Dpt. Datalogic - QP
> Tel: +351.21.4398450
> Fax: +351.21.4303243
> Web: www.cmcin2.pt
