• Sorry for the confusion...

    In my example I configured both the 32 bit and x64 ODBC

    the 32 bit ODBC.exe is located in that path I listed above C:\windows\System32 directory.

    right click on the ODBC.exe run as admin and then create a new DSN (which will point to the 2000 server).

    When you are configuring it asks what driver to use...I just listed the driver I used and tried to be descriptive.

    When you configure obviously make note of the name of the DSN...because that is going to be the name of the linked server.

    when you use the code I posted below you will replace the "</Server name you put in the DSN/>" with the name of the DSN you just created...

    @datasrc = '</The actual server name/>',

    you will replace that part with the actual server name

    in this part you need to configure the login and password

    @provstr = 'DRIVER={SQL Server};SERVER=</The actual server name/>;UID= enter login;PWD=enter password;' -- ODBC Connection String.

    for example you could use the sa account and password

    this code is for adding the login mapping on that particular linked server

    EXEC master.dbo.sp_addlinkedsrvlogin

    @rmtsrvname = N'</Server name you put in the DSN/>',

    @locallogin = N'enter a local login',

    @useself = N'False',

    @rmtuser = N'enter a remote login',

    @rmtpassword = N'enter a remote password'

    GO

    hope it helps...