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 ...
Go to the complete details ...