Invoice printing error

[dbant2009]

A user received a new computer and when they try to print on invoice in OE the error Crystal Reports Viewer Failed to open the connection is given and the invoice will not print. I remeber having this issue in previous insatnces but it has been over two years since we had this problem. We are using ACCPAC 5.4A and service pack 2 for OE in MS-SQL. Any idea on how to fix this problem.

 

[ettienne]

Copy OERPT.INI from a computer where the invoice is printing.

 

[Jay Converse]

And stop installing Accpac programs on each PC, that's why networks were invented.

 

[dbant2009]

Copying the oerpt.ini from a computer that works to this computer, it did not work. I also deleted the data source on the computer and added it again to see if this would work, which did not.

 

[Jay Converse]

Don't add the data source manually. Delete it again, and let Accpac add it.

 

[dbant2009]

That sounds good but how do you do that.

 

[Jay Converse]

Do what?

 

[dbant2009]

Have ACCPAC add the datasource, we always add it manually.

 

[Jay Converse]

It does it when you login, and has for years. You only have to add Pervasive and Oracle manually.

 

[dbant2009]

Tried that and then it tells me an invalid database specification. I did remove the datasource before trying to log in.

 

[Jay Converse]

Make sure that everything in Accpac Database Setup is a Server name, not a DSN.

 

[dbant2009]

Unfortunately this is how the system is set up with DSN. What is needed to change that or can it be changed now?

 

[ettienne]

Change it in Accpac Database setup, using an ODBC DSN is a dumb way of doing the setup.

 

[dbant2009]

If only IT were smarter about this but we are at their mercy. Can we change this so that we don't have to do the DSN method anymore.

 

[Jay Converse]

Yeah, tell your IT department they're stupid, and let you do it the right way!

 

[dbant2009]

So I went and changed in Database setup for one of our databases to a server. Authorized a user to access and had them log into the comapny. Checked to make sure the DSN was not there for the user. It worked and I tried a second user the same way. So my question then is if I was to change the other databases to the server and did away with the DSN's would this caue any problems in doing it this way. If this work it would do away with a couple of other problems that needs correction once in awhile.

 

[ettienne]

It does not cause problems, everyone runs Accpac that way, only ID10Ts use DSNs in the database setup.

 

[dbant2009]

You guys are really making me feel stupid here. I am going to change this next week and go from there. Thank you.