Error reading a linked Excel spreadsheet

This problem just started happening (though the process had been working
without a problem for several months):
SQL to create link:
--if the link exists drop it
IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid !=
0 AND srv.srvname = N'Excel')
EXEC master.dbo.sp_dropserver @.server=N'Excel', @.droplogins='droplogins'
--create the link
EXEC sp_addlinkedserver 'Excel', 'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
@.FileName, NULL, 'Excel 5.0'
--add the login
EXEC sp_addlinkedsrvlogin N'Excel', false, sa, N'ADMIN', NULL
--SQL to read linked data (which throws below error):
EXEC sp_tables_ex Excel
--(this also throws same error)
select *
INTO ExcelData
from Excel...[' + @.SheetName + ']
The link to the excel spreadsheet can be made but when you try to read the
data you get:
[OLE/DB provider returned message: Could not find installable ISAM.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
I have tried the following which are suggestions from searching the internet:
1. Making sure the registry entries are there.
2. Renaming Msexcl40.dll and the opening Access and running Detect and
Repair, which placed a new Msexcl40.dll in the system32 directory
3. Restarting the SQL Server Service and restarting the server
4. I tried different excel files
I have linked to the same files used above from my local SQL server and had
no problem reading the data.
I don’t know what else to do. Can someone help me with this problem?
Harolds
Hello Harolds,
From the error message, it seems jet driver has issues. You may want to
reinstall Jet SP8 to test:
829558.KB.EN-US Information About Jet 4.0 Service Pack 8
http://support.microsoft.com/default...B;EN-US;829558
239114: How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0
http://support.microsoft.com/default...b;en-us;239114
If the issue persists, please try to reinstall MDAC to see if it helps:
1. Find the file C:\windows\inf\mdac.inf (%SYSTEMROOT%\inf\mdac.inf)
(the INF folder is hidden so you will have to make in viewable:
click on Tools, Folder options..., View, click Show hidden files and
folders).
2. Right click on the file and choose install.
3. When prompted to get file, on the Locate File dialog box that results,
click Browse. You may want to direct to Win2003 SP1 setup CD or folders
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Error reading a linked Excel spreadsheet

This problem just started happening (though the process had been working
without a problem for several months):
SQL to create link:
--if the link exists drop it
IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid !=
0 AND srv.srvname = N'Excel')
EXEC master.dbo.sp_dropserver @.server=N'Excel', @.droplogins='droplogins'
--create the link
EXEC sp_addlinkedserver 'Excel', 'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
@.FileName, NULL, 'Excel 5.0'
--add the login
EXEC sp_addlinkedsrvlogin N'Excel', false, sa, N'ADMIN', NULL
--SQL to read linked data (which throws below error):
EXEC sp_tables_ex Excel
--(this also throws same error)
select *
INTO ExcelData
from Excel...[' + @.SheetName + ']
The link to the excel spreadsheet can be made but when you try to read the
data you get:
[OLE/DB provider returned message: Could not find installable ISAM.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].
I have tried the following which are suggestions from searching the internet
:
1. Making sure the registry entries are there.
2. Renaming Msexcl40.dll and the opening Access and running Detect and
Repair, which placed a new Msexcl40.dll in the system32 directory
3. Restarting the SQL Server Service and restarting the server
4. I tried different excel files
I have linked to the same files used above from my local SQL server and had
no problem reading the data.
I don’t know what else to do. Can someone help me with this problem?
HaroldsHello Harolds,
From the error message, it seems jet driver has issues. You may want to
reinstall Jet SP8 to test:
829558.KB.EN-US Information About Jet 4.0 Service Pack 8
http://support.microsoft.com/defaul...KB;EN-US;829558
239114: How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0
http://support.microsoft.com/defaul...kb;en-us;239114
If the issue persists, please try to reinstall MDAC to see if it helps:
1. Find the file C:\windows\inf\mdac.inf (%SYSTEMROOT%\inf\mdac.inf)
(the INF folder is hidden so you will have to make in viewable:
click on Tools, Folder options..., View, click Show hidden files and
folders).
2. Right click on the file and choose install.
3. When prompted to get file, on the Locate File dialog box that results,
click Browse. You may want to direct to Win2003 SP1 setup CD or folders
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi guys !!!
I have the same problem, I'm using the same version of SQL, Excel & MDAC in
my local pc and the production server, however, the issue is only in the ser
ver.
Harolds: Please keep me posted about the way you solve this.
My Best Regards.|||I never got it fixed, I moved the process to another server where the error
does not occur.
--
Harolds
"velort" wrote:

