Connections and Parameters

Me is very confused...

I have a Crystal Report XI report which i am calling out of VB2005 using the normal

Code:

---

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