ODBC and Long Byte issue

[Martin Bloomfield]

Hello all,

 

Not sure if anyone will be able to offer any advice. We have a project being undertaken that is trying to extract come of our Ingres data and move it into a MS SQL server / dynamics Dataverse database.  This is being done using SSIS with an ODBC connection (using the Ingres 3.50.1120.257 ODBC driver) to our Ingres 11.2 database.  The team are struggling with accessing tables that have columns defined as Longbyte.

Does anyone know whether the ODBC driver can handle longbyte data columns and if so, do you have to do anything “different / special” to read the data from Ingres?  If ODBC can’t handle Longbyte data, can anyone suggest how we can extract this data to port it to MS SQL?

 

Many thanks,

 

Martin Bloomfield
Senior Application Developer
Information Systems Development
Information and Technology Services

Health and Safety Executive
YORK

[a...@rationalcommerce.com]

Hi Martin

Are you going to use EA to access the MS-SQL DB from Actian/HCL products?

If not then:

I would extract your longbyte objects to a file system using OpenROAD if you still have access to a licence and use what ever native longbyte import SQL server provides.

Happy to chat about this offline in person if you want.

Send me an email if you do

Cheers

Adrian

[Bodo Bergmann]

Hi Martin,

access to "long byte" data via the ODBC driver is supported according  to https://docs.actian.com/actianx/11.2/index.html#page/Connectivity/Large_Objects_(Blobs)_Support.htm

Obviously, the data has to be read in chunks.

HTH.
Regards,
Bodo.

Bodo Bergmann Engineering Architect | OpenROAD Engineering Actian, a division of HCLSoftware
actian.com    hcl-software.com
GESELLSCHAFTSANGABEN: Actian Germany GmbH | Registry Off: Halenreie 42, 22359 Hamburg | Geschäftsführung: Stephen Padgett, Marc Monahan | Handelsregister: Amtsgericht Hamburg | HRB 135991 | USt-IdNr: DE252449897

--
You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/LO0P123MB7230489890EC79650B35C129C681A%40LO0P123MB7230.GBRP123.PROD.OUTLOOK.COM.

[Paul White]

I concur.

Reasonably simple coding. 

You get the benefit of a separate file you can inspect directly.

You can also use.net provider for ingres.

Paul

--

You received this message because you are subscribed to the Google Groups "OpenROAD Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openroad-user...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/openroad-users/03cojopbvlthprffs0i043rb.1701457725544%40email.lge.com.