Skip to Content

Database Connector Error

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Sep 10, 2014 at 05:47 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 10, 2014 at 05:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • avatar image
    Former Member
    Sep 10, 2014 at 05:02 PM

    Hello,

    Check the below threads for ODBC drivers information:

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

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

    Thanks,

    DJ

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 10, 2014 at 05:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded