Connecting Crystal Reports to VPS

January 9, 2015 1.8k views
ardeth
By:
ardeth

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.

Log In to Comment
1 Answer
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.
Reply
Have another answer? Share your knowledge.