MAS 200 ODBC driver

[yipster]

Is there a way to setup MAS 200 ODBC driver to speed up Crystal Reports printing over a WAN. I search over a the internet and cannot find anything. Would anyone know?

Much thanks,

-y

 

[HiTechFred]

What SOTAMAS driver are you using? What version of MAS200? We are running 4.05 with provideX ver. 3.33 and some reports are slow.

 

[getrav]

There is a Client Server ODBC driver in 4.10 but there is no documentation yet.
I called Sage Software & they told me that you install the client on the server so the ODBC driver will be installed.
Type your server's name and the default port # is 20222.

I am not sure of the aptitude of this particular tech support rep but I am going to try it out today.

Rav

 

[dgillz]

If this is a providex database, get used to it. It is just slow. If you are running MS SQL Server however then you should be blazing.

So which are you running? You sidestepped HiTechFred's direct question on this.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[yipster]

Yea I found out how to get this up and running. This works great, all my reports are 80% faster than before.

Reports comes up in 20 secs over wan before it took like 2 mins and longer.

 

[dgillz]

ypister,

So what was the problem and the solution? Without providing this info, this thread is meaningless to anyone searching in the future that has the same problem you had.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[yipster]

the server needed to be started at all times. just make a shortcut and drop it into the startup folder and it starts up automatically. hopes sages make a service for this and that would be great.

 

[chrisp909]

I guess he was using 4.10 and started using the server side driver. BTW: it does run as a service.