Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Connection to database? Post Reply Post New Topic
Author Message
Jackrabt
Newbie
Newbie


Joined: 16 Aug 2007
Online Status: Offline
Posts: 2
Quote Jackrabt Replybullet Topic: Connection to database?
    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..
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet 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.
IP IP Logged
Jackrabt
Newbie
Newbie


Joined: 16 Aug 2007
Online Status: Offline
Posts: 2
Quote Jackrabt Replybullet 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.


IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.