Thread: ODBC driver crashing both Enterprise manager and pgAdminII?

ODBC driver crashing both Enterprise manager and pgAdminII?

From
"Greg Maples"
Date:
Hi.  I've taken a look at the archives and not seen this error
documented.  I also installed on a second machine to verify the
behavior and it repeated itself.

MS Windows 2000, SP3, v 5.00.2915
postgres odbc driver file version 7.2.5.0,
Enterprise manager console v. 1.2
pgAdminII v. 1.4.12

Behavior 1:
    Launch pgAdminII
    Select connect from file
    Enter connection data
        <IP Addr>, port 5432, login name postgres

    Result is:
        "Program Error"
        pgAdmin2.exe has generated errors and will be closed
        by windows.  You will need to restart the program.
        An error log is being created.

Behavior 2:
    Run Enterprise manager
    Create System DSN
    Connect to server group,
    Connect to server,
    Select DTS,
    Select Local Packages
    New package, Connection
    Other connection, PostgreSQL,
    System DSN, etc.

    Result is:
        "Program Error"
        mmc.exe has generated errors and will be closed
        by windows.  You will need to restart the program.
        An error log is being created.

Error/Etc Logs:

mylog:
    [1348]globals.extra_systable_prefixes = 'dd_;'
pgAdminII log:
    2003-05-12 14:56:35 - SQL (template1): SELECT version()
    2003-05-12 14:56:35 - SQL (template1): SELECT datlastsysoid FROM
pg_database WHERE datname = 'template1'

    2003-05-12 14:56:35 -
*******************************************************************
    2003-05-12 14:56:35 - Error(s)
    2003-05-12 14:56:35 -
*******************************************************************
    2003-05-12 14:56:35 - Error in pgAdmin
II:frmConnect.cmdConnect_Click: -2147417848 - Automation error
    The object invoked has disconnected from its clients.

    2003-05-12 14:56:35 - Windows Version: Windows 2000 v5.0 build 2195 Service
Pack 3
    2003-05-12 14:56:35 - pgSchema Version: 1.4.12
    2003

============================================================

Any help would be appreciated.  I'd *really* like to be able to
evaluate transitioning from mssql2000 to postgresql, but I'm stopped
at the moment by this odbc problem.

Thanks in advance.  Please reply directly to greg at linkify.com
and I'll post any interesting results to the list.

Greg


Re: ODBC driver crashing both Enterprise manager and pgAdminII?

From
"eladio rodriguez"
Date:
hi.

ftp://ftp.us.postgresql.org/odbc/versions/full/

ver. 7.3.100

good luck.


>From: "Greg Maples" <greg.maples@linkify.com>
>Reply-To: <greg.maples@linkify.com>
>To: <pgsql-odbc@postgresql.org>
>Subject: [ODBC] ODBC driver crashing both Enterprise manager and pgAdminII?
>Date: Mon, 12 May 2003 15:06:12 -0700
>
>
>Hi.  I've taken a look at the archives and not seen this error
>documented.  I also installed on a second machine to verify the
>behavior and it repeated itself.
>
>MS Windows 2000, SP3, v 5.00.2915
>postgres odbc driver file version 7.2.5.0,
>Enterprise manager console v. 1.2
>pgAdminII v. 1.4.12
>
>Behavior 1:
>    Launch pgAdminII
>    Select connect from file
>    Enter connection data
>        <IP Addr>, port 5432, login name postgres
>
>    Result is:
>        "Program Error"
>        pgAdmin2.exe has generated errors and will be closed
>        by windows.  You will need to restart the program.
>        An error log is being created.
>
>Behavior 2:
>    Run Enterprise manager
>    Create System DSN
>    Connect to server group,
>    Connect to server,
>    Select DTS,
>    Select Local Packages
>    New package, Connection
>    Other connection, PostgreSQL,
>    System DSN, etc.
>
>    Result is:
>        "Program Error"
>        mmc.exe has generated errors and will be closed
>        by windows.  You will need to restart the program.
>        An error log is being created.
>
>Error/Etc Logs:
>
>mylog:
>    [1348]globals.extra_systable_prefixes = 'dd_;'
>pgAdminII log:
>    2003-05-12 14:56:35 - SQL (template1): SELECT version()
>    2003-05-12 14:56:35 - SQL (template1): SELECT datlastsysoid FROM
>pg_database WHERE datname = 'template1'
>
>    2003-05-12 14:56:35 -
>*******************************************************************
>    2003-05-12 14:56:35 - Error(s)
>    2003-05-12 14:56:35 -
>*******************************************************************
>    2003-05-12 14:56:35 - Error in pgAdmin
>II:frmConnect.cmdConnect_Click: -2147417848 - Automation error
>    The object invoked has disconnected from its clients.
>
>    2003-05-12 14:56:35 - Windows Version: Windows 2000 v5.0 build 2195
>Service
>Pack 3
>    2003-05-12 14:56:35 - pgSchema Version: 1.4.12
>    2003
>
>============================================================
>
>Any help would be appreciated.  I'd *really* like to be able to
>evaluate transitioning from mssql2000 to postgresql, but I'm stopped
>at the moment by this odbc problem.
>
>Thanks in advance.  Please reply directly to greg at linkify.com
>and I'll post any interesting results to the list.
>
>Greg
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.yupimsn.com/


