OPENDATASOURCE makes SQL Server crash

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

SSIS and Import/Export (2012)

OPENDATASOURCE makes SQL Server crash

Author

Topic

wax
Starting Member

1 Post

Posted - 2013-08-19 : 09:15:27

Hi all,

I try to write a procedure to import Access data into SQL Server.

I'm under Windows 2012 and SQL Server Express 2012

After having installed 64bits Access provider, I try the following request into SSMS:

SELECT * FROM OPENDATASOURCE('Microsoft.ACE.OLEDB.12.0','Data Source=C:\chemin_de_ma_bdd.mdb;Persist Security Info=False')...[groupe_famille_table]

I get the following error

Msg*109, Niveau*20, État*0, Ligne*0
Une erreur de niveau transport s'est produite lors de la réception des résultats du serveur. (provider: Shared Memory Provider, error: 0 - Le canal de communication a été fermé.)

In fact, I see SSMS has lost connection to server and SQL Server service is down. I have to restart if manually

Have you ever seen it ?

Thanks a lot

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources