Posted on: 8/19/2013 9:17:27 AM | Views : 350

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 ...