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!