Re: ODBC driver crashing both Enterprise manager and pgAdminII?

From
Jeff Eckermann
Date:
Are you able to make an ODBC connection from any other
application, e.g. MS Access, MS Excel?
If you continue to have trouble, please post your
driver settings, which may provide a clue.

--- Greg Maples <greg.maples@linkify.com> wrote:
>
> Hi.  I've taken a look at the archives and not seen
> this error
> documented.  I also installed on a second machine to
> verify the
> behavior and it repeated itself.
>
> MS Windows 2000, SP3, v 5.00.2915
> postgres odbc driver file version 7.2.5.0,
> Enterprise manager console v. 1.2
> pgAdminII v. 1.4.12
>
> Behavior 1:
>     Launch pgAdminII
>     Select connect from file
>     Enter connection data
>         <IP Addr>, port 5432, login name postgres
>
>     Result is:
>         "Program Error"
>         pgAdmin2.exe has generated errors and will be
> closed
>         by windows.  You will need to restart the program.
>         An error log is being created.
>
> Behavior 2:
>     Run Enterprise manager
>     Create System DSN
>     Connect to server group,
>     Connect to server,
>     Select DTS,
>     Select Local Packages
>     New package, Connection
>     Other connection, PostgreSQL,
>     System DSN, etc.
>
>     Result is:
>         "Program Error"
>         mmc.exe has generated errors and will be closed
>         by windows.  You will need to restart the program.
>         An error log is being created.
>
> Error/Etc Logs:
>
> mylog:
>     [1348]globals.extra_systable_prefixes = 'dd_;'
> pgAdminII log:
>     2003-05-12 14:56:35 - SQL (template1): SELECT
> version()
>     2003-05-12 14:56:35 - SQL (template1): SELECT
> datlastsysoid FROM
> pg_database WHERE datname = 'template1'
>
>     2003-05-12 14:56:35 -
>
*******************************************************************
>     2003-05-12 14:56:35 - Error(s)
>     2003-05-12 14:56:35 -
>
*******************************************************************
>     2003-05-12 14:56:35 - Error in pgAdmin
> II:frmConnect.cmdConnect_Click: -2147417848 -
> Automation error
>     The object invoked has disconnected from its
> clients.
>
>     2003-05-12 14:56:35 - Windows Version: Windows 2000
> v5.0 build 2195 Service
> Pack 3
>     2003-05-12 14:56:35 - pgSchema Version: 1.4.12
>     2003
>
>
============================================================
>
> Any help would be appreciated.  I'd *really* like to
> be able to
> evaluate transitioning from mssql2000 to postgresql,
> but I'm stopped
> at the moment by this odbc problem.
>
> Thanks in advance.  Please reply directly to greg at
> linkify.com
> and I'll post any interesting results to the list.
>
> Greg
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

