Print Page | Close Window

Crystal Report 8.5 + MSSQL Server 2008 - con. bug

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=11130
Printed Date: 19 May 2024 at 3:45am


Topic: Crystal Report 8.5 + MSSQL Server 2008 - con. bug
Posted By: zhenya
Subject: Crystal Report 8.5 + MSSQL Server 2008 - con. bug
Date Posted: 16 Sep 2010 at 11:54pm

I have issues with connection in application that uses Crystal Report. Issue occurs when CR component initializes connection to database. Application crashes at that point. But when I initialize connection to some directory on server via remote desktop before application starts, then it connects to database successfully. In our project I am using 'CrystalReport' object for report generation. Or connection string looks like

CR_Object.Connect = "DSN=" & gServerName & ";UID=" & gUserName & ";PWD=" & gUserPass & ";DBQ=" & gDatabaseName

with appropriate values. Application connects successfully with the same connection string. I tried to fix this issue using LogOnServer(dll As String, server As String, database As String, userid As String, Password As String) with 'pdsoledb.dll' passed as first argument, but I could not find appropriate dll implementation. How can I fix this issue with connection to data base ?




Print Page | Close Window