Just want to get some idea regarding the connection setup of SQL Server 7.0, I've been doing an application written in VB6 and I used SQL Server 7.0 as a storage of my database. On my local pc I can successfully connected to SQL and manipulate all the data in database.
The problem is, how can I set up the connection to become a remote server so that another PC can connect to my database(SQL Server 7.0) and use the application I've created in real time? I've been searching the net and I can't find a good answers.
Normally, on a MS network that uses TCP/IP, the named pipes protocal is also installed and is used as a secondary protocal. Now, SQL server is very use to this protocal and normally when you create an ODBC DSN it is via named pipes but you can specify other protocals when you create it.
So, first off, I would suggest just as an experiment, to see if you can create an ODBC DSN from one computer to the server. Don't forget to test the connection to make sure it works.
Then if the ODBC DSN does work then yes you do have to tweak your connection string some...