Has anyone tried to run the "SQL Server 2000 DTS Designer Components for
SQL Server 2005" on a 64 bit (non-Itanium) box? Have you tried to run it
on WOW64 subsystem?

The April 2006 build of the "SQL Server 2000 DTS Designer Components for
SQL Server 2005" works on a 32 bit box running SQL Server 2005 - allowing
both editing and running of DTS packages that you import from 2000
(assuming the DTS package name coming over from 2000 meets the new naming
criteria).

It would be nice to port over the DTS packages to a 64 bit box and convert
them to SSIS over time instead of all at once. But if it's not possible
that's OK.

Your thoughts?

Thanks,

Tom Holden




"Davis Ralph " <mssqldba-ezmlmshield-x20058697.[Email address protected]
01/29/2007 11:24 AM

To

cc

Subject
RE: ODBC driver for 2005






Good question. We were told by MS that ODBC is going away and Native
Client is what they want us to use.

They don't even make a 64bit ODBC driver which caused us many issues for
some of our linkservers(especially Sybase). Can't even find one that
works from a 3rd party vendor.



Thanks,
Ralph W. Davis
*********************************************************
*** CORPORATE DBA group - Houston ***
*********************************************************

-----Original Message-----
From: Sheldon Jeff
[mailto:mssqldba-ezmlmshield-x56108300.[Email address protected]
Sent: Monday, January 29, 2007 10:24 AM
To: LazyDBA Discussion
Subject: ODBC driver for 2005

Quick question, for those that installed SQL Client Tools for 2005 on a
workstation, when you do an ODBC connection (Control Panel/
Administration Tools) there are two for SQL server.



SQL Native Client which has a version of 2005-xxx

SQL Server which has a version of 2000-xxx



If you launch SQL Native Client its splash screen is SQL 2005 but the
connectivity doesn't appear the same as the SQL Server Driver.



1. What is Native Client used for?

2. Did SQL 2005 to anyone's knowledge update the SQLSRV32.DLL for
ODBC connectivity?



Thanks have an ERP migration problem and trying to narrow down if it is
the vendor or our connectivity.



Jeff





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
****************************************************************
Confidentiality Note: The information contained in this
message, and any attachments, may contain confidential
and/or privileged material. It is intended solely for the
person(s) or entity to which it is addressed. Any review,
retransmission, dissemination, or taking of any action in
reliance upon this information by persons or entities other
than the intended recipient(s) is prohibited. If you received
this in error, please contact the sender and delete the
material from any computer.
****************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page