 |
Re: hi.sql error
Started by franc14529 at 04-19-2008 15:32. Topic has 2 replies.
|
|
 04-19-2008, 15:32
|
franc14529
Joined on 12-27-2007
Posts 18
|
|
|
|
Dear freinds
i have an error like: db error coud not convert from character string to unique identifier.i am using sql server.
and when i use the function convert(uniqueidentifier,id);the ventuz runtime log file give me error like: error near the keyword convert.
this happens 1 time evry 20 mesages.it is not happening all time.
thanks alot
|
|
|
|
|
Report
|
|
|
|
|
04-22-2008, 14:06
|
Karol
 
Joined on 05-15-2005
Posts 281
|
|
|
|
Hi franc14529,
this sounds more like an error inside the DB which is just forwarded by Ventuz, than an error inside Ventuz .
Sorry, can't help with that so far.
karol
|
|
|
|
|
Report
|
|
|
|
|
04-23-2008, 17:57
|
Ralf Stanke
Joined on 05-15-2005
Dubai, U.A.E.
Posts 337
|
|
|
|
Hi franc,
please note that SQL is NOT really a 'standard'. All different SQL servers available have special features and commands implemented. The unlucky tries from MS to generalize database by OLE, ODBC and ADO.net failt so far.
Ventuz is passing the SQL text and its parameters to the ADO.net standard, which is implemented by OLE, ODBC, MySQL, Oracle, MS-SQL. If an execution of the SQL text failt, it happened in these ADO implementation or on the server directly.
If you get a systax error like "error near keyword..." it's definetly a parsing error of the DB driver - not from Ventuz.
So sorry, as Karol said, it's not a Ventuz issue. May be you can find solutions to your specific task in standard SQL forums? I do not even know what the 'convert' clause should do! :(
Ralf
|
|
|
|
|
Report
|
|
|
|
|
|