Home on the web ~ Dan Van Fleet

Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

Home on the web ~ Dan Van Fleet - Information on SoftPro ProForm with some general computer tips and techniques, with a bit of me.

ProForm Classic Client install Database Error

imageDuring an installation of Softpro Classic SQL it is possible to run into a SQL database check error that won't let you continue.The Error is Unable to establish a connection to the SQL Server

clip_image002 

clip_image003There are a couple of things that can cause this issue.

First let's see if there are any ODBC connectors setup.

On 64 bit machines start %windir%\syswow64\odbcad32.exe

on 32 bit machines start, %windir%\system32\odbcad32.exe.  Using this on 64 bit machines will lead you down a dead-end path, which can cause issues.

It should look something like the picture, if you don’t have an SQL installation, this document likely won’t help.

 

If it does not

  clip_image004Run SpSqlReg.exe from theSoftPro Share, usually \\servername\Softpro, by right clicking and selecting Run as Administrator. 

Click GO, it will report 7 or more Database's registered

clip_image005

The setup will likely still fail at this point

Restart OdbcAd32 to see the update. Click on the System DSN tab.

 

clip_image006

 

Double click on a Data Source, or select one and click Configure.clip_image007

 

Click Next

 

 

 

 

 

clip_image008

Click Client Configuration

Change the Client Settings of The Database to Named Pipes, the installation should now work.

clip_image009

If it is already Named Pipes, Check the SQL server to see if Named Pipes are enabled for the database instance, or try TCP/IP explicitly on Port 1433, and dynamically.

A single update here affects all ODBC connectors to the instance specified. Typical installations have one instance for SoftPro thus this only needs done one time.

The DSN Configuration window can be closed

Click Next, Next, Finish, then either Test and OK.

If your installer is still open, click back then Next, and the SQL Server Connection Check will pass.

After the installation the settings may return to dynamically determine port, polling 1433 to start the connection, no worries as long as SoftPro apps run.

clip_image010

An error in these settings also cause a PFWIN-028 error when starting a SoftPro ProForm client program. Sometimes followed by a SPFUNCS-63174 Error, unable to open licensing file as it has no idea where the shared folder is and looks locally for it.

I have had to uninstall the client when the ODBC connector tests good, but ProForm fails to find it’s database. Classic has a nicely updated and running installer, it uninstalls everything important, so re-installs are more likely to solve problems than in earlier Enterprise 6 or Standard 12 installations.

Category: SoftPro

Your email address will not be published. Required fields are marked *

*

css.php