Crystal Reports for VS 2005

Hi, currently I am using Visual Studio 2005 to create a Crystal reports for my application, when i choose the data source from a list of driver, normally we will use OLE DB Provider for SQL Server,

but I saw other provider in the list, which is SQL Native Client, can I use this instead of OLE DB?Hi johnlim,

Yes, you can use the SQL Native client, but it does involved extra supporting files being inlcuded in your setup project. Basically, I would not use it unless you specifically need to access the SQL MDF/LDF data files directly. This is not normally the case with reporting.
I use the ADO provider. It works well and is supported on lots of forums, like this one.
cheers,
Mark Chimes

Quote:

Originally Posted by johnlim20088

Hi, currently I am using Visual Studio 2005 to create a Crystal reports for my application, when i choose the data source from a list of driver, normally we will use OLE DB Provider for SQL Server,

but I saw other provider in the list, which is SQL Native Client, can I use this instead of OLE DB?

Crystal Reports driver for SQL Server 2005

I use Crystal Reports with SQL Server 2005. Which driver (ODBC or OLEDB) should be used when connecting Crystal Reports to SQL Server 2005. Business Object support forum has an article (which is old) says to use ODBC. That it is faster than OLEDB. They have a more recent article which state to also use ODBC when upgrading Crystal Reports 8.5 to XI and connecting to SQL Server.

But then I read the OLEDB is the new interface and should be used instead of ODBC which is going away.

Which is preferred for Crystal Reports XI?

ODBC is not going away.

In general, there is no preferred interface - though 3rd party suppliers may have their own good reasons for making recommendations for users of their applications. Both APIs have their strong points. ODBC is the most widely used, but there are places where OLE DB can be a better choice. The choice depends on the needs of the application

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

Crystal Report using SQL CE

I've created an app that connects to a SQLCE database. I need to create Crystal Reports that connect to the database. There is no ODBC driver for SQLCE. How can I do this?

Thanks,

Kathy

Can you use OLEDB with Crystal Reports, the provider name is:

PROVIDER=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0

|||

Erik, I'm missing something along the way.

I've ran C:\WINDOWS\system32\regsvr32.exe sqlceoledb30.dll but don't see sqlserver mobile 3.0 under the OLEDB connections I can define in Crystal. I've also tried sending the connection through code and get the following error. Public member 'DataSourceConnections' on type 'Crystal Report Class'

Errors at

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

Code:

Dim rpt As New Quote " name of report

Private Sub loadreport(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

Dim path1 As String = My.Application.Info.DirectoryPath '' path

Dim con As New OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=|DataDirectory|\sales_quote.sdf")

Dim com As New OleDbCommand(" SELECT Quote_Header.Quote_Num, CUSTOMER.sh_name, CUSTOMER.sh_street," & _

"FROM ((Quote_Header Quote_Header INNER JOIN Quote_Line Quote_Line ON " & _

"Quote_Header.Quote_Num=Quote_Line.MQUOTE_NUM) LEFT OUTER JOIN SALESMAN SALESMAN ON Quote_Header.Salesman=SALESMAN.sm_salenum)" & _

"LEFT OUTER JOIN CUSTOMER CUSTOMER ON Quote_Header.ShipNum=CUSTOMER.sh_shipnum " & _

"WHERE Quote_Header.Quote_Num='" & 18 - 2209 - 7 & "' ORDER BY Quote_Line.QUOTE_AREA")

com.CommandType = CommandType.Text '' command type

com.Connection = con '' give connection to command

Dim adp As New OleDbDataAdapter '' declare adapter

adp.SelectCommand = com '' select command for adpapter to work on

Dim ds As New DataSet '' delcare dataset

adp.Fill(ds, "sales_quote") '' fill the dataset through adapter

Try

rpt.DataSourceConnections.Item(0).SetConnection("", "" & path1 & "\sales_quote.sdf", False)

'rpt.DataSourceConnections.Item(0).SetLogon("admin", "")

Catch exp As Exception

MsgBox(exp.Message)

End Try

rpt.DataSource = ds '' select the Dataset to the source of the report

CRViewer1.ReportSource = rpt '' assign the report to the crytal reprot viewr (cr1)

Can you tell me how to set the connection through Crystal Reports set database location or what I'm missing in my code.

Thanks,

|||

I don't understand the purpose of this line of code:

rpt.DataSourceConnections.Item(0).SetConnection

You already have filled a dataset (ds), and set this dataset to the datasource of the report.

Excuse my Crystal ignorance....

|||

I want to create a report with crystal report 9 and my database is sql server ce on pocket pc. How I connect to tables on sql server ce inside crystal report? I install sql server 2005 on my pc but there is'nt any provider in crystal report 9 that I can connect to tables on sql server ce. please help me.thank you

|||

i have the same prob to connect to SQL CE with CR11 ,the sqlceoledb30.dll is not realized by CR11

|||

Please contact Crystal support with this issue.

|||

Has anyone found out how to do this? Any replies from Crystal?

I've been looking around the net and haven't found any info on how to use Crystal with sql ce.

|||

In case anyone's still looking, I finally got around this by using XML data definitions. A good example can be found here:

http://www.vbdotnetheaven.com/UploadFile/krishnajina/CrystalReportwithXmlInVB11102005001552AM/CrystalReportwithXmlInVB.aspx

crystal report exits on access MS-SQl server 2000 and 2005 with O

Setup details:
Crystal report : 8.5
Ms-Sql server 2000 and 2005
Crystal report uses MSSQL ODBC driver to get the data from database and
displays in crystal report. When i have large number of data the crystal
report exits after 1 hour. In the temp folder of windows file is created onc
e
it crosses 2 GB crystal reports exits.
Why i'am posting this issue here is the same size data i try to access from
sybase/oracle it works fine. So i thought it would be related to ODBC driver
.
Can somebody help me on this.You are really sending that much data across the network? I
would really, really, really look at changing that. Whether
in works in some scenarios or not seems beside the point.
But...if you want to check your MDAC version, you can
download the component checker from:
http://msdn.microsoft.com/data/ref/mdac/downloads/
-Sue
On Mon, 11 Sep 2006 23:39:01 -0700, Sanjeev Kumar <Sanjeev
Kumar@.discussions.microsoft.com> wrote:

>Setup details:
>Crystal report : 8.5
>Ms-Sql server 2000 and 2005
>Crystal report uses MSSQL ODBC driver to get the data from database and
>displays in crystal report. When i have large number of data the crystal
>report exits after 1 hour. In the temp folder of windows file is created on
ce
>it crosses 2 GB crystal reports exits.
>Why i'am posting this issue here is the same size data i try to access from
>sybase/oracle it works fine. So i thought it would be related to ODBC drive
r.
>Can somebody help me on this.