Home »
Public Forums »
archive »
Question about Dataminer syntax to execute Stored Procedure
| Question about Dataminer syntax to execute Stored Procedure [message #57652] |
Wed, 19 December 2007 13:36 |
Daft Pict
Messages: 8
Registered: March 2007
|
Junior Member |
|
|
Greetings,
I'm trying to execute a SQLserver stored procedure which invokes a
Bulk Insert (for speed) to load data but despite looking at the DM
documentation am unable to get it to work!
Here's the code
sql_statement ="{CALL LoadDAOcat('"
sql_statement+=string(Meta(k).daocat_filename)+"','"
sql_statement+=string(Meta(k).image)+"')}"
oDB->ExecuteSQL,sql_statement
which builds the following SQL statement
{CALL LoadDAOcat('v:\processed
\HST_9293_06_ACS_WFC_F814W_daophot_v1.0.txt','HST_9293_06_AC S_WFC_F814W')}
The procedure requires 2 parameters (data file name and a value to
identify which db entry to update)
The syntax appears to be ok according to the on-line docs but I get
the following error
IDLDBDATABASE::EXECUTESQL: ODBC [Microsoft][ODBC SQL Server Driver]
[SQL Server]68921
Execution halted at: HLAREADDATA 435
Error 68921 doesn't appear anywhere in the ITT, DataDirect or MS
documentation that I can find so I can't even figure out what the
error is???
Anyone able to help?
Thanks in advance....
-Brian
|
|
|
|
Current Time: Wed Oct 08 19:00:20 PDT 2025
Total time taken to generate the page: 0.00570 seconds
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
