Having developed an application in

[giyer555]

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.

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

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.

Should i install sql server in all workstations.
if i install MS sql in all workstations whether the main server will be available when i create a dsn through odbc
The main server name where the database exist is xyz & i have created a dsn named abc on the server & the vb appl uses this dsn name to access the db.

My doubt is whether the MS sql server name installed on main server will be available on the workstations.

Please help

 

[SonOfEmidec1100]

You should just create the DSN on each workstation pointing to your sql server. You will need to ensure the workstations have the correct MDAC components loaded (W2000 and SP3 should be ok)

Also as a comment you should not use the sa account for client connections.

 

[AGIMA]

I also have no idea why you would want to use ODBC if you are using SQL Server 7 and ADO..... Why not call the SQL Server directly and then you wouldnt need to set up the ODBC on each of your work stations.



AGIMA - professional web hosting is our business.

AGIMA Computing

http://www.agima.com.au

 

[clientuser]

give us an example of how to call the sql server directly agima............