468,170 Members | 1,967 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,170 developers. It's quick & easy.

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

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
1 1644
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.

Similar topics

4 posts views Thread by Russell | last post: by
2 posts views Thread by Carl | last post: by
3 posts views Thread by Eagle | last post: by
1 post views Thread by amitbadgi | last post: by
20 posts views Thread by Dennis | last post: by
2 posts views Thread by Jeff | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.