Discussion:
Dinosaures need help !
(too old to reply)
Sergei Turin
2014-02-25 13:05:22 UTC
Permalink
Dear colleagues,

I am really stuck with ODBC/OLEDB/SQL Server Integration Services connectivity to our production box still running IDS 7.31UC6AX7.

We need to copy portions of data to datamart server. Before the damned change, it was SQL 2005 32bit (+ SDK 2.81TCx). Now it is _upgraded_ to SQL 2008R2 (+ SDK 3.70TC4)and old good ODBC connections does not work.

I tried to switch to OLEDB and even SSIS (with different versions of SDK) but reliable connection is still not available. I found myself in a black despair because production box is close to 100% fullness and I cannot move data to datamart one to free the dbspaces.

The only question I have is there a good, tested, reliable combination of IDS and CSDK to connect the following

Source Server
HP-UX 11.11i
IDS 7.31UC6AX7

Destination Server
Windows Server 2003 / 2003 R2 / 2008 / 2008 R2 (could configure any version,
32bit or 64 bit)
SQL Server 2008 / 2008 R2 (again, both 32 or 64 bit editions are possible)

Holding my breath to get an answer,
Sergei
Spokey Wheeler
2014-02-25 13:15:37 UTC
Permalink
Have you tried SDK 2.81TCx?
Post by Sergei Turin
Dear colleagues,
I am really stuck with ODBC/OLEDB/SQL Server Integration Services connectivity to our production box still running IDS 7.31UC6AX7.
We need to copy portions of data to datamart server. Before the damned change, it was SQL 2005 32bit (+ SDK 2.81TCx). Now it is _upgraded_ to SQL 2008R2 (+ SDK 3.70TC4)and old good ODBC connections does not work.
I tried to switch to OLEDB and even SSIS (with different versions of SDK) but reliable connection is still not available. I found myself in a black despair because production box is close to 100% fullness and I cannot move data to datamart one to free the dbspaces.
The only question I have is there a good, tested, reliable combination of IDS and CSDK to connect the following
Source Server
HP-UX 11.11i
IDS 7.31UC6AX7
Destination Server
Windows Server 2003 / 2003 R2 / 2008 / 2008 R2 (could configure any version,
32bit or 64 bit)
SQL Server 2008 / 2008 R2 (again, both 32 or 64 bit editions are possible)
Holding my breath to get an answer,
Sergei
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
Sergei Turin
2014-02-25 13:20:20 UTC
Permalink
Post by Spokey Wheeler
Have you tried SDK 2.81TCx?
Post by Sergei Turin
Dear colleagues,
I am really stuck with ODBC/OLEDB/SQL Server Integration Services connectivity to our production box still running IDS 7.31UC6AX7.
We need to copy portions of data to datamart server. Before the damned change, it was SQL 2005 32bit (+ SDK 2.81TCx). Now it is _upgraded_ to SQL 2008R2 (+ SDK 3.70TC4)and old good ODBC connections does not work.
I tried to switch to OLEDB and even SSIS (with different versions of SDK) but reliable connection is still not available. I found myself in a black despair because production box is close to 100% fullness and I cannot move data to datamart one to free the dbspaces.
The only question I have is there a good, tested, reliable combination of IDS and CSDK to connect the following
Source Server
HP-UX 11.11i
IDS 7.31UC6AX7
Destination Server
Windows Server 2003 / 2003 R2 / 2008 / 2008 R2 (could configure any version,
32bit or 64 bit)
SQL Server 2008 / 2008 R2 (again, both 32 or 64 bit editions are possible)
Holding my breath to get an answer,
Sergei
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
Have you tried SDK 2.81TCx?
Post by Sergei Turin
Dear colleagues,
I am really stuck with ODBC/OLEDB/SQL Server Integration Services connectivity to our production box still running IDS 7.31UC6AX7.
We need to copy portions of data to datamart server. Before the damned change, it was SQL 2005 32bit (+ SDK 2.81TCx). Now it is _upgraded_ to SQL 2008R2 (+ SDK 3.70TC4)and old good ODBC connections does not work.
I tried to switch to OLEDB and even SSIS (with different versions of SDK) but reliable connection is still not available. I found myself in a black despair because production box is close to 100% fullness and I cannot move data to datamart one to free the dbspaces.
The only question I have is there a good, tested, reliable combination of IDS and CSDK to connect the following
Source Server
HP-UX 11.11i
IDS 7.31UC6AX7
Destination Server
Windows Server 2003 / 2003 R2 / 2008 / 2008 R2 (could configure any version,
32bit or 64 bit)
SQL Server 2008 / 2008 R2 (again, both 32 or 64 bit editions are possible)
Holding my breath to get an answer,
Sergei
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
Have you tried SDK 2.81TCx?
Post by Sergei Turin
Dear colleagues,
I am really stuck with ODBC/OLEDB/SQL Server Integration Services connectivity to our production box still running IDS 7.31UC6AX7.
We need to copy portions of data to datamart server. Before the damned change, it was SQL 2005 32bit (+ SDK 2.81TCx). Now it is _upgraded_ to SQL 2008R2 (+ SDK 3.70TC4)and old good ODBC connections does not work.
I tried to switch to OLEDB and even SSIS (with different versions of SDK) but reliable connection is still not available. I found myself in a black despair because production box is close to 100% fullness and I cannot move data to datamart one to free the dbspaces.
The only question I have is there a good, tested, reliable combination of IDS and CSDK to connect the following
Source Server
HP-UX 11.11i
IDS 7.31UC6AX7
Destination Server
Windows Server 2003 / 2003 R2 / 2008 / 2008 R2 (could configure any version,
32bit or 64 bit)
SQL Server 2008 / 2008 R2 (again, both 32 or 64 bit editions are possible)
Holding my breath to get an answer,
Sergei
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
Yes, with both SS 2008R2 32 and 64 bit.
Sergei Turin
2014-02-25 13:22:12 UTC
Permalink
Post by Spokey Wheeler
Have you tried SDK 2.81TCx?
Spokey Wheeler
2014-02-25 13:31:56 UTC
Permalink
What error messages do you get?
Post by Sergei Turin
Post by Spokey Wheeler
Have you tried SDK 2.81TCx?
Yes, with both SS 2008R2 32 and 64 bit.
_______________________________________________
Informix-list mailing list
http://www.iiug.org/mailman/listinfo/informix-list
Sergei Turin
2014-02-26 09:02:12 UTC
Permalink
Post by Spokey Wheeler
What error messages do you get?
Post by Sergei Turin
http://www.iiug.org/mailman/listinfo/informix-list
There are many, but this one is my fauvorite. While trying to get portion of data from Informix server, like this



