how to connect SQL Server with VB application at client 1

[automicgina]

Hello! First time poster so I hope I'm posting in the right forum. I have a standalone VB program that used to use Sybase as the DB and the program was distributed to the clients (all they needed to do was to install my program, no need to have Sybase). Now I have to do the same thing with SQL Server instead of sybase. Anybody knows what dll files are needed for the program to connect to the SQL server DB? or any online sources that could help me? I checked Microsoft MSDN but didn't seem to find the answer.

Thanks!!!

 

[BobWman]

Use the VB package and deployment wizard to create a setup package. Yor users can use this package to install the DLL's.

When the setup package is complete, a text file is created called Setup.lst. This file contains the DLL's and other files that need to be installed.

Additionally, you may need these:
NTWDBLIB.DLL
DBNETLIB.DLL
depending on the version of SQL Server.