BO 4.0 ODBC Errors

[Former Member]

Hi everybody,

I am using Information Desing Tool IDT (formerly Information Desinger) to create a new model with mulit data sources - but there are some critical problems with the odbc.

In Win7 I created several odbc sources that I want to use in IDT. The sources are a MS Access, a mySQL as well as a SQL Server 2008 Enterprise database. After creating a project in IDT, I create the data base connections. After creating them, I test it by selecting "show values" within the connection - which was successful. Than I publish it in the repository for make it for data foundation.

The error with the ODBC accurs after selecting the connections from the repository. If I try to open the connection in the section Data Foundation the message

"[Data Federator Driver] [Server] [Connector 'my_SQLSERVER'] The database has reported an Exception: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQLState: IM002, Vendor code: 0)"

Does anybody have an idea where the error comes from and how to fix it?

Thank you in advance.

Thom

[former_member136842]

Hi,

do you have the same ODBC connections on your Server as on your Win7 PC?

Regards

-Seb.

[Former Member]

Hi Sebastian,

in Win7 I created a User DSN which I used as a ODBC source. On the server I dont have the same connection.

But why can I access the data in the preview and not using them in the connection??? That does not make sense to me.

Or is this just a bug in Business Objects 4.0??

Regards

Tom

[former_member793810]

Hi,

Why don't you create your DS using System DSN? Why are you using User DSN?

Regards,

Bashir Awan

[Former Member]

Hello Bashir,

I have been creating both - User and system DSN but it wont work eighter.

Nevertheless this does not solve the problem with the connection. I still can see the data in the tables while creating a connection in Information Design Tool.

If I want to use the connection in the data foundation the exception occurs.

Regards

Tom

[former_member136842]

Hi,

do you have also CR installed? Check if you can access the data directly with CR. If yes there is a problem with the IDT and maybe its a bug. If also not possible with CR there is a problem with the connection.

Regards

-Seb.

[Former Member]

Hello Sebastian,

what is the CR or what do you mean by it?

Do you know how I can figure that out?

Regards

Tom

[former_member793810]

CR mean Crystal Reports.

And when you make connection in Information Design Tool does it respond or not?

Regards,

Bashir Awan

Edited by: Bashir Awan on Oct 17, 2011 5:49 PM

[Former Member]

Hello Bashir,

If I create a connection and publish it in the repository I can look up the data (by selecting the table by switching the tabs --> show values)

But after publishing successfully the connection in the repository and using the connection shortcut in the data foundation - the error will occur.

In Crystal Report I wont be able to use the created data base connection because it is only allowed to use universes. And I am not able to create on with IDT.

So if this is a program bug, how does it get fixed????

Regards

Tom

[former_member793810]

This is what happenning after every time you publish the connection or it is happening with one specific connection.

I tried to replicate but did not come across such error.

Thanks

Bashir Awan

[Former Member]

Hello Thom,

If you're on Windows 7, are you on a 32-bit or 64-bit version? If you're on a 64-bit version or have a server with 64-bit verion, then you need to go to the 32-bit ODBC setup within the windows directory.

The ODBC setup application in the control panel points to the 64-bit version. However, BOXI (And Crystal Reports) tends to look at the 32-bit ODBC, even on a 64-bit computer.

For Windows 7, make sure that your drivers are setup using the 32-bit ODBC.

To setup an ODBC link for 32bit application you must use

C:\Windows\SysWOW64\odbcad32.exe

To setup an ODBC link for 64bit application you must use

C:\Windows\System32\odbcad32.exe

If you're on windows 7, Give this a try and see if it helps.

/edit - Here is the official Microsoft page on the 32/64 bit ODBC paths.

http://support.microsoft.com/kb/942976

-Travis

Edited by: Tdirmyer on Oct 18, 2011 8:49 PM

Edited by: Tdirmyer on Oct 18, 2011 8:50 PM

[Former Member]

Hi Bashir,

yes this happens every time after publishing the connection.

Regards

Tom

[Former Member]

Hi Travis,

on WIN7 is a 32-bit version. The server has a 64-bit version.

Nevertheless it is quite confusing that I can connect to the database and lookup the content of the tables within the created connection (*.cnx). If there is a problem with the 32/64 bit versions I exspect an error by the creation of the connection.

What about the Data Federator Part and the SQLState?

Tom