?
Solved

SQL 2000 DTS Unable to connect  Error 7312

Posted on 2008-10-04
3
Medium Priority
?
841 Views
Last Modified: 2013-11-30
We have a few Data Transformation Services (DTSs) that transfer files/tables from one SQL server to another or create a backup for those files/tables into a different database located within the same server. One of the servers is a SQL server 2000 and the other is 2005.

This error took place on the server with SQL Server 2000.

These DTSs has been working fine for a long time, but today I received this error and I can not locate a solution. Any idea what might have caused it?

Error.txt
0
Comment
Question by:Jesus Rodriguez
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 31

Assisted Solution

by:James Murrell
James Murrell earned 200 total points
ID: 22643614
0
 
LVL 51

Assisted Solution

by:Mark Wills
Mark Wills earned 200 total points
ID: 22644447
Which one is the origin of the error ? Better to be using SSIS in sql2005 and the latest ODBC drivers. The other way around will not work of course... SQL 2000 cannot manage the 2005 database environment, but MSDASQL does sound like the 2000, and really should be using SQLNCLI ie the newer native client - MDAC has been depricated...

Have a look at 2005 Books on-line http://msdn.microsoft.com/en-us/library/ms131035(SQL.90).aspx
If you look at the left hand side, you will see a lot of discussion topics on SQL native client, and if you search for MDAC in Books on-line, there are more discussions. That much commentary in itself says "listen up"...

Now, the other age old problem you can get is the confusion and connect corrptions betwen 32 bit and 64 bit - depending on how, when, and where you are running the DTS packages. Are you a 64-bit site ?
0
 
LVL 13

Accepted Solution

by:
Jesus Rodriguez earned 0 total points
ID: 22707438
Thanks CS and Mark for your time.
Apparently it was a hardware connectivity issue which needed an immediate attention and once the DTS re-gained connecttion it worked fine.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question