A couple of questions on Remote connection to SQL Server 2005 database

I have a SQL Server 2005 database (called BDHSE) in a PC which i call PC1. I have a second PC (PC2) and both are within a network (a WLAN).

What i want is to have access to BDHSE from an application in VB6 (APP1) running in PC2. All the INSERT, DELETE, UPDATE records process is done through APP1.

APP1 ia currently running in PC1 and is to be installed on PC2.

I have these questions:

1. What do i need to install in PC2 since all the INSERT, DELETE, and UPDATE is done using APP1? I guess i only have to install the Microsoft SQL Native Client (with all the prerequisites of course) but i am not sure.

2. In the APP1 made in VB6, do i have to change the connectionstring since i am accesing the database which physically is at PC1 and the APP1 will be used in PC2?

3. Any advice you can give me on doing this will be well received.

Thanks in advance,

BSc Fernando Martinez

1. If you do not want to use any new features of the SQL Server 2k5, you can also install the MDAC stack. You don′t need to install the SNAC drivers. If you install the SNAC drivers and want to use them, make sure that you change your connectionstring (samles can be found on the site www.connectionstrings.com).

2. I don′t get your throught here, but you will have to point the connectionstring of the application to the server where the database is actually hosted.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||thanks, i found out the problem.