Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Crystal Report Connection To SQL database Post Reply Post New Topic
Author Message
shreyas89
Newbie
Newbie
Avatar

Joined: 05 Jun 2012
Online Status: Offline
Posts: 2
Quote shreyas89 Replybullet Topic: Crystal Report Connection To SQL database
    Posted: 05 Jun 2012 at 5:11am

I have a problem connecting to sql database using crystal report 10.
I have a sql 2008 r2 database server name like 66.7.149.27,4433
with 4433 as its default port no.
The problem is with the port no it does not allow me to connect to the sql database.

Code

cryRpt2.SetDatabaseLogon("jaya", "df#556", "66.7.149.27;4433", "jaua1")
this is not working

What should i do to use this sql database with port no for connecting.






IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 11 Jun 2012 at 4:47am

Have you tried using a colon instead of a semi-colon?  It would look like this:  "66.7.149.27:4433"

 
-Dell
IP IP Logged
shreyas89
Newbie
Newbie
Avatar

Joined: 05 Jun 2012
Online Status: Offline
Posts: 2
Quote shreyas89 Replybullet Posted: 11 Jun 2012 at 7:29pm
i'll give it a try
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.023 seconds.