Different Error Messages when using CR 2013 and Sybase 11

[Former Member]

Hello.

Sorry for my bad english, I'm from Germany.

We want to update to CR 2013. Because of this I have installed the Trail of CR 2013.

Our database is a Sybase SQL Anywhere 11.

When I start a new Report I select the connection via ODBC.

Then I see all views, tables, etc.

Some table can I add to the report, other not.

I got different error Messages.

The messages are in german. Translate they say something like "Database-Connector-Error: Can not retrieve an error Message from the server" or which is more strange, when I want to add the Table with the Name "ABC" I got an error like "Database-Connector-Error: 42S02 Table "XYZ" not found". There is a completly different tablename in the errormessage.

Does anybody knows something about this ?

Is this a problem of CR2013 ?

Thank you

Best regards

Michael

[former_member183750]

Hello Michael

Trolling google, I came up with a few ideas:

1) Make sure the ODBC datasource is System DSN, not User DSN

2) Make sure the ODBC datasource is 32 bit

3) Try an OLE DB connection

4) Make sure the ODBC conection uses a default database, not Master

5) Make sure you are using hte latest DB client

6) Check your database documentation for the error

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member]

Hello Ludek.

Thank you for your answer.

1. The ODBC is a system DSN

2. It's 32 bit

3. I have tried OLE DB with strange results:

If I use "MS OLE DB Driver for ODBC" and select our ODBC I see some table with strange names and some, not all, of our tables. The tables I want to add are NOT in the list from Crystal. If I look in Sybase Central I see the tables.

If I use "Sybase OLE DB Provider" I only see the different "owners". If I want to expand the owner there only the treeitems "no element found".

4. What do you mean with "default database, not master" ? We are using a Sybase SQL Anywhere 11 Database in a HA cluster

5. I have installed the last Sybase (SAP) EBF.

6. In the documentation I have found nothing. The bug must be in CR because the errormessage is also strange, when I want to add a table and the message say that a completly other table where not found.

Is there any chance to get german support for this ? We want to buy > 20 licenences of CR but with this CR is actualy died for us ? If you (or a german supporter) wants to look at this, remote support is no problem.

If this is a problem of the sybase database, could you open a case for this ? We have a sybase (SAP) support contract but actually we can not open cases in the SAP support platform (german SAP Support is informed about this and working on a solution).

Best regards

Michael Meyer

[former_member183750]

Hello Michael

Let's get the money out of the way 1st

You can obtain phone support on a case by case basis. To get phone support visit this link:

http://store.businessobjects.com/store/bobjamer/en_US/pd/productID.98078100

As far as obtaining 20 licenses, etc., please discuss with sales. See the following for best phone number:

http://www54.sap.com/directory/main.html

Now to the issue at hand. I'd like to create a UDL (open notepad and save the file as test.UDL making sure it's not test.txt.UDL, etc.). Now try to connect to the datasource and look at the details of the connection. If you can not see the details here, check with your db admin.

- Ludek

[Former Member]

Hello Ludek.

I hope it was a joke that we should buy a case for a software which we are testing.

I have created an UDL File and opened it with the 32bit "editor":

C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile MYUDLFILE

There I have entered all data and if I click "Test connection" it says "succeded".

If I use this UDL in CR2013 to connect I have the same issue which I habe writen above when I used OLEDB.

What do you mean with "look at the details of the connection" ? Do you mean if I right-click in CR on the connection and then "Properties" ?

Here I see different values like Databaseformat, User-ID, Integrated Security, .....

Or do you mean something else ?

Best regards

Michael

[former_member183750]

No joke, you asked how to get support(?):

Is there any chance to get german support for this ?

I took that to mean that once you obtain the licensed version, you may be interested in phone support...

Anyhow. The UDL has nothing to do with CR. It simply is used to test the ADO DB connection. Double click on the test.udl see if you can connect, etc.

As a BTW.; remember that these are not support forums. These are community forums. Support as such is only provided via phone support, be it on an eval product or full product. Sometimes, issues are just not solvable via forums.

For more details see the blog, What are these 'support' forums good for anyhow?

- Ludek

[Former Member]

OK. With the UDL I can connect to our database.

The connection to our database with CR also works (I see the connected user in Sybase Central).

I also see different tables.

But when connecting via ODBC I can not add some tables to the report.

Via OLE (and UDL) the tables which can not added via ODBC are not visible in the tree.

In Sybase Central and Crystal Report 8.5 (it's old but stable) I see these tables and can add them to a report.

Ludek Uher wrote:
No joke, you asked how to get support(?):
Is there any chance to get german support for this ?
I took that to mean that once you obtain the licensed version, you may be interested in phone support...

OK. But actually buying licences is far far away,

[former_member11696]

Hi Michael,

Forget using OLE DB, all you are doing is putting another connection layer on top of ODBC. If you can expand the OLE DB Providers in CR and then see a Sybase OLE DB Prvider then that would work, otherwsie froget OLE DB.

The errors and info is coming from the Client, CR is simply passing the info through. I suggest you post a question to this forum:

http://scn.sap.com/community/sybase-sql-anywhere

They can enable logging etc. and see what is happening in the client.

What you shoudl do is enable ODBC Tracing and test again, they will want the log.

Don