SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 OPENDATASOURCE makes SQL Server crash
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 08/19/2013 :  09:15:27  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000