Datasource Name not Found

[Former Member]

Hi I am trying to update a template on a Windows Server 2008 box (64-bit), using Crystal Reports XI Service Pack 4 and an Oracle 10g datavase. I've configured a system OBDC data source (and tested it with the test button on the OBDC Admin. screen) the with appropriate DSN for the template. However, when i try to refresh the template , after giving the username and password, i get the following error:

"Failed to open the connection

Detals: IM002: [Microsoft] [OBDC Driver Manager] Data source name not found and no default driver specified"

There's definately nothing wrong with the template as it has previously been tested on a Windows Server 2003 machine and running Oracle 10g (although with an older OBDC driver for Oracle). Has anyone encountered this before.

Thanks in Advance.

Best Regards

Jimmy

Edited by: dct374 on Aug 13, 2009 1:45 PM

Edited by: dct374 on Aug 13, 2009 1:45 PM

[former_member11696 · Accepted solution]

Hi Jimmy,

Create the DSN in the 32 bit Control Panel. Possibly you created the DSN using ODBC admin in the 64 bit Control Panel....

You may have to browse to it, they are both named odbcadm32.exe and are in syswow and system32 folders.

Thank you

Don

[Former Member · Accepted solution]

Hi Don,

Many thanks for your reply. I can confirm it has been configured in the 64-bit Control Panel. However, when i opened up the ODBC Admin screen from the 32-bit syswow directory, it appeared to have the same datasource entry present but i wasn't able to configure it. Does Crystal Reports only support 32-bit ODBC drivers?

Edited by: dct374 on Aug 13, 2009 3:48 PM

Edited by: dct374 on Aug 14, 2009 1:01 PM

[Former Member · Accepted solution]

Hi Don,

Is there any possibility to make Crystal Reports work with 64-bit drivers?

[former_member11696 · Accepted solution]

Hello,

No, CR is a 32 bit app and therefore we only support 32 bit clients. You can use some though if you use the versions included with .NET 2005 or 2008 which is CR version 10.2 and 10.5. It's limited to what driver you can use though and it's also limited to functionality in CR 10.

I recall now that you do use the odbadmin32.exe in the wow folder to make 32 bit ODBC DSN works. It seems backwards. In either case try both, one will work for 32 bit clients only.

Thank you

Don

[Former Member · Accepted solution]

Hi Don,

Many thanks for your reply. That makes it a lot clear. Not pretty sure if this is the right place to post this question, but can we have a 32-bit ODBC connection through a 32-bit client instead of the database server itself?

Best Regards

Jimmy

[former_member11696 · Accepted solution]

Hi Jimmy,

Not sure what you are asking so I'll assume you have the DB Server installed on the same PC? In which case the client is also installed, so you are still using the client to connect to the server.

If you want to move your application or use Crystal Reports on another PC then yes you need the Client installed to connect. There are some "Wired" drivers that have a built in client engine, our Datadirect ODBC driver installer installs one for MS SQl Server and Oracle I believe. These do not require the client install, it installs what it needs to connect to the server. These are still 32 bit drivers though.

Thanks again

Don

[Former Member · Accepted solution]

Hi Don,

Many thanks for your reply. I have now installed a 32-bit driver, and it works successfully based on the "test" button from the 32-bit ODBC Administrator Screen. However, when i try to refresh my template i get the following error:

"Failed to open the connection Details: 08004:[Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified [Database Vendor Code: 12154]"

Best Regards

Jimmy

[former_member11696 · Accepted solution]

Hi Jimmy,

Open the report up and test using the Designer. Create a different DSN so you can verify it is using the correct Oracle driver, 32 bit version.

There still may be version issues. Use Modules to confirm it is loading all of the 32 bit versions or use Prcess Monitor from www.sysinternals to confirm it's using 32 bit versions.

Thanks again

Don

[Former Member · Accepted solution]

Hi Don,

I can confirm its using the 32-bit driver, having configured different DSNs on the 64-bit and 32-bit driver versions. Is there anything else that you'd recommend doing?

Best Regards

Jimmy

[former_member11696 · Accepted solution]

Hi Jimmy,

ORA-12154: TNS:could not resolve the connect identifier specified.

It may be that we can't find the correct client install. CR uses the PATH statement to find the clients. Check it and make sure the 32bit client instal is the first one in the PATH statement.

Next is to create a new report using the Native Oracle driver in CR. Select Oracle Server in the database wizard and see if that works.

Thank again

Don

[Former Member · Accepted solution]

Hi Don,

Can you show us how to create the PATH statement? or more details on how to point CR to the 32-bit DSN?

Thanks a million

Tuan

[former_member11696 · Accepted solution]

Go to a CMD window by clicking on Start and type in cmd. It should list cmd so then you need to right click on it and choose Run as Administrator.

Type: path and the system will display what your current path is. You want to make sure the path for the Oracle 32 bit client is the first one. If it's not then right click on Explorer and choose Properties. Advanced tab and lower area has the Environment variables. This is where you can change/rearrange the order.

Thank you

Don