Best approach with DTS

Let me see if I can explain this.

I have the need to pull data from multiple tables from a DB2 system via ODBC and update or insert as needed into tables in a SQL200 DB.

Step 1.
The data from the initial parent table will need to be limited to being a set number of days old, which I have in place and working.

Step 2
The next tables data needs to be limited from the data retrieved in step 1 (Id like to use the paprent table retrieved in step 1, that is in SQL now, rather than doing it on the DB2 side.

Step 3
The returned rows here, need to be limited to key values returned from step 2

Additional steps apply, but nearly all will be limited to the results of parent tables from the prior step.

What is the best approach to this? I really want to pull table A to SQL, and limit the next child set from Table A, that was pulled to SQL in the prior step.

I also need to do updates rather than dropping and creating the needed tables each time. Insert if no key exists, etc .etc.

What is the best approach?I think DTS is better in this regard.
You need to workout to re-arrange data based upon the requirement.
Once data is imported you can contro updations from SQL side using normal TSQL.|||I think I'm going to continue to limit the selection on the db2 side based on sub queries. Initially set it up to drop and create the tables each time, and after that's all done, modify to import into temp tables from dts and then use sql to update the existing tables from the temp tables, I think this is the approach I'm going to take.

I'm open to ideas for alternatives

Benchmark of ODBC vs Oracle Net8 for Connectivity

Do any one have any unbiased benchmarks of the performance differences of
connecting an Oracle 9i DB to MS SQL Server 2000 via ODBC vs NET8?
References for any pros and cons.
Any guidance would be appreciated!!!!
Don't think you can really compare the two in terms of
connecting with SQL Server. You need to use ODBC or OLE DB
to connect to an Oracle database. The server needs to have
the Oracle client installed. You don't use just the Oracle
components (such as Net 8) to connect to Oracle but the
Oracle client components are a part of the connectivity when
using ODBC or OLE DB against an Oracle database.
-Sue
On Fri, 10 Sep 2004 15:05:02 -0700, "Mike"
<Mike@.discussions.microsoft.com> wrote:

>Do any one have any unbiased benchmarks of the performance differences of
>connecting an Oracle 9i DB to MS SQL Server 2000 via ODBC vs NET8?
>References for any pros and cons.
>Any guidance would be appreciated!!!!

BDE Connection via ODBC to MS SQL Server fails

Hi,

I have a strange problem accessing a MS SQL Database from my network.
I'm using an application that is based on BDE which uses ODBC to connect to a MS SQL DB.
When I tried to connect from the network with BDE,I got this error message:

BDE Error : 13059
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).

On the server side I'm using W2003 EE ,MS SQL 2000 Standard with SP4, BDE5.11.
On the client side it's an XP SP2 with MS SQL Client installed, same BDE 5.11
When I create an alias using ODBC and mapping to my server, it connects and the communication with the Database Server succeds:
TESTS COMPLETED SUCCESSFULLY!
When I'm trying to connect using BDE Admin and double clicking on the + sign of the alias I created usind ODBC admin I get the message I listed above.
Any help would be appreciated,

Thanks.May check this http://support.plato.com/kb/tip.asp?psid=23252 link fyi.|||Thank you for replying me...in the meantime i solved the problem.
It was the incorrect settings in the registry for BDE. After erasing the keys from the registry and having reinstalled the BDE everything worked fine.
There are some files used by BDE when connecting to SQL server which are not installed when using Delphi 5 or later :(

However thank you for the usefull link.

best regards,
Sanyi|||Glad the issue is resolved and appreciate your feedback on posting the solution, that helps.

BDE and ODBC

Hi board, I'm very new to databases and am taking over my small company's saleslogix database before too long...

My question is:

What is the relationship between ODBC and BDE? For connectivity purposes, are they independent from each other or do they interact with in some way? As far as I can tell they have the same function.

thanks for your help! i'll be spending a lot of time on this board as i begin a DB crash course.

RyanHi,

A little bit late, and probably have worked this out, however SalesLogix uses BDE as a layer in between SalesLogix and the Microsoft Database Communication layer. This is used in SalesLogix 6 as a direct communication cutting out BDE.

ODBC sits also on top of the Microsoft Database Communcation layer so both are near enough the same. However BDE can communication directly to this layer as well as to ODBC, so allowing a more open environment for development. So allowing communication with lots of different database and data sources.

The main reason why SalesLogix uses BDE as it also uses Delphi programming language, so you can write additional background scripts that get executed when updates / deletes etc... happen. So creating the tefs that are needed for synchronisation.

Hope that helps a lot...