Showing posts with label driver. Show all posts
Showing posts with label driver. Show all posts

Sunday, February 19, 2012

DTS, driver ODBC for Btrieve

Hi,
I need transformation data from files Btrieve (.dt) to any other formats. Where i can download driver ODBC or OLE DB for Btrieve?
And how install this driver?
Thank.See the vendors list (http://www.sqlsummit.com/oledbVen.htm) and get it.|||Originally posted by Satya
See the vendors list (http://www.sqlsummit.com/oledbVen.htm) and get it.
You have already used this Vendors list?
Exist of the shareware or freeware drivers?|||I've used Data Direct Technologies and for the shareware ensure to test them before deploying on production server.

Freeware/shareware are easy to get but make sure there is no security threat to the server.|||Originally posted by Satya
I've used Data Direct Technologies and for the shareware ensure to test them before deploying on production server.

Freeware/shareware are easy to get but make sure there is no security threat to the server.
What to do Data Direct Technologies? This is alternative DTS?
Give me links for downloads Data Direct Technologies, pls.|||I think you're not interested in the referred link, where this http://www.datadirect-technologies.com/ link is listed there.

Originally posted by Cancer
What to do Data Direct Technologies? This is alternative DTS?
Give me links for downloads Data Direct Technologies, pls.|||I looked only those links, which support Btrieve.
I have not found still shareware/freeware driver.

Thank for discussion|||Then may contact vendors listed, for further information.

Friday, February 17, 2012

dts transform task failing when using IBM db2 odbc driver..

The thing is I am using a DTS package to get data from db2 residing on a s390-mainframe and put it in a sql 2000 db on windows 2000 server..

I have the odbc driver that the server guys gave me..I installed it and then run a batch pgm, which i think does the database set up...in short i set up the DSN's in my local machine..I can use the dsn when i use the sql client...

I can't create a new package and then complete the task..Problem is when i try set up a transform task, i get a memory error...it says that the instruction referenced a memory location that can't be read...

So what i do is i use the import task in sql...which inturn uses the same odbc connection and runs the query on db2..inserts the results into a table in sql..then save the package...Only problem is that i can't edit the transorm task...same memory error...

Any idea why this happens ?? I would like to see how i can get past this using Odbc...What version of the driver are you using? IBM posts hotfixes and patches on their website for their drivers; you may be able to find a fix for the one you are using.

In particular I remember a hotfix for their AS/400 V5R1 driver that fixed an issue I was having.

Regards,

hmscott|||think it is ==>
Version: 7, Release: 2, Modification: 3, Service Level: WR21254