ODBC
Posted: Thu Jan 03, 2013 11:05 pm
I'm trying to configure Crystal Reports and get it to connect to a BR ODBC Data Source using BR's ODBC driver. I believe I have the dictionary properly entered into context but its possible that this is where my mistake is.
Crystal Reports can see the BR data source just fine. The Crystal Reports Report Wizard shows me a list of the tables (data files) in their system. Most of the files contain both strings and numeric fields, but a couple contain only string fields.
If I try to select a file that has numeric fields in it (usually BH), I get this error: "Database Connection Error: '22003:[ADS][BRODBC Driver]Out of range [Database Vendor Code: 1011 ]'"
If I try to select a file with only string fields in it, Crystal Reports accepts the selection and the Report Wizard completes as normal. However, as soon as Crystal Reports tries to display the data on the screen (in their Report Preview window), Crystal Reports crashes.
I have one file in my system that has only strings, and the data file is empty. That file works fine, and Crystal Reports displays the completed empty report. This leads me to believe that its failing when the data is being sent to Crystal Reports.
I'm using the latest ODBC, and the latest Crystal Reports, CR 2011. I downloaded the demo from their website a couple days ago. .
I know some of you are using ODBC .. has anyone run into anything like this?
If I am missing some key piece of information in context, where should I start looking?
Crystal Reports can see the BR data source just fine. The Crystal Reports Report Wizard shows me a list of the tables (data files) in their system. Most of the files contain both strings and numeric fields, but a couple contain only string fields.
If I try to select a file that has numeric fields in it (usually BH), I get this error: "Database Connection Error: '22003:[ADS][BRODBC Driver]Out of range [Database Vendor Code: 1011 ]'"
If I try to select a file with only string fields in it, Crystal Reports accepts the selection and the Report Wizard completes as normal. However, as soon as Crystal Reports tries to display the data on the screen (in their Report Preview window), Crystal Reports crashes.
I have one file in my system that has only strings, and the data file is empty. That file works fine, and Crystal Reports displays the completed empty report. This leads me to believe that its failing when the data is being sent to Crystal Reports.
I'm using the latest ODBC, and the latest Crystal Reports, CR 2011. I downloaded the demo from their website a couple days ago. .
I know some of you are using ODBC .. has anyone run into anything like this?
If I am missing some key piece of information in context, where should I start looking?