Print Page | Close Window

Crystal Report Connection To SQL 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=16674
Printed Date: 21 Apr 2025 at 10:16am


Topic: Crystal Report Connection To SQL database
Posted By: shreyas89
Subject: Crystal Report Connection To SQL database
Date 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.








Replies:
Posted By: hilfy
Date 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


-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: shreyas89
Date Posted: 11 Jun 2012 at 7:29pm
i'll give it a try


Print Page | Close Window