INSERT INTO t1

SELECT * FROM OPENQUERY(LS_NAME,'SELECT fields FROM t1_on_server')



I get error Cannot convert DATETIMESTAMP to DATETIME. However, if I will change the query getting only datetime fields from Informix database (leaving out any other fields,

like this



INSERT INTO t1 (dt_field1, dt_field2,...., dt_fieldN)

SELECT * FROM OPENQUERY(LS_NAME, 'SELECT dt_fields FROM t1_on_server)



the query wents ok and inserts all rows into destination table (!).



I gave up with ODBC and even OLEDB connections and tried to use SSIS. Error messages now include



1) -201 trying to get columns from source table (bypassed it by using SQL query as a data source)

2) package execution failures just after setnet32 database and client locale settings change

3) OLEDB ACQUIRECONNECTION errors at execution start etc etc
s***@t-online.de
2014-02-26 16:43:04 UTC
Permalink
You can always use JDBC and java, the only thing you need to do is implementing
the datatypes as classes and use metadata.

Superboer
Post by Sergei Turin
Dear colleagues,
I am really stuck with ODBC/OLEDB/SQL Server Integration Services connectivity to our production box still running IDS 7.31UC6AX7.
We need to copy portions of data to datamart server. Before the damned change, it was SQL 2005 32bit (+ SDK 2.81TCx). Now it is _upgraded_ to SQL 2008R2 (+ SDK 3.70TC4)and old good ODBC connections does not work.
I tried to switch to OLEDB and even SSIS (with different versions of SDK) but reliable connection is still not available. I found myself in a black despair because production box is close to 100% fullness and I cannot move data to datamart one to free the dbspaces.
The only question I have is there a good, tested, reliable combination of IDS and CSDK to connect the following
Source Server
HP-UX 11.11i
IDS 7.31UC6AX7
Destination Server
Windows Server 2003 / 2003 R2 / 2008 / 2008 R2 (could configure any version,
32bit or 64 bit)
SQL Server 2008 / 2008 R2 (again, both 32 or 64 bit editions are possible)
Holding my breath to get an answer,
Sergei
Loading...