Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server Client Network Utility

Author  Topic 

Kleber
Yak Posting Veteran

67 Posts

Posted - 2006-07-19 : 17:24:12
Hi,

I've installed SQL Server 2000 on a Windows Server 2003 x64. And I found somenthing very annoying.

I have an application that uses SQL SCNU options "automatic ansi to oem conversion" and "use international settings". But in a x64 bit envioronment the NTWDBLIB.DLL doesn't load.

When I open, DB-Library Option's tab the Version information says "Not Loadable"

And the applications gives me wrong information. The server must load this DLL.

Anyone saw something like that? How can I solve it?

Regards
Kleber

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-19 : 17:39:42
Does the DLL load okay if you don't have these settings turned on?

BTW, using Client Network Utility assists the application so that they don't have to include options in the connection string. If you can't get it to work, then remove those settings and have them account for that in the connection string or in the code.

But I'm having a problem understanding why Client Network Utility is suspected on this database server. Client Network Utility would only impact applications running on the database server. Where is the application running that requires these settings?

Tara Kizer
Go to Top of Page

Kleber
Yak Posting Veteran

67 Posts

Posted - 2006-07-19 : 18:03:00
The DLL doesn't load. It doesn't matter if setting is turned on of off! :(

At this moment the Client Network Utility is installed on a database server just for testing purpose because it is a testing server, but I have installed it on another x64 servers where the application is installed and I got the same issue.

If you have any idea to help me, I will appreciate.

Regards
Kleber
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-07-19 : 18:07:17
Did you install the 64-bit version of SQL Server 2000?

Tara Kizer
Go to Top of Page

Kleber
Yak Posting Veteran

67 Posts

Posted - 2006-07-20 : 07:34:59
Yes and no. The 64-bit version of SQL Server 2000 is designed to Itanium. Here we don't have Itanium. We have the new intel 64-bit platafform. A.K.A x64. SQL Server 2000 doesn't work in 64-bit for this plataform. It works like 32-bit compatible.

Kleber
Go to Top of Page
   

- Advertisement -