title: Connecting Crystal Reports to VPS
body: <p>I have coded a program in VB.NET which is for making proposal and printing invoices. I can connect to my VPS MySQL (Mariadb) database via my software and everything works fine (ADD/UPDATE/DELETE strings). But I also need to gather data from my database to print invoices. For making this I am using Crystal Reports XI Release 2. I need to connect Crystal Reports to my online MySQL database which is located in my VPS to get data and make the invoice ready to print.</p>
  
  <p>Connection options for Crystal Reports are :</p>
  
  <ol>
  <li>Access/Excel (DAO)</li>
  <li>ADO.NET(XML)</li>
  <li>Database Files</li>
  <li>Exchange 5.5 Message Tracking Log</li>
  <li>Exchange Message Tracking Log</li>
  <li>Legacy Exchange</li>
  <li>Mailbox Admin</li>
  <li>ODBC (RDO)</li>
  <li>Olap</li>
  <li>OLE DB (ADO)
  <ul>
  <li>Microsoft Jet 4.0 OLE DB Provider</li>
  <li>Microsoft Office 12.0 Access Database Engine</li>
  <li>Microsoft OLE DB Provider for Analysis Service</li>
  <li>Microsoft OLE DB Provider for Indexing Service</li>
  <li>Microsoft OLE DB Provider for ODBC Drivers</li>
  <li>Microsoft OLE DB Provider for Oracle</li>
  <li>Microsoft OLE DB Provider for Search</li>
  <li>Microsoft OLE DB Provider for SQL Server</li>
  <li>Microsoft OLE DB Simple Provider</li>
  <li>MSDataShape</li>
  <li>OLE DB Provider for Microsoft Directory Service</li>
  <li>SQL Server Native Client 11.0</li>
  </ul></li>
  <li>Outlook/Exchange</li>
  <li>Public Folder ACL</li>
  <li>Public Folder Admin</li>
  <li>Public Folder Replica</li>
  <li>Universes</li>
  <li>XML</li>
  </ol>
  
  <p>I tried to connect to the VPS database in Crystal Reports with the following steps :</p>
  
  <p>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 fields 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:</p>
  
  <pre><code>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]
  </code></pre>