Power up with new SaaS Add-Ons from the DigitalOcean Marketplace

Question

Connecting Crystal Reports to VPS

  • Posted January 9, 2015

Hello everyone.

I am trying to connect Crystal Reports XI release 2 to my VPS. I am trying to connect with the following step :

In Database expert menu i am selecting OLE DB (ADO) and then selecting Microsoft OLE DB Provider for SQL Server. Then it asks me Server, UserID, Password, Database. I am filling the fileds but when i try to select database it shows nothing. When i leave the database field empty and click on next then it give me the following message:

“Failed to open the connection. Details: ADO Error Code:0x Source: Microsoft OLE DB Provider for SQL Server Description : [DBNETLIB][ConnectionOpen (Connect().]SQL Server does not exist or access denied. SQL State:08001 Native Error: [Database Vendor Code:17]”

Could you please advise.

Subscribe
Share
Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

ardeth • January 11, 2015

I’ve solved that issue with following steps (Assuming MySQL Connector/ODBC already installed in your system) :

  1. Add a new connection from ODBC Data Source Administrator
  2. Select MySQL ODBC 5.3 ANSI Driver
  3. Select TCP/IP radio button and enter your VPS server’s IP address with port number 3306
  4. Fill User and Password field with you database username and database password
  5. Select your database from the drop down list
  6. Click Test button and if everything works fine than click Ok
  7. Select database expert under Database menu
  8. Select ODBC (RDO) under Create New Connection menu
  9. Select your connection and click Next
  10. Enter your database user name and password and click Finish
  11. Add required tables from your database by selecting the table and clicking arrow button.

If you already created a design then open your design in Crystal Report and follow these steps:

  1. Select Set Datasource Location under Database menu
  2. Select ODBC (RDO) under Create New Connection menu which is located in “Replace With” section
  3. Select your connection and click Next
  4. Enter your database user name and password and click Finish
  5. Now select one of your previous tables from “Current Datasource” tab and select the same table in “Replace With” tab then click update. Do it for all tables one by one.
  6. Click close.