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.
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
I’ve solved that issue with following steps (Assuming MySQL Connector/ODBC already installed in your system) :
- Add a new connection from ODBC Data Source Administrator
- Select MySQL ODBC 5.3 ANSI Driver
- Select TCP/IP radio button and enter your VPS server’s IP address with port number 3306
- Fill User and Password field with you database username and database password
- Select your database from the drop down list
- Click Test button and if everything works fine than click Ok
- Select database expert under Database menu
- Select ODBC (RDO) under Create New Connection menu
- Select your connection and click Next
- Enter your database user name and password and click Finish
- 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:
- Select Set Datasource Location under Database menu
- Select ODBC (RDO) under Create New Connection menu which is located in “Replace With” section
- Select your connection and click Next
- Enter your database user name and password and click Finish
- 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.
- Click close.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.