Hi, looking for some help here. I have a bundle of prebuilt Crystal reports that came with some phone software. I have the reports open in Crystal XI, (they use SQL Server 2000) as datasource. I am connected to them via an OLE DB ODBC connection. Question, they use stored procedures to get the data. How can I see the name of the stored procedure that they use? I tried refreshing the data and am getting an error, “Error converting data type varchar to datetime”. I want to troubleshoot this but looking in the “Set Datasource Location” panel I see the database. But, it doesn’t show me specifically what stored procedure it’s using. How can I find this out?
Try to look at the “Set Datasource Location” again… Somewhere below the DB properties you should find another table like with a properties “TABLE TYPE: Stored Procedures” there…
i have a set of crystal reports with OLE DB connection and we are using stored proc to fetch data. Now the requirement is to change the connection from OLE DB on SQL 2005 to ODBC on same server with different database. But we are getting data type mismatch issues . With OLE DB connection object are showing correct data type either string or number means what ever it is . but with ODBC connection its showing only number data type. Has any one faced same issue . Please revert back
