Web Development

Ask something
Discussion Locked

Upgrade SQL Server 7 to SQL Server 2000

0 helpful
5 replies

by pnakiet

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi, friends
I have writen an application in VB6, that use data from SQL SERVER 7. Now, I upgrade data to SQL SERVER 2000. Then I create another packet for it, and install this packet to my all my client user computer. But my program in client user computer could not connect to SQL SERVER 2000, only be able to connect to SQL SERVER 7.

(This program is still able to connect to SQL 2000 from my programming computer)

Please tell me the way to solve this problem

Thanks,

PNAKiet

5 replies

by miss kitty

Like most software, SQL 2000 is downward compatible. Meaning something created in SQL 2000 can not be read in SQL 7.0, but SQL 7.0 data can be read by SQL 2000. The client user will have to upgrade to SQL 2000.

Cathy

by pnakiet

Hello Miss Kitty,
I've already known that SQL 2000 can connect to SQL 7, and SQL 7 can not do back.
I really want to know how to upgrade my client user computer to SQL 2000 (not install SQL 2000 directly) by installing my new packet created on my programming computer (this had already installed SQL 2000 and connected well to SQL 2000 SERVER).
PNAKiet

by glen_mcleod

What is this 'packet' you keep mentionning?

How is the client app connecting to the database?

If it's an ODBC DSN, then you have to change it, on all of the machines where it's running. If it's ADO from inside the app itself, you have to change the servername/username/password in your connection object and recompile.

You might also want to look at the version of MDAC installed on the client computers.

Glen

by pnakiet

My program use ADO, it can connect from my program computer, so the servername, username and password all are not my program problems. It could not logon from my client user computer only. What must I do to make it be able to connect from my client user computer similar to my programming computer?
I used MDAC 2.5

This discussion is closed to new replies.