Re: SQL linked server with ODBC
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Thu, 07 Sep 2006 12:12:57 -0600
You can turn on a trace flag to try to get additional
information on the 7399 error. Execute
dbcc traceon(7300,3604)
and then run the query.
You could also use profiler and capture the OLEDB Errors
event.
One of those might help you get more specific information on
the error.
The other thing to try would be to try replacing the select
* in the outer query (run against the openquery, not the one
running against Navision) with a specific column list.
-Sue
On 1 Sep 2006 14:36:35 -0700, "Vanbever" <kv@xxxxxxxxxxxx>
wrote:
Hi,
I am having trouble extracting data from a Navision
database via an sql linked server. I am using sql server 2000.
The steps I have followed so far are;
I installed the codbc driver, (the odbc driver which comes
with navision), on the sql server.
I created an ODBC System DataSource name (NAV), on the
SQL server.
I created a linked server using OLE DB provider (MSDASQL)
and data source parameter. ie.
sp_addLinkedSever 'navision', ' ', 'MSDASQL', 'NAV'
At this point I can run sp_linkedservers, and see navision
listed as a linked server, however when I try and query
the navision database with the following query,
DBCC TRACEON(8765)
select * from OPENQUERY(NAVISION,'SELECT * FROM Customer')
RETURN
I get the following error message
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. The provider did not give
any information about the error.
Is there anyone who can help me?
Thanks,
Koen
.
- References:
- SQL linked server with ODBC
- From: Vanbever
- SQL linked server with ODBC
- Prev by Date: Re: SQL error
- Next by Date: Re: SQLConnect
- Previous by thread: SQL linked server with ODBC
- Next by thread: Missing File
- Index(es):
Relevant Pages
|
