ADO-Error 0x80004005 when creating views

  • Thread starter Christoph Schmitt
  • Start date
C

Christoph Schmitt

Hi,

when trying to create a view on an Excel shett via a linked server i receive
the error

ado-error: ole db-errortrace....IDBInitializInitialize returned
0x80004005...

The syntax of my query is:

SELECT * FROM OPENQUERY(MYXLS,'SELECT * FROM [MYXLSFILE$]')

What am i doing wrong?

Thank you for any help!

Regards
Christoph
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ADO-Error 0x80004005 when ceating views 0
0x80004005 error 3
connecting to two adp projects error- 9
xp_cmdshell with DTExec 2
SYSTEM ERROR (0x80004005). 0
Error code returned by ADO 2
Link Form to Access Database thru DSN 0
Error 7399 When trying to link an Access database to SqlServer 2K 1

Top