Database Connector Error

[former_member1107312]

Hello,

Recently I have updated ODBC drivers for my Unidata to connect to my server that has my database.  From this experience it has been a headache.  I had this software working just fine and the old drivers I don't have any more.  So, I have recently restore my computer to a fresh copy of Windows 7 x64.  And I have set up my ODBC 32bit drivers to connect to my server.  I have test the connection and passed.  There is an utility for the Unidata to see if you connection work, I submitted a query and it shows my results.  When I run Crystal Reports, go to Database expert and set up ODBC connection I can see my tables names (good sign I thought) but when I bring my table names to Selected Tables it gives me this error message:

Database Connector Error: 'S1000:[Rocket U2][U2ODBC][1801668]Error ID: 66 Severity: ERROR Facility: FPSRVERR - UD/ODBC program UCI::SQLColumns falied to execute sql statement: [S1000][U2][SQL Client][UNIDATA]Column_Default is not a field name[Database Vendor Code: 47075904]'

Running Crystal Reports: 14.1.1.1036

SAP Business Objects Crystal Reports 2013 SP1

Any help out would be greatly appreciated.

[former_member1107312 · Accepted solution]

So I finally found the issue.  The newest ODBC driver that I download for Rocket U2 wasn't compatible with my Server for some reason.  I down grade the driver to older reason and tried again and it works.

I would like to thank everyone that reply to my issue.

Cheers.

[former_member183750 · Accepted solution]

And I'd like to thank you for letting us know the solution . Very appreciated.

Happy reporting,

- Ludek

[Former Member · Accepted solution]

Gerald, Can I get that driver? I have the same issue using the 4.00.06.7444 rocket driver.

Are you using the 3.70 driver now?

EDIT

I got a hold of a new rocket u2 driver. Version 7.140.01.8004

The error is no longer plaguing me. Thank you so much Gerald for pointing me in that direction!

[former_member1107312 · Accepted solution]

Carl,

Sorry that I didn't get back to you sooner.  I am glad that you have it fix.

[former_member205840]

Hi Gerald,

I think when you look at the error message, it is not finding relevant columns which are there in your report / database.

Database Connector Error: 'S1000:[Rocket U2][U2ODBC][1801668]Error ID: 66 Severity: ERROR Facility: FPSRVERR - UD/ODBC program UCI::SQLColumns falied to execute sql statement: [S1000][U2][SQL Client][UNIDATA]Column_Default is not a field name[Database Vendor Code: 47075904]'

If you look at the bold ones, the COLUMN_DEFAULT is not a filed name it says.

To test ODBC connection, can you try to create a new report ?   If you are able to create then we can look into report columns.

Thanks,

Sastry

[former_member1107312]

I have tried to create a new report and I received that message.  I also have tried to open a report that I have created in the past and I receive the same error message.

[former_member183750]

Hi Gerald

I'm not sure that the SCN Discussions provided by DJ will help...

But here is my stab at it:

1) CR 2013 is now on SP 3, so it would be great to get you to that SP. You will have to contact sales for a link (866-681-3435).

Worldwide Office Locations | SAP

2) Database Vendor Code: 47075904, is coming directly from the DB client. You should be able to look up the error on your DB documentation, see what it's all about.

3) See if the sqlconn32 utility can logon and retrieve data from the database.

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[former_member1107312]

I will look into this.  thank you.

[Former Member]

Hello,

Check the below threads for ODBC drivers information:

http://scn.sap.com/thread/3614628

http://scn.sap.com/thread/3614151

Thanks,

DJ

[former_member1107312]

Thanks for the links but it didn't apply for what I need.