SunshineBH
Oct 19th, 2007, 07:54 AM
Me is very confused...
I have a Crystal Report XI report which i am calling out of VB2005 using the normal
Me.CrystalReportViewer.ParameterFieldInfo = Parameters
Me.CrystalReportViewer.ReportSource = ReportName
And all goes well, until we went live with the report.
It was originally connected to the datasource (a SQL 2005 database) using ODBC. When the report accesses the live server it comes up with login problems and claims that it cant identify the parameters etc...
I changed the connection in the report to use OLE and the problem dissapeared and it works fine now - just like it did in the test environment.
Now i must confess that i am confused - i was always under the impression that ODBC was better to use in this type of environment. Anyways if somebody out there could clear up my confusion i;d be really :)
thanks in advance
I have a Crystal Report XI report which i am calling out of VB2005 using the normal
Me.CrystalReportViewer.ParameterFieldInfo = Parameters
Me.CrystalReportViewer.ReportSource = ReportName
And all goes well, until we went live with the report.
It was originally connected to the datasource (a SQL 2005 database) using ODBC. When the report accesses the live server it comes up with login problems and claims that it cant identify the parameters etc...
I changed the connection in the report to use OLE and the problem dissapeared and it works fine now - just like it did in the test environment.
Now i must confess that i am confused - i was always under the impression that ODBC was better to use in this type of environment. Anyways if somebody out there could clear up my confusion i;d be really :)
thanks in advance