Smalltalk › Instantiations

Accessing an MS/SQL "uniqueidentifier" column via ODBC

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

2 messages Options

Louis LaBrunda

Accessing an MS/SQL "uniqueidentifier" column via ODBC

Hi Gang,

I'm trying to make a single row query (for all columns) from an MS/SQL table via ODBC. One of the columns is defined as a "uniqueidentifier". This causes an exception of key not found trying to lookup a -11 data type.

Has anyone seen this before? Any ideas as to how to fix this or get around it?

I think I might be able to add an entry at -11 if I knew the correct data type to use and if it is already defined in VAST.

Thanks in advance for any help.

Lou

--
You received this message because you are subscribed to the Google Groups "VA Smalltalk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email].
To post to this group, send email to [hidden email].
Visit this group at http://groups.google.com/group/va-smalltalk.
For more options, visit https://groups.google.com/d/optout.

Louis LaBrunda

Re: Accessing an MS/SQL "uniqueidentifier" column via ODBC

I copied what is at -2 (AbtDatabaseBinaryField) to -11 in AbtOdbcDatabaseManager>typeDict and that seems to work.

AbtOdbcDatabaseManager typeDict at: -11 put: (AbtOdbcDatabaseManager typeDict at: -2).

"uniqueidentifier" is a 16 byte binary value, I can read it. I haven't tested any more than that but that is all I need, so I think I'm good.

Lou

On Monday, April 21, 2014 2:41:16 PM UTC-4, Louis LaBrunda wrote:

Hi Gang,
I'm trying to make a single row query (for all columns) from an MS/SQL table via ODBC. One of the columns is defined as a "uniqueidentifier". This causes an exception of key not found trying to lookup a -11 data type.
Has anyone seen this before? Any ideas as to how to fix this or get around it?
I think I might be able to add an entry at -11 if I knew the correct data type to use and if it is already defined in VAST.
Thanks in advance for any help.
Lou