Access database on sql server 7 from different workstation

[giyer555]

Hi!!! experts

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 is 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

 

[Sashanan]

You'd just set up an ODBC connection on whatever workstation needs to access it. Details differ a bit per Windows version but this should point you in the right direction:

1. Open the Control Panel
2. Choose "ODCB settings" or "Administrative Tools" then "Data Sources ODBC" (depends on Win version)
3. Add a new data source under System DSN/User DSN depending on if you want it user bound or computer bound;
4. From the list, choose to add a new SQL Server;
5. Put in the name of the ODBC source, making sure this matches the name that the program looks for, i.e. whatever you're using on the first workstation you made the program on;
6. Select which SQL Server you want to connect to.

You'll go through some more settings like the default database and login procedure and you'll have a "Test connection" button at some point to see if it all goes well. Once you've set up a working connection to the database from the new workstation and made sure you gave it the same name that your program looks for, you should be able to connect from this workstation. You'll need to create this ODBC connection manually on every workstation that's going to be using the database and your application.



"Much that I bound, I could not free. Much that I freed returned to me."
(Lee Wilson Dodd)

 

[giyer555]

Thanx!!! sashanan

U reply seems correct to me but i have a doubt that is...
Should i install sql server in all workstations first & try.
if i install MS sql in all workstations then whether the main server will be available while 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

Pls advise

giyer555