Connect Without ODBC???

Does anyone know of a way to connect to SYBASE or MS-SQL Server through VB without using ODBC?

Thanx

I dont think so, but why dont u want to use ODBC?

For MSSQL you can use OLEDB (thru ADO) or the SQL-DMO COM objects (SQL-DMO use the SQL ODBC provider behind the scenes).


Here's an OLEDB connection string, using Windows Intregrated Authentication:
"Provider=SQLOLEDB;Server=ServerNameOrIPAddress;Database=YourDB;Trusted_Connection=Yes;"

SYBASE should also have an OLEDB provider for your to connect to it's database.


"Provider=" = OLE
"DRIVER=" = ODBC (even if it is dsn-less)

Thanx alot.

Is that the only other way, though?