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
   

- Advertisement -