Solved

SQL 2000 DTS Unable to connect  Error 7312

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

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.
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.
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.
Viewers will learn how the fundamental information of how to create a table.

732 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