Re: ODBC driver crashing both Enterprise manager and pgAdminII?

From
Jeff Eckermann
Date:
--- Greg Maples <greg.maples@linkify.com> wrote:

> That being said, my working assumption
> is that there is
> A network level difference.  That could either be in
> the driver or
> The card.

Sounds like it.  PGAdminII/psqlodbc have always worked
flawlessly for me, subject to my own limitations of
course ;-)

__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

Re: ODBC driver crashing both Enterprise manager and pgAdminII?

From
"Dave Page"
Date:
My guess is you're running the server on Redhat 8/9 or something else
with a similarly long PostgreSQL  version string? If so, the updated
driver should fix it.

Regards, Dave.

> -----Original Message-----
> From: eladio rodriguez [mailto:elarod_od@hotmail.com]
> Sent: 16 May 2003 20:40
> To: greg.maples@linkify.com; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] ODBC driver crashing both Enterprise
> manager and pgAdminII?
>
>
> hi.
>
> ftp://ftp.us.postgresql.org/odbc/versions/full/
>
> ver. 7.3.100
>
> good luck.
>
>
> >From: "Greg Maples" <greg.maples@linkify.com>
> >Reply-To: <greg.maples@linkify.com>
> >To: <pgsql-odbc@postgresql.org>
> >Subject: [ODBC] ODBC driver crashing both Enterprise manager and
> >pgAdminII?
> >Date: Mon, 12 May 2003 15:06:12 -0700
> >
> >
> >Hi.  I've taken a look at the archives and not seen this error
> >documented.  I also installed on a second machine to verify the
> >behavior and it repeated itself.
> >
> >MS Windows 2000, SP3, v 5.00.2915
> >postgres odbc driver file version 7.2.5.0,
> >Enterprise manager console v. 1.2
> >pgAdminII v. 1.4.12
> >
> >Behavior 1:
> >    Launch pgAdminII
> >    Select connect from file
> >    Enter connection data
> >        <IP Addr>, port 5432, login name postgres
> >
> >    Result is:
> >        "Program Error"
> >        pgAdmin2.exe has generated errors and will be closed
> >        by windows.  You will need to restart the program.
> >        An error log is being created.
> >
> >Behavior 2:
> >    Run Enterprise manager
> >    Create System DSN
> >    Connect to server group,
> >    Connect to server,
> >    Select DTS,
> >    Select Local Packages
> >    New package, Connection
> >    Other connection, PostgreSQL,
> >    System DSN, etc.
> >
> >    Result is:
> >        "Program Error"
> >        mmc.exe has generated errors and will be closed
> >        by windows.  You will need to restart the program.
> >        An error log is being created.
> >
> >Error/Etc Logs:
> >
> >mylog:
> >    [1348]globals.extra_systable_prefixes = 'dd_;'
> >pgAdminII log:
> >    2003-05-12 14:56:35 - SQL (template1): SELECT version()
> >    2003-05-12 14:56:35 - SQL (template1): SELECT
> datlastsysoid FROM
> >pg_database WHERE datname = 'template1'
> >
> >    2003-05-12 14:56:35 -
> >*******************************************************************
> >    2003-05-12 14:56:35 - Error(s)
> >    2003-05-12 14:56:35 -
> >*******************************************************************
> >    2003-05-12 14:56:35 - Error in pgAdmin
> >II:frmConnect.cmdConnect_Click: -2147417848 - Automation error
> >    The object invoked has disconnected from its clients.
> >
> >    2003-05-12 14:56:35 - Windows Version: Windows 2000
> v5.0 build 2195
> >Service
> >Pack 3
> >    2003-05-12 14:56:35 - pgSchema Version: 1.4.12
> >    2003
> >
> >============================================================
> >
> >Any help would be appreciated.  I'd *really* like to be able to
> >evaluate transitioning from mssql2000 to postgresql, but I'm
> stopped at
> >the moment by this odbc problem.
> >
> >Thanks in advance.  Please reply directly to greg at linkify.com and
> >I'll post any interesting results to the list.
> >
> >Greg
> >
> >
> >---------------------------(end of
> >broadcast)---------------------------
> >TIP 6: Have you searched our list archives?
> >
> >http://archives.postgresql.org
>
> _________________________________________________________________
> Charla con tus amigos en lnea mediante MSN Messenger:
> http://messenger.yupimsn.com/
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an
> appropriate subscribe-nomail command to
> majordomo@postgresql.org so that your message can get through
> to the mailing list cleanly
>

