Hi there,
I am having problems using the latest version of the driver (Both the
stable and the beta version) from a DTS package on a Win2K server box
with SQL server 2000.
I am trying to pull data from a postgresql 7.2.1 database, and the
problem is that when I try an specify a transformation with the ODBC
connection being the destination, the mmc.exe program starts leaking
memory at about a MB/sec and the application gui freezes.
I am not sure if this is just a bug in the Microsoft program, or if it
is related to using the ODBC driver.
Has anyone else experienced this?
Here is the query from the MS SQL database I am trying to insert into a
postgresql database via DTS
select 'host401' as key, max([identity]) as lastidentity from alldata
and the postgresql query I am trying to pull into a MSSQL database
select * from alldata where "identity" > (select max("identity") from
replicationinfo where key='host401')
I have successfully used this from an xp system with sqlserver 2000 (But
without servicepack3), but have had no luck from a windows2000 system
with servicepack3.
Again, the leak occurs when I click on the transformation tab. So this
would be parsing the query via the ODBC driver I imagine, and trying to
get back tha names/types of the result set that the query would return.
--
David Stanaway
DialMex LLC
NOC Engineer
200 S. 10th Street Suite 1209
McAllen, TX 78501
(956) 994-0014 x111 office
(956) 239-0840 mobile
(956) 682-5821 fax
david@dialmex.net