Page 1 of 1
TMsLoader causes error
Posted: Wed 22 Feb 2012 10:39
by jmuehlenhoff
Hi,
when I try to use a TMsLoader the SQL server sends back an error:
"table/view either does not exist or contains errors"
This happens on permanent and temporary tables.
Delphi version is D2007 and MSSQL is 2008 R2.
Posted: Thu 23 Feb 2012 13:33
by AlexP
Hello,
Please specify your SDAC version, and also show the Delphi code which causes this error.
Posted: Fri 24 Feb 2012 10:13
by jmuehlenhoff
SDAC version is 6.1.4.
I have to correct myself. It does work on permanent tables, but doesn't work on temporary ones.
I have one TMSConnection, one TMSQuery and one TMSLoader on the form.
So both query and loader have the same connection.
The query has this SQL code:
Code: Select all
SELECT TOP 0 * INTO #TMP_ADR FROM ADR
The loader has its TableName set to: #TMP_ADR
Then the only Delphi code I run is:
Code: Select all
MSQuery1.ExecSQL;
MSLoader1.LoadFromDataSet(SourceDataSet);
Posted: Fri 24 Feb 2012 14:25
by AlexP
Hello,
We create a new session to request the IOpenRowset interface for fast data loading into a table, and therefore TMSLoader cannot work with temporare tables.