Using VB 6 app access database on a Sq1 server 7 from Workstations

[giyer555]

Hi!!!
Having developed an application in VB 6 using MS sql server 7.00 as backend how do i access the database from different workstations.
The application folder & database is on a server & i am using odbc to connect to the database.

I need to share the application & allow users on a network to access the database from the server..

If possible please give a detail explanation.

Thanx

 

[hmckillop]

I assume you connect to the Database using something like

myADOConn.ConnectionString = "Driver=SQL Server;Server=MyDBServer;User=sa;Password=password;"
myADOConn.Open


If the workstations are on the same domain and you can ping "MyDBServer" from these machines you should be able to connect to the server if you install your VB App. By Default you should have SQL Server ODBC driver installed on these machines and as such should be able to connect to it.

Have you tried yet to install the application on your workstations?

 

[giyer555]

hi!!! Hmckillop
Thanx for ur reply will try it out & let u know

I connect to the database in the following way using ODBC data

set myconn = new adodb.connection
myconn.open ("dsn=xyz;uid=sa;pwd=&quot
set rs = new adodb.recordset
rs.open "select .... from abc",myconn,adoOpenkeyset

All the workstation on a domain & i have not yet tried to install my application on the workstations.

Once again thanks for the reply

regards