servers

I have 2 test boxes each running sql server 2000 standard
edition. For both boxes i've created a linked server and
specified the name of the system DSN of the ODBC data
source within the properties of the linked server created.
A drive has been mapped to the Access database i want to
see and the ODBC connections have been created. But
unfortunately only one of my sql boxes can see the tables
while the other generates a Error '7399' message. why,
please advise. thank you.
Error 7399 doesn't tell us much. We'd need more details
regarding the exact error message. Can you access the mapped
drive? Have you tried using a UNC path instead of a mapped
drive? Mapped drives are often unreliable for this type of
situation.
-Sue
On Wed, 15 Sep 2004 13:26:47 -0700, "vincent"
<vincec@.mail.com> wrote:

>I have 2 test boxes each running sql server 2000 standard
>edition. For both boxes i've created a linked server and
>specified the name of the system DSN of the ODBC data
>source within the properties of the linked server created.
>A drive has been mapped to the Access database i want to
>see and the ODBC connections have been created. But
>unfortunately only one of my sql boxes can see the tables
>while the other generates a Error '7399' message. why,
>please advise. thank you.
|||Thank you for responding. I can access the mapped drive and i've tried
using the absolute path, both attempts have been unsuccessful. Because
the access database i'm tring to access is of a relitively small size if
copied it locally and i still wasn't able to access the tables. So I
image the problem would have to be with the OLE DB provider? This is the
stored procedure that trys to execute.
select invoice_num,authorize_code from OPENQUERY(idd3,'select * from
trans_table')
where invoice_num like 'OEPP%'
and (authorize_code is not null
or ltrim(rtrim(authorize_code)) <> '')
When i view my job history logs i receive all of these error messages.
DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147217900
(80040E14)
Error string: OLE DB provider 'MSDASQL' reported an error.
Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0
Error Detail Records: Error: -2147217900 (80040E14);
Provider Error: 7399 (1CE7)
Error: -2147217900 (80040E14);
Provider Error: 7300 (1C84)
Error string: OLE DB error trace [OLE/DB Provider 'MSDASQL'
IDBInitialize::Initialize returned 0x80004005: ].
Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0
Error: -2147217900 (80040E14); Provider Error: 7312 (1C90)
Error string: [OLE/DB provider ret... Process Exit Code 1.
The step failed.
Thanks in advance.
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||What happens when you use Query Analyzer and execute:
dbcc traceon(7300, 3604)
and then execute the query in Query Analyzer (not DTS)?
Do you have any additional error messages?
-Sue
On Wed, 22 Sep 2004 06:54:45 -0700, Vincent Cristiano
<vincec@.mail.com> wrote:

>Thank you for responding. I can access the mapped drive and i've tried
>using the absolute path, both attempts have been unsuccessful. Because
>the access database i'm tring to access is of a relitively small size if
>copied it locally and i still wasn't able to access the tables. So I
>image the problem would have to be with the OLE DB provider? This is the
>stored procedure that trys to execute.
>select invoice_num,authorize_code from OPENQUERY(idd3,'select * from
>trans_table')
>where invoice_num like 'OEPP%'
>and (authorize_code is not null
>or ltrim(rtrim(authorize_code)) <> '')
>When i view my job history logs i receive all of these error messages.
>DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147217900
>(80040E14)
>Error string: OLE DB provider 'MSDASQL' reported an error.
>Error source: Microsoft OLE DB Provider for SQL Server
>Help file: Help context: 0
>Error Detail Records: Error: -2147217900 (80040E14);
>Provider Error: 7399 (1CE7)
>Error: -2147217900 (80040E14);
>Provider Error: 7300 (1C84)
>Error string: OLE DB error trace [OLE/DB Provider 'MSDASQL'
>IDBInitialize::Initialize returned 0x80004005: ].
>Error source: Microsoft OLE DB Provider for SQL Server
>Help file: Help context: 0
>Error: -2147217900 (80040E14); Provider Error: 7312 (1C90)
>Error string: [OLE/DB provider ret... Process Exit Code 1.
>The step failed.
>Thanks in advance.
>*** Sent via Developersdex http://www.codecomments.com ***
>Don't just participate in USENET...get rewarded for it!
|||Did anyone figure out this issue. I'm also getting the exact same error and would really appreciate if someone can help me with this.. I have to get this fixed within the next two days..
I've not yet tried this - dbcc traceon(7300, 3604)
I'll give this a try and let you know what happens
Thanks