SQL Server 2005 - Unique Identifiers Data Type

dataservices administration
1

HI, I’m using 11.7 DI, connecting via the SQL Server 2005 Database connection type in the Datastore, connecting fine to the database and able to import the SQL2005 tables.

However, i cannot see in those tables within DI the Primary and Foreign Key fields as these are set to SQL 2005 Unique Identifier Data types. For this very reason, i am at a loss.

Does anyone know a way to extract the tables from SQL2005, including these fields. I was hoping to be able to see the full data in DI due to its use of a 2005 OLEDB connection, however this is not the case. From their i was planning to change these to integer values, but unless DI can see these Key fields, ill have to consider using SSID and ditch DI.

Any help would be most appreciated!

tonyp (BOB member since 2007-12-07)

2

Thanks guys for the prompt responces! i managed to enter the datastore, into advanced options and changed the tick box to allow non supported data types to be imported as Varchar

This did the trick, hopefully someone else will benefit from my post!

Cheers :crazy_face:

tonyp (BOB member since 2007-12-07)

3

and hopefully those datatypes are supported natively soon :cuss:

Werner Daehn :de: (BOB member since 2004-12-17)

4

How about varchar(max) and nvarchar(max), while we’re talking about new SQL 2005 datatypes? :mrgreen:

dnewton :us: (BOB member since 2004-01-30)

5

These I know are in the plan

Werner Daehn :de: (BOB member since 2004-12-17)