Connect Crystal Report to Micros

[Marian81]

Hello,

Recently I got the MICROS server replaced and got new one. What I'm trying to do is set up the Crystal Report XI to access and edit my custom reports. Previously I had that installed on the server so there was no problem to work on report.
With new server I need to install Crystal Reports XI on other PC, however I'm not sure how to link with the DB. I know that I need to additionally install sqlAnywhere (i think now is the version 16). Is there any documentation how to set up (connect) to DB? Or does have anybody and experience with this? Any help is appreciated!

Many thanks.

M.

 

[Jackba]

you are using m3700 v 5.4?

if you go to >>create new connection select ODBC(RDO) this should give you alist of the DBs micros should be one of them then once selected it will give you a popup to enter the credentials for db connection

 

[pmegan]

Here's how to create a connection from another computer. You'll need to know if your Micros server and test PC are running 32 or 64 bit operating systems. Micros installs as a 32 bit application, even on 64 bit servers, so it's a little bit tricky.

First, you have to copy the Sybase drivers from Micros to your test PC

Open Windows Explorer on your Micros server and go to program files.

32 bit - go to C:\Program Files​

64 bit - go to C:\Program Files(x86)​

Copy the SQL Anywhere 16 folder to the Program Files (or Program Files (x86) if 64 bit) on your test PC.

Open a 32 bit command prompt on your test PC

32 bit - click Start / Run and type in CMD​

64 bit - click Start / Run and type C:\Windows\SysWOW64\cmd.exe​

if you have a 32 bit OS you can type in CD \ and hit Enter to get a C:\> prompt in the window
If you have a 64 bit OS, make sure the prompt is C:\Windows\SysWOW64> for each of the following steps

Register the odbc driver

32 bit - type regsvr32.exe "C:\Program Files\SQL Anywhere 16\Bin32\dbodbc16.dll"​

64 bit - type regsvr32.exe "C:\Program Files (x86)\SQL Anywhere 16\Bin32\dbodbc16.dll"​

You should receive a "successfully registered" message in the command window.

Open the ODBC data sources snap in

32 bit - type odbcad32.exe​

64 bit - type odbcad32.exe​

The data connections configuration form will open. Click the System DSN tab, and then the Add... button
ODBC tab

Data source name - Enter Micros as the ODBC name​

Check the Microsoft application and Delphi boxes​

Login tab

User ID & Password - enter your database user/pass​

Action - Connect to a running database on another computer​

Host - the name or IP of your Micros server​

Port - 2638​

Server name - "sql" plus the name of your Micros server. So if the name is MICROSSVR, this would be sqlMICROSSVR​

Database name - micros​

Go back to the ODBC tab and click Test Connection. You should get a successful connection message, as long as the Micros server and your test PC can communicate through your network. Click OK to save the ODBC connection.

When you open a report in Crystal Reports on your test server you'll be prompted to create a new connection. Select ODBC and then pick the connection you just created.