Print Page | Close Window

crystal report is not working with sql server 2005

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=9823
Printed Date: 18 May 2024 at 4:44pm


Topic: crystal report is not working with sql server 2005
Posted By: aryan_srms
Subject: crystal report is not working with sql server 2005
Date Posted: 26 Apr 2010 at 11:39pm
I have one application on vb 6.0 and backhand is sql server 2000, now we are planning it to migrate to sql server 2005.
 
My application and sql server is in different location. Now problem is we are not able to connect sql server 2005. We are getting 'Server has not yet open'.
 
In code we are using
app.LogOnServer "p2ssql.dll", GBserver, sDatabaseName, gsReportUser, gsReportPwd
 
Please help me



Print Page | Close Window