From: | David Stanaway <david(at)dialmex(dot)net> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Problem using ODBC driver from MS SQL DTS package |
Date: | 2003-04-28 21:41:33 |
Message-ID: | 1051566093.26291.57.camel@david.dialmex.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(at)dialmex(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | Wayne Armstrong | 2003-04-28 22:02:27 | Re: Anyone else seeing CREATE TABLE crashes with psqlodbc? |
Previous Message | Jon V | 2003-04-28 21:37:05 | ODBC Behavior, where do I find help? |