×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

error=49153
2

error=49153

error=49153

(OP)
I have just installed Accpac 5.6 workstation setup and setup the SQL Native Client in ODBC but now when I run Accpac ERP and put in my USER\PASS  I get...

"Cannot access database (error=49153. See help for more information."

Note: this is a Windows 7 machine. Is there compatibility issues?
  

RE: error=49153

49153 means the SQL server you're referencing isn't running, or isn't accepting remote connections.

RE: error=49153

(OP)
So all the other workstations are running fine.  I have looked and tested many times but I must have a problem in the ODBC settings.  Is this the right direction to look.

Perhaps this "computer" is not authorzed to accept remote connections.  
 

RE: error=49153

There are no compatibility issues, I'm running 5.6 and SQL 2005 on Win 7 and it's just fine. As Tuba said, check the SQL server remote connections and turn of the firewall on the server.
BTW why are you creating ODBC DSNs? If done right then this is not necessary on a workstation, unless you are running a 64bit OS.

RE: error=49153

Or Windows Firewall is running.
Or the DNS is wrong, and the server name isn't resolving.

RE: error=49153

(OP)
Turning off the windows firewall didnt work.

I may be getting outside of my paygrade here but thats how my Accpac Provider taught me to do my workstation install.

First I run \\servername\ACCPAC56\WSSetup\setup.exe
set the program and data directories.

Second I go to Data Sources (ODBC) and under System DSN tab click Add_SQL Navive Client and setup using my servername and server user\pass.  Test connection.

Are you saying the System DSN step is not required?

RE: error=49153

(OP)
I now see that the system I bought is setup as 64-bit.  Im assuming this may be a factor.

RE: error=49153

Start, Run, %WinDir%\syswow64\odbcad32.exe
 

RE: error=49153

(OP)
That did it.  Thanks.  Great forum.  Quick!!!

RE: error=49153

In Accpac database setup I always use the server name instead of an ODBC datasource name (the bad way of setting it up), that way you do not have to manually create ODBC DSNs on each 32 bit workstation - except for 64 bit workstations. With 64 bit workstations you need to run the 32bit ODBC admin and create the DSN, and remember to delete the 64bit DSN.

RE: error=49153

To Djangman,

I just installed Accpac on a Windows 7 64-bit pc and we get error 49153 saying there is a DSN architecture mismatch between the Driver and application.

I tried Start, Run, %WinDir%\syswow64\odbcad32.exe as you said  But it only brings up the ODBC properties/setup window- is the command supposed to fix the problem?



 

Yorkshireman2

RE: error=49153

You are supposed to fix the problem in the ODBC administrator that pops up. You need to create and System DSN for the SSQL Native Client and use the server name + 32 for the DSN name, i.e. if your server name is server then the DSN name will be server32.

RE: error=49153

Thanks ettiene,
I'll try this tomorrow.
Chris

Yorkshireman2

RE: error=49153

ettiene,
Thanks-  got Accpac opening ok like that.
The last problem is that this one user gets a crash in the Technisoft Service Manager add-in when she clicks 'View Custom Fields' in v/m document entry-> new document.

But Accpac does run in Windows 7 64 bit now- thanks.
 

Yorkshireman2

RE: error=49153

You might try turning off DEP for the VM executables.  Service Manager screens are all separate .exe files whereas Accpac screens are .ocx files (activeX controls).

Technisoft support might have a solution as well.

RE: error=49153

