Accpac CRM installation error

Hi all,

I am getting error "There was a problem running osql please check that the program location is in the system path" while installing sage accpac crm.

Version of Sage Accpac Erp : 5.5
Version of sage Accpac CRM: 6.1

Please Help.

Regards,

Vikas
kavinagpurAsked:
Who is Participating?
 
Craig YellickDatabase ArchitectCommented:
Now that you know the correct path it must be added to the system search paths so when AccPac tries to execute "OSQL.EXE" without a path specified, the operating system will search the system paths.

In the System Properties dialog on your server, on the Advanced tab, you will see a button named Environment Variables.  From there, find a setting named Path and you'll see a semicolon delimited list of file paths: add the SQL Binn path to the list.
0
 
Craig YellickDatabase ArchitectCommented:
OSQL.exe is a command line utility for submitting statements and scripts to SQL Server. Sounds like the path where OSQL.exe is installed is not part of the system path and the AccPac installer does not fully-qualify the path.

The usual location of OSQL.exe is in the ...\nn\Tools\Binn folder where SQL Server is installed, where nn is the version number, for example 80 or 90.
0
 
kavinagpurAuthor Commented:
OSQL.exe is in C:\Program Files\Microsoft SQL Server\90\Tools\Binn

Please help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.