Print Page | Close Window

Connection to database?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1183
Printed Date: 05 Apr 2025 at 5:38am


Topic: Connection to database?
Posted By: Jackrabt
Subject: Connection to database?
Date Posted: 16 Aug 2007 at 2:44am

Hello.

Perhaps an easy question, but troubling to me..

I need to connect to a SQL database which is on a virtual server.

If I want to see the tables in the database, I first connect to the physical computer with WMware remote console, then I choose the right virtual server and then I see the databases which are on that virtual server.

How do do the same with Crystal OLE DB (ADO)? Should I first establish a connection to the physical machine with a some kind of VPN client and then connect to the virtual server and database or what..?

Please help newbie..


Replies:
Posted By: jkwrpc
Date Posted: 16 Aug 2007 at 1:06pm
I do not use VPN but it does seem logical to me that you will have to open the connection before you will be able to connect to the data store. Once that connection is open you should be able to use the ADO connection as you would otherwise since you are effectively at that server. I am not aware of any functionality inside of CR itself to manage a VPN connection. That might need to be integrated with another programming language such as .Net.
 
Sorry I could not be of more help.
 
Regards,
 
John W.
http://www.CustomReportWriters.net - www.CustomReportWriters.net

Posted By: Jackrabt
Date Posted: 24 Aug 2007 at 3:52am

Problem solved.

Reason for that I couldn't connect to db was inadequate rights at db. After getting more rights, no more problems.

And I don't need to establish an VPN connection first. I can connect directly to virtual server and go from there on.


Print Page | Close Window