I emailed Technisoft - no reply yet.
This is odd... We gave this lady a new Accpac user id to try and she now finds that the View custom fields button works properly- no crashing.  (Note that her old login began to cause the same problem on her old XP computer as well after using the login on the Windows 7 PC.

BUT.. now whenever she tries to use Accounts Payable, receivable etc. it tries to run an install process and fails, saying that an ocx control is not registered properly.
 

Yorkshireman2

RE: error=49153

Login on that computer with administrator rights and then right-click on REGACC.EXE (found in the \Accpac\Runtime folder) and Run As Administrator.
 

RE: error=49153

Oh- forgot to add.. the installer fails with th is type of error:
Copy Error" An error occurred while copying fiel (1)ACCPACPO1210.OCX.
Cannot copy file to destination directory".

The details that came up were:
*** Code Download Log entry (23 Apr 2010 @ 11:49:45) ***
Code Download Error: (hr = 80040154) Class not registered

Operation failed. Detailed Information:
     CodeBase: C:\PROGRAM FILES (X86)\ACCPAC\PO53B\ACCPACPO1210.OCX
     CLSID: {7D0E9463-D0F4-4A3D-AEEB-58FE1D9D20ED}
     Extension:
     Type:

LOG: Setup successful installing: ACCPACPO1210.OCX to (null) destination code(0)
--- Detailed Error Log Follows ---
LOG: Download OnStopBinding called (hrStatus = 0 / hrResponseHdr = 0).
LOG: URL Download Complete: hrStatus:0, hrOSB:0, hrResponseHdr:0, URL:(file:///C:/PROGRAM%20FILES%20(X86)/ACCPAC/PO53B/ACCPACPO1210.OCX)
LOG: Setup successful installing: ACCPACPO1210.OCX to (null) destination code(0)
LOG: Version not identified for , using 0.1.
LOG: Reporting Code Download Completion: (hr:80040154, CLASSID: 7d0e9463..., szCODE:(C:\PROGRAM FILES (X86)\ACCPAC\PO53B\ACCPACPO1210.OCX), MainType:(null), MainExt:(null))

-----------

This used to happen last Thursday then it stopped (not sure what I fixed) but the crash from 'View Custom fields' problem remained.
Now the crash problem is fixed with a new login, this other problem is back!
The fact that her old login used to work in XP but now has the same problem after using Windows 7, seems to suggest that the Windows 7 has corrupted her user account profile or something?
Therefore the new login account allows her to use Service Manager without the Custom fields crash, but she can't  use anything else in Accpac now.
  

Yorkshireman2

RE: error=49153

Rule #1 of Vista and Windows 7 is not to install to the default Programs folder.

Rule #2 is that you shouldn't be doing location program installs, but that's another argument.

 

RE: error=49153

Follow rule #1 (and #2) but in this case #1 is very important.

RE: error=49153

Just to add to that... run scanisam to see if you have any corrupted user isam files.

RE: error=49153

Hi- please explain- I have always followed a set of install instructions made up a couple of years ago and they say use the defaul install location.

Where should I install it to?

 

Yorkshireman2

RE: error=49153

oh-- and what is scanisam?
Where can I find it?

  

Yorkshireman2

RE: error=49153

Read the installation documentation for Accpac 5.6 - it specifically says do not install to the default folder on Vista/Win7.
Start, Programs, Accpac, Tools, Scanisam

RE: error=49153

Ah- we have Accpac 5.3 so the install instructions probably wouldn't include Windows 7 on them. To be honest I don't know where the install documentation for this one is either- It was all done long before I was asked to look at this.
I only know a set of instructions in a .txt document, made up by our previous IT man (died suddenly last year).


"Rule #2 is that you shouldn't be doing location program installs"  please explain what you mean by 'location program installs'.
 

Yorkshireman2

RE: error=49153

You shouldn't be installing Accpac on each workstation, it's extra work when you need service packs.  You put it on a shared network location, then run ..\Wssetup\Setup.Exe on each workstation.

RE: error=49153

Tried scanisam- no errors were described- just a lst of files printed out in the results window.

I have set REGACC.EXE to run as administrator.
Also removed the ODBC connections and re-added them using syswow 64 odbcad32, naming then with a It complained about database specification.
I had to remove the 32 from the name. It seems Accpac expects the proper database name without any 32 added.


Our boss gave this user two new login accounts today and she finds one new account lets her use the View Custom Fields of Service Manager on the Windows 7 PC (but other ACCPAC fetaures trigger the ACCPAC installer and the 'fail to instll' message.
If she runs into the next office, the old login on her XP PC allows her to use the ACCPAC features but no custom fields feature.

We are about to scrap the Windows 7 PC and not allow anybody to upgrade to a new PC ever.
There was no problem with the old XP computer originally.
 

Yorkshireman2

RE: error=49153

What about running in XP compatibility mode (assuming you have the 'high' enough version of Win7)?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close