Export Crystal Report using ODBC

ccmin

I set the ODBC from Control Panel -> Administrative Tools -> Data Sources (ODBC) -> System DSN -> Add ... Add a new called "Data Source".

I use the sample Crystal Report XI to test this. I call out the report. Then
I Click on the Export button, Export box pop out to enter format and destination. I choose ODBC, then ODBC formats box come out, I choose the "Data Source" which I created. After click OK, a message box ask to enter the Table Name. By default, the Table Name is point to CREXPORT. I got stuck here, what is this Table Name? :shock:

I try to create a folder called CREXPORT under ODBC, but this doesn't help at all.

If I blank it or let it by default, then click OK, error message saying
"Failed to export the report.
[Simba][SimbaEngine ODBC Driver]Invalid cursor state."

Any of our friends meet this before? Can share ur experience?

Savatage

Native or SQL Version?

cunny

Hi, ccmin
First you need to install NODBS not ODBC, and NODBC is Microsoft Navision Software's implementation of Open DataBase Connectivity (ODBC). NODBC lets you transfer data between Microsoft Navision databases and any program that supports ODBC.And Its no problem for your procedule,you just need to install NODBC firt . You can use EXCEL to have a test to check if the NODBC has been istalled successfully or not. QUERY the Navision Database Server.

ccmin

Hi Savatage and Cunny,

I'm using the SQL version.
No problem for importing data into the Excel, even connect to Navision database.