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.