Solved

SQL 2000 DTS Unable to connect  Error 7312

Posted on 2008-10-04
3
835 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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Suggested Solutions

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.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

744 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now