Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Linked Servers / OLE DB Jet4.0 request fails!

 
   Database Help (Home) -> Server RSS
Next:  Snapshot Replication  
Author Message
eleite

External


Since: Apr 07, 2010
Posts: 1



(Msg. 1) Posted: Wed Apr 07, 2010 8:26 am
Post subject: Linked Servers / OLE DB Jet4.0 request fails!
Archived from groups: microsoft>public>sqlserver>server (more info?)

Hello

I tried to execute an sql statement throught SQL OLEDB command
It fails since I moved my configuration on 64 bits Windows 2008 Server
System and migrate Sql Server 2005 to 2008.
I want to execute an SQL Statement into an Excel file with Sql Linked Servers

OleDbConnection sq = new OleDbConnection();
sq.ConnectionString = "Provider=SQLOLEDB;Data Source=xxx;user
id=xxx;password=xxx;";

[...]

sql = "insert into openquery(... FROM [Export$]) ...

OleDbCommand c = new OleDbCommand(sql, sq);
c.ExecuteNonQuery();

Returns : can't execute the query, provider is in SLA mode.

Any ideas to change SLA mode into MLA mode?

Many thanks

 >> Stay informed about: Linked Servers / OLE DB Jet4.0 request fails! 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
WMI SetServiceAccount method fails with "The request is no.. - I've developed a VB script to change the SQL service accounts for SQL 2005 servers using the WMI SetServiceAccount method. The script runs fine on stand-alone servers (with or without named instances), and it runs fine on clusters as well, as long as...

Linked Servers versus SSIS - I have two servers running SQL Server 2005. I'd like to transfer data back and forth between the two. Aside from the UI associated with SSIS, what are the pros and cons of using linked servers to insert/update/delete data versus using SSIS? The ..

IDENTITY Insert doesnt work for Linked servers - Hi Everybody, In my program, I am inserting rows from the source database to the destination database which are on different servers. From source database, with the help of the link server, I am connecting to the destination server. In the destinatio...

Triggers with SQL Server 2005 and linked UniOleDb Servers -

Is IM on MS SQL Servers ??? :) - They seem to be having some issues -- so much for cluster server reliability and redundancy. he he
   Database Help (Home) -> Server All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]