Sign in
Log inSign up
Travis Horn

2.7K reads

1 comment

Mark
Mark
Jan 6, 2022

Thanks for the article.

How would one read a column that is a uniqueidentifier

example I have the following ;

objRS.open "select * from [dbo].[tblSMSVerify] where UID = '"& xUID &"' AND SMSGenned = '"& smscode &"'",connObj,2,3,1

UID is a uniqueidentifier column in mssql xUID is a GUID

however I am getting a message as follows ;

Conversion failed when converting from a character string to uniqueidentifier.

Cheers

·