Guid Comparing

  • Thread starter Thread starter Brian Barnes
  • Start date Start date
B

Brian Barnes

Basically I am trying to syncronise a MS Access database with a MS SQL
server Database and I am trying to use guid's via a VB (.NET) application
(will eventually be a web service) to see weither a row is in the database
or not.

This is currently done by filling 1 dataset with the data from MS Access,
and filling another dataset from MS SQL Server and then (unsuccessfully)
compairing the guids so that I can insert all rows that are not in the
database. Idealy I would also be using greater than and less than (to have
faster code execution) but at this stage it is not nessecery. I have also
tried to convert it to a string (again with no success).

I have seen that it may be possible to convert the guid to a string in the
SQL select statement, but the comments that I have seen have been sketchy at
best (and a number having no success with this).

Could someone point me in the right direction?

tia
 
Brian Barnes said:
Basically I am trying to syncronise a MS Access database with a MS SQL
server Database and I am trying to use guid's via a VB (.NET) application
(will eventually be a web service) to see weither a row is in the database
or not.

This is currently done by filling 1 dataset with the data from MS Access,
and filling another dataset from MS SQL Server and then (unsuccessfully)
compairing the guids so that I can insert all rows that are not in the
database. Idealy I would also be using greater than and less than (to have
faster code execution) but at this stage it is not nessecery. I have also
tried to convert it to a string (again with no success).

I have seen that it may be possible to convert the guid to a string in the
SQL select statement, but the comments that I have seen have been sketchy at
best (and a number having no success with this).

Could someone point me in the right direction?
Click to expand...
In short I'll point myself in the right direction :-D
Figured it out - MS Access returns guids different to SQL Server.
In short SQL Server returns it in {} and in uppercase as a string type, and
Access returns it as guid type without {} and in lowercase
 
Back
Top