Connection handling techniques for MS SQL

Scenario Description: Why the package out of the program, the client connection database is always prompted not to connect to the database. You can connect only if the client is loaded with SQL.

I wrapped it in a dbmsshrn.dll,ntwdblib.dll,dbmssocn in my bag. Dll,dbnetlib.dll,libjcc.dll,ntwdblib.dll,dbmsspxn.dll,dbnmpntw.dll,pbdwe80.dll,pbmss80.dll,pbrtc80.dll

Pbsyc80.dll,pbtra80.dll,pbvm80.dll, but after installing to the client, it shows that the database is not connected

When I put SQL Server on this machine, I can connect to the database on the server, I think

Maybe there is a DLL file I'm not packing, is that right, if so, what should be wrapped on the file?? I'm using a sql2000 server where the database has been patched sp4.0

Solution:

1. Install PBVM First

2.Copy

Dbnmpntw.dll

Dbmssocn.dll

Dbnetlib.dll

Ntwdblib.dll

Under the%SystemRoot%\System32.

Or, first, put the required DLL in one eye,

Save the following foot as a. bat file and perform the script.

REM---------Sqlconfig.bat Foot

@echo off

: Begin

Copy *.dll%systemroot%\system32

It's OK to put it in the EXE directory.

1. Required Dynamic Libraries:

(1) PB to run the required DLL:

PBMss80.dll, Libjcc.dll,pbvm80.dll,pbdwe80.dll, Libjotsclnt.dll, PBRTC80. DLL, PBTRA80. DLLs, Pbodb80.dll, Pbdwo80.dll, Pbdwp80.dll

(2) Required driver DLL for SQL Server client:

Dbnetlib.dll, Dbnmpntw.dll, Ntwdblib. DLL, DBMSSOCN. DLL, Windbver. Exe

2. Configure the Client network:

[Hkey_local_machine\software\microsoft\mssqlserver\client\connectto]

"Servers" = "dbmssocn,servername,1433"

Pbvm80.dll,dbnetlib.dll,dbnmpntw.dll,ntwdblib. Dll

Pbmss80.dll,libjcc.dll,pbdwe80.dll

Have these is enough, in fact, there are 4 of the first line is enough, directly and your EXE into the same directory, do not change the registry, do not install the client, tested in the WINDOWS98 environment can be used.