By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,346 Members | 2,331 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,346 IT Pros & Developers. It's quick & easy.

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

P: n/a
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 ?
Mar 22 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Please ignore the preceding message, (conversion problem of the empty GUID in
a result list and not on the parameter)

"SealedClassSingleton" wrote:
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 ?

Mar 22 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.