Re: Incorrect syntax near ':'
This looks, to me, like the database connection is failing. You may want to
post this to the microsoft.public.vc.database forum since my guess is it's
more of a database set up problem than it is an MFC problem.
That said, if you could post the code you are using to connect to the
database (aside from the XML message you're trying to update to it) that
might help. Are you using the MFC database classes, for example. Maybe
there is something wrong in the way that is setup since you say the same SQL
works from other sources.
Tom
"Veeru" <Veeru@discussions.microsoft.com> wrote in message
news:239ECAED-9C2E-4F7B-B6FD-FF169841AC6E@microsoft.com...
Hi
I am reading the query and the value from Xml file. I need to execute the
query using OLEDB.
my xml mesage contains
<DataRequest reqName="Example1">
<osql:ExportRequest xmlns:osql="sql"
connectionString="Provider=SQLNCLI;Server=DAESRV003\SQL_SERVER_2005;PLSQLRSet=1;Database=MI;UID=XT;PWD=aeseixt_133"
rowsToFetch="100" skipNullValues="true" explicitNulls="true"
targetNamespace="IS/1.0.0" processingMode="skip" dateTimeFormat="dmy">
<DataObject name="Sales_Force" namespace="Sales_Force">
<SQL sql="select * from team where team_id =:eid">
<param name="eid" value="105"/>
</SQL>
</DataObject>
</osql:ExportRequest>
</DataRequest>
when I run my program it is showing the following error
<Error><Code>80040e14</Code><Description><OLEDBErrors hr="80040e14"><Error
row="0" source="Microsoft SQL Native Client" Description="Statement(s)
could
not be prepared." helpContext="0"
guid="{0C733A63-2A1C-11CE-ADE5-00AA0044773D}"/><Error row="0"
source="Microsoft SQL Native Client" Description="Incorrect syntax near
':'."
helpContext="0"
guid="{0C733A63-2A1C-11CE-ADE5-00AA0044773D}"/><UserMessage></UserMessage></OLEDBErrors></Description><Module>Export</Module><Message></Message><RequestId></RequestId></Error>The
program
If I run the same using Oracle it goes fine.
Can u please help me to solve this issue