MS SQL Server ODBC - SQLServer Linked "Text" server using Jet engine problems...

Author

SQLServer Linked "Text" server using Jet engine problems...

Blaise

2005-05-03, 7:23 am

I've created a "Text" Linked Server via Jet OLEDB. Everything works great
when testing from the server itself, but when trying to query the
linked-server from any workstation fails with this message:

Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initi
alize returned 0x80004005: ].

I get the same message from Enterprise Manager (on a workstation) when I
highlight the LinkedServer Tables. This too, works fine from the server.

I've read all the MS-KB's for this error (yes, I have the correct version of
Jet OLEDB/MDAC, etc) but nothing seems to help.

I pointed the Temp and Tmp env-vars to the server local drive and allowed
access to that dir to all users (another suggestion from the KB's) - but
this didn't help either.

(I suppose, if all else fails, I could line up all the users outside the
server room and have them take turns working directly from the server -
RIGHT! <g>.)

Any assistance is greatly appreciated...
Blaise

Sue Hoegemeier

2005-05-04, 3:23 am

You can try turning on a trace flag to try to see if you 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.
You may also want to recreate the linked server using the
stored procedure sp_addlinkedserver:
EXEC sp_addlinkedserver @server ='TextLinkServer',
@srvproduct='',
@provider ='Microsoft.Jet.OLEDB.4.0',
@datasrc='D:',
@provstr='Text'

From a client, try something like:
select *
from TextLinkServer...[YourFile#txt]
to access D:\YourFile.txt

-Sue
On Mon, 02 May 2005 23:24:00 GMT, "Blaise"
<mgathome@pacbell.net> wrote:

>I've created a "Text" Linked Server via Jet OLEDB. Everything works great
>when testing from the server itself, but when trying to query the
>linked-server from any workstation fails with this message:
>
>Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
>[OLE/DB provider returned message: Unspecified error]
>OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
> IDBInitialize::Initi
alize returned 0x80004005: ].
>
>I get the same message from Enterprise Manager (on a workstation) when I
>highlight the LinkedServer Tables. This too, works fine from the server.
>
>I've read all the MS-KB's for this error (yes, I have the correct version of
>Jet OLEDB/MDAC, etc) but nothing seems to help.
>
>I pointed the Temp and Tmp env-vars to the server local drive and allowed
>access to that dir to all users (another suggestion from the KB's) - but
>this didn't help either.
>
>(I suppose, if all else fails, I could line up all the users outside the
>server room and have them take turns working directly from the server -
>RIGHT! <g>.)
>
>Any assistance is greatly appreciated...
>Blaise
>

Sponsored Links