Personal edition, to build a database, and then copy the application on the client side, and then installed on the client SQLSERVER2000 [link] only, then the application with the database server in the configuration file name to the computer containing the database name, run the program with respect to ok, this time is a [can't connect to the database] such a hint!!!!!!
Confused:
1) whether formal use should not be put personal edition, standard edition and should hold?
2) in the past in the local area network (LAN), computer is done with fixed IP address, now the network is used to obtain an IP address automatically, is caused by the client to run the program, when connecting to the database, can't find in the network that is equipped with the database server, which means failed to put the computer name parsing out the problem?
Please help to analyze what's the problem? How to solve?
Thank you very much!
CodePudding user response:
SQLSERVER2000 personal version if need client connection, attention to sp4 patchCodePudding user response:
1, is upstairs moderator said SP4 needs to be installed;2, the server needs to open 1433 port specified in the network firewall;
3, the client only needs to be attached together with the program on a SQL 2000 files needed for the connection of ntwdblib. DLL can, and other components, no need to install the SQL 2000
4, small single Server applications, they can be, personal edition and standard edition of the specific difference can be queried online help "install SQL Server
"5, Suggestions for local area network within the server assigned a specific IP address,
CodePudding user response:
Thank you upstairs TX help, try back!CodePudding user response:
This can have a try,,,CodePudding user response:
2, 3 L master came, your problem must be solvedCodePudding user response:
Learning,,,