SQL Server App Deployment

[bsmith]

Try installing MDAC on the machine you are installing to. Then install your application.

[empy]

Sorry, I am new -- what's MDAC and where do I find it?

[bsmith]

MDAC stands for Microsoft Data Access Components. You can download it from http://www.microsoft.com/downloads/r...eleaseID=10730 or you can search your computer for MDAC*.exe. It has already been installed on your computer where the application works. You may also need DCOM95/DCOM98 depending on which windows version you are using, but try the MDAC first. You can search for documentation at the following microsoft site: http://search.microsoft.com/us/SearchMS.asp

Good Luck!

[Glenn]

You need to have the SQL server drivers installed. ON easy way is to install the SQL CLIENT utilites on the machine. Depending on what version of SQL you are using you have some choices to install. If you just want drivers you would install just the SQL Client Configuration Utility (MS SQL 6.5). This will install the necessary drivers.

By the way the one of driver filenames is sqlsrv32.dll

Hope this helps

[empy]

I have SQLSRV32.dll on the machine. Are there other drivers to check for?

I installed DCOM95 and MDAC and the error changed to:

Runtime error 40002:

01000: [Microsoft][ODBC SQL Server Driver][Named Pipes]Connection Open(CreateFile()).'

Please let me know what to try next.

Thanks..

[empy]

Help -- I can access the Remote Db from the machine where I developed the app. When I go to deploy it on a user machine, it gives me the following error:

'Runtime error 40002:

01000: [Microsoft][ODBC SQL Server Driver][dbnmpntw]Connection Open (CreateFile()).'

I used the Setup Wizard to package the app. I am using VB5.

Evidently, some dll may be missing, but I can't figure out which.

Thanks