Re: ODBC driver crashing both Enterprise manager and pgAdminII?

From
"Greg Maples"
Date:
I believe I've narrowed it down some.  I moved the postgresql server
Instance to another machine and the ODBC connection and subsequent
Import ran flawlessly.  The versions were similar but not identical,
And I don't currently have cycles to do an exact version to version
Comparison.  That being said, my working assumption is that there is
A network level difference.  That could either be in the driver or
The card.

My best guess is that the odbc driver code expects some level of
Reliability in the connection and the port is either jabbering or
Colliding.  Not much else would make sense.

-----Original Message-----
From: Jeff Eckermann [mailto:jeff_eckermann@yahoo.com]
Sent: Friday, May 16, 2003 12:53 PM
To: greg.maples@linkify.com; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] ODBC driver crashing both Enterprise manager and
pgAdminII?

Are you able to make an ODBC connection from any other
application, e.g. MS Access, MS Excel?
If you continue to have trouble, please post your
driver settings, which may provide a clue.

--- Greg Maples <greg.maples@linkify.com> wrote:
>
> Hi.  I've taken a look at the archives and not seen
> this error
> documented.  I also installed on a second machine to
> verify the
> behavior and it repeated itself.
>
> MS Windows 2000, SP3, v 5.00.2915
> postgres odbc driver file version 7.2.5.0,
> Enterprise manager console v. 1.2
> pgAdminII v. 1.4.12
>
> Behavior 1:
>     Launch pgAdminII
>     Select connect from file
>     Enter connection data
>         <IP Addr>, port 5432, login name postgres
>
>     Result is:
>         "Program Error"
>         pgAdmin2.exe has generated errors and will be
> closed
>         by windows.  You will need to restart the program.
>         An error log is being created.
>
> Behavior 2:
>     Run Enterprise manager
>     Create System DSN
>     Connect to server group,
>     Connect to server,
>     Select DTS,
>     Select Local Packages
>     New package, Connection
>     Other connection, PostgreSQL,
>     System DSN, etc.
>
>     Result is:
>         "Program Error"
>         mmc.exe has generated errors and will be closed
>         by windows.  You will need to restart the program.
>         An error log is being created.
>
> Error/Etc Logs:
>
> mylog:
>     [1348]globals.extra_systable_prefixes = 'dd_;'
> pgAdminII log:
>     2003-05-12 14:56:35 - SQL (template1): SELECT
> version()
>     2003-05-12 14:56:35 - SQL (template1): SELECT
> datlastsysoid FROM
> pg_database WHERE datname = 'template1'
>
>     2003-05-12 14:56:35 -
>
*******************************************************************
>     2003-05-12 14:56:35 - Error(s)
>     2003-05-12 14:56:35 -
>
*******************************************************************
>     2003-05-12 14:56:35 - Error in pgAdmin
> II:frmConnect.cmdConnect_Click: -2147417848 -
> Automation error
>     The object invoked has disconnected from its
> clients.
>
>     2003-05-12 14:56:35 - Windows Version: Windows 2000
> v5.0 build 2195 Service
> Pack 3
>     2003-05-12 14:56:35 - pgSchema Version: 1.4.12
>     2003
>
>
============================================================
>
> Any help would be appreciated.  I'd *really* like to
> be able to
> evaluate transitioning from mssql2000 to postgresql,
> but I'm stopped
> at the moment by this odbc problem.
>
> Thanks in advance.  Please reply directly to greg at
> linkify.com
> and I'll post any interesting results to the list.
>
> Greg
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com



Re: ODBC driver crashing both Enterprise manager and pgAdminII?