> Hi guys !!!
> I have the same problem, I'm using the same version of SQL, Excel &
> MDAC in my local pc and the production server, however, the issue is
> only in the server.
> Harolds: Please keep me posted about the way you solve this.
> My Best Regards.
>
> --
> velort
> ---
> Posted via http://www.webservertalk.com
> ---
> View this thread: http://www.webservertalk.com/message1450885.html
>

Error on link Servers

Hi,
I am getting below error on link server and the performance between the link
server looks pathetic. Kindly suggest.
Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
an error. Execution terminated by the provider because a resource limit was
reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE
DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned
0x80040e31: Execution terminated by the provider because a resource limit
was reached.]. [SQLSTATE 01000] (Error 7300).
Hi
"Execution terminated by the provider because a resource limit was reached"
is a good indication. Check the destination server has enough connections and
resources. Check the SQL event logs on both servers.
Regards
Mike
"smiley" wrote:

> Hi,
> I am getting below error on link server and the performance between the link
> server looks pathetic. Kindly suggest.
> Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
> an error. Execution terminated by the provider because a resource limit was
> reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE
> DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned
> 0x80040e31: Execution terminated by the provider because a resource limit
> was reached.]. [SQLSTATE 01000] (Error 7300).
>
sql

Error on link Servers

Hi,
I am getting below error on link server and the performance between the link
server looks pathetic. Kindly suggest.
Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
an error. Execution terminated by the provider because a resource limit was
reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 731
2) OLE
DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returne
d
0x80040e31: Execution terminated by the provider because a resource limit
was reached.]. [SQLSTATE 01000] (Error 7300).Hi
"Execution terminated by the provider because a resource limit was reached"
is a good indication. Check the destination server has enough connections an
d
resources. Check the SQL event logs on both servers.
Regards
Mike
"smiley" wrote:

> Hi,
> I am getting below error on link server and the performance between the li
nk
> server looks pathetic. Kindly suggest.
> Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
> an error. Execution terminated by the provider because a resource limit wa
s
> reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7
312) OLE
> DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute retur
ned
> 0x80040e31: Execution terminated by the provider because a resource limit
> was reached.]. [SQLSTATE 01000] (Error 7300).
>

Error on link Servers

Hi,
I am getting below error on link server and the performance between the link
server looks pathetic. Kindly suggest.
Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
an error. Execution terminated by the provider because a resource limit was
reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE
DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned
0x80040e31: Execution terminated by the provider because a resource limit
was reached.]. [SQLSTATE 01000] (Error 7300).Hi
"Execution terminated by the provider because a resource limit was reached"
is a good indication. Check the destination server has enough connections and
resources. Check the SQL event logs on both servers.
Regards
Mike
"smiley" wrote:
> Hi,
> I am getting below error on link server and the performance between the link
> server looks pathetic. Kindly suggest.
> Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB' reported
> an error. Execution terminated by the provider because a resource limit was
> reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE 01000] (Error 7312) OLE
> DB error trace [OLE/DB Provider 'SQLOLEDB' ICommandText::Execute returned
> 0x80040e31: Execution terminated by the provider because a resource limit
> was reached.]. [SQLSTATE 01000] (Error 7300).
>

Error on link Servere

HI,
I am getting below error on link server. And the performance between
link server is really pathatic.

Executed as user: NT AUTHORITY\SYSTEM. OLE DB provider 'SQLOLEDB'
reported an error. Execution terminated by the provider because a
resource limit was reached. [SQLSTATE 42000] (Error 7399) [SQLSTATE
01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ICommandText::Execute returned 0x80040e31: Execution terminated by the
provider because a resource limit was reached.]. [SQLSTATE 01000]
(Error 7300).Hi,

It looks like that's a generic error. Pretty hard to troubleshoot..

Please read the following for more info on this.. Also, if/when you've
got more details (using the trace) and you're still experiencing issues
please post the query you're executing and the volume of data being
transferred between the servers..

http://support.microsoft.com/default.aspx?scid=314530

Greg

error message 18542 level 16 state 1

hi we have a link server...and
the user credentials are not being trasfered to link server....any
thoughts??
we get the following error message

Server message 18542 level 16 state 1

--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/error-messa...pict266240.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=915273nicki (UseLinkToEmail@.www.dbforumz.com) writes:
> hi we have a link server...and
> the user credentials are not being trasfered to link server....any
> thoughts??
> we get the following error message
> Server message 18542 level 16 state 1

Hm, that error number is not in sysmessages...

Anyway, since your post is terse, there is not information about what
you really expect. It would help if you describe a little more about
your setup.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp