Solved

SQL 2000 DTS Unable to connect  Error 7312

Posted on 2008-10-04
3
838 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
3 Comments
 
LVL 31

Assisted Solution

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

Assisted Solution

by:Mark Wills
Mark Wills earned 50 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

830 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