Weird ADO / Guid problem ( Syntax error converting...)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

When calling a stored procedure on a SQL 2005 DB with the managed SQL
ADOprovider I got the following exception:

Syntax error converting character string to uniqueidentifier

when I use the following value for a unqiueidentifier variable
{A00C9D36-CC20-475F-A285-777CC739199C}. If I use another random GUID the
stored procedure executes fine. The value that gives problems, is a key that
was generated by rthe db, so it should be conform to the formatting
restrictions that applies...

Anyone any suggestions ?
 
Please ignore the preceding message, (conversion problem of the empty GUID in
a result list and not on the parameter)
 
Back
Top