on 09-10-2014 5:26 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Check the below threads for ODBC drivers information:
http://scn.sap.com/thread/3614628
http://scn.sap.com/thread/3614151
Thanks,
DJ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.