Solved

SQL 2000 DTS Unable to connect  Error 7312

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

815 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

9 Experts available now in Live!

Get 1:1 Help Now