From
"Dave Page"
Date:
It's rumoured that Greg Maples once said:

> My best guess is that the odbc driver code expects some level of
> Reliability in the connection and the port is either jabbering or
> Colliding.  Not much else would make sense.

There is a known bug in the driver that causes exactly the symptoms you
describe in pgAdmin and would probably affect DTS as well. In a nutshell,
recent versions of Redhat Linux have an extemely long compiler version
string that consequently make the PostgreSQL version string very long. In
ealier versions of psqlODBC, this would cause a crash at logon when the
database version was requested using the SQLInfo function because a
temporary buffer created to store the data would overflow.
Did you try the updated driver yet that was suggested?

Regards, Dave.



Re: ODBC driver crashing both Enterprise manager and pgAdminII?

From
"Greg Maples"
Date:
Installing this generated "Internal Error 2103.26"


-----Original Message-----
From: eladio rodriguez [mailto:elarod_od@hotmail.com]
Sent: Friday, May 16, 2003 12:40 PM
To: greg.maples@linkify.com; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] ODBC driver crashing both Enterprise manager and
pgAdminII?

hi.

ftp://ftp.us.postgresql.org/odbc/versions/full/

ver. 7.3.100

good luck.


>From: "Greg Maples" <greg.maples@linkify.com>
>Reply-To: <greg.maples@linkify.com>
>To: <pgsql-odbc@postgresql.org>
>Subject: [ODBC] ODBC driver crashing both Enterprise manager and
pgAdminII?
>Date: Mon, 12 May 2003 15:06:12 -0700
>
>
>Hi.  I've taken a look at the archives and not seen this error
>documented.  I also installed on a second machine to verify the
>behavior and it repeated itself.
>
>MS Windows 2000, SP3, v 5.00.2915
>postgres odbc driver file version 7.2.5.0,
>Enterprise manager console v. 1.2
>pgAdminII v. 1.4.12
>
>Behavior 1:
>    Launch pgAdminII
>    Select connect from file
>    Enter connection data
>        <IP Addr>, port 5432, login name postgres
>
>    Result is:
>        "Program Error"
>        pgAdmin2.exe has generated errors and will be closed
>        by windows.  You will need to restart the program.
>        An error log is being created.
>
>Behavior 2:
>    Run Enterprise manager
>    Create System DSN
>    Connect to server group,
>    Connect to server,
>    Select DTS,
>    Select Local Packages
>    New package, Connection
>    Other connection, PostgreSQL,
>    System DSN, etc.
>
>    Result is:
>        "Program Error"
>        mmc.exe has generated errors and will be closed
>        by windows.  You will need to restart the program.
>        An error log is being created.
>
>Error/Etc Logs:
>
>mylog:
>    [1348]globals.extra_systable_prefixes = 'dd_;'
>pgAdminII log:
>    2003-05-12 14:56:35 - SQL (template1): SELECT version()
>    2003-05-12 14:56:35 - SQL (template1): SELECT datlastsysoid FROM
>pg_database WHERE datname = 'template1'
>
>    2003-05-12 14:56:35 -
>*******************************************************************
>    2003-05-12 14:56:35 - Error(s)
>    2003-05-12 14:56:35 -
>*******************************************************************
>    2003-05-12 14:56:35 - Error in pgAdmin
>II:frmConnect.cmdConnect_Click: -2147417848 - Automation error
>    The object invoked has disconnected from its clients.
>
>    2003-05-12 14:56:35 - Windows Version: Windows 2000 v5.0 build
2195
>Service
>Pack 3
>    2003-05-12 14:56:35 - pgSchema Version: 1.4.12
>    2003
>
>============================================================
>
>Any help would be appreciated.  I'd *really* like to be able to
>evaluate transitioning from mssql2000 to postgresql, but I'm stopped
>at the moment by this odbc problem.
>
>Thanks in advance.  Please reply directly to greg at linkify.com
>and I'll post any interesting results to the list.
>
>Greg
>
>
>---------------------------(end of
broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org

_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:
http://messenger.yupimsn.com/