Thread: Error Message
System Information ------------------------------------------------------------ Platform: Windows XP Version: 5.1 Build: 2600 Service Pack 1 ============================================================ Application Information ------------------------------------------------------------ Name: pgAdmin II Version: 1.5.30 Descripton: ------------------------------------------------------------ Name: pgSchema Version: 1.5.30 Descripton: PostgreSQL Schema Objects v1.5.30 ============================================================ Database Information ------------------------------------------------------------ Version: 0.0.0 Descripton: ============================================================ Driver Information ------------------------------------------------------------ Name: Version: 0.0.0 Descripton: ============================================================ Error Information ------------------------------------------------------------ Description: Method '~' of object '~' failed Number: -2147024769 Routine: pgAdmin II:frmConnect.cmdConnect_Click ************************************************************ Insert your comment: Hi, I was using version 1.4.12 regularly until it stopped working (with the same error as above) after I upgraded from Windows 2000 SP3 to Windows XP SP1. I tried uninstalling it and reinstalling 1.4.12 as well as mdac 2.7 SP1 and older versions but nothing has worked so far. I was surprised not to find anyone else with the same problems on google, but as far as I know the windows upgrade completed successfully. Anyway I checked out pgadmin2, pgschema, activex and binaries from CVS. This message is from the version in binaries. I have been unable to build the source so far due to installation specific values in the vb project files. I'm about to look into pgadmin3. Cheers!
> -----Original Message----- > From: Michael Judd [mailto:mjudd@optushome.com.au] > Sent: 19 April 2003 06:32 > To: pgadmin-support@postgresql.org > Subject: [pgadmin-support] Error Message > > Hi, > I was using version 1.4.12 regularly until it stopped working > (with the same error as above) after I upgraded from Windows > 2000 SP3 to Windows XP SP1. I tried uninstalling it and > reinstalling 1.4.12 as well as mdac 2.7 SP1 and older > versions but nothing has worked so far. I was surprised not > to find anyone else with the same problems on google, but as > far as I know the windows upgrade completed successfully. Hi, I have heard of this problem before following a Win2k -> XP upgrade, and unfortunately never found a fix myself, or heard of anyone else who did. > Anyway I checked out pgadmin2, pgschema, activex and binaries > from CVS. This message is from the version in binaries. I > have been unable to build the source so far due to > installation specific values in the vb project files. If you have a copy of VB then that might be the easiest fix. What were the installation specific values you found? If you are referring to the dll paths in each file, don't worry about them - VB uses the GUID and completely ignores the path. One of our developers is in Italy, and you can imagine how different his paths are yet his code works fine in .uk. > I'm about to look into pgadmin3. Cheers! I obviously don't know your requirements, but you might find it a little immature for production use. If you just want to browse the schema hierarchy, and execute the odd SQL query, then you should be OK though. Regards, Dave.
Hello,
The paths to VB6.exe in the BuildAll.bat file were easy to fix, but I get
message boxes popping up with messages similar to the following as each
target is built when executing it...
'X:\correct\path\to\pgDatabase.cls' could not be loaded
I thought maybe it had something to do with the Refernce lines in the vbp
files such as...
Reference=*\G{00020430-0000-0000-C000-000000000046}#2.0#0#wrong\path\to\Syst
em32\stdole2.tlb#OLE Automation
Reference=*\G{00000200-0000-0010-8000-00AA006D2EA4}#2.0#0#wrong\path\to\Prog
ram Files\Common Files\system\ado\msado20.tlb#Microsoft ActiveX Data
but changing them didn't help.
Anyway I'm guessing from all this that maybe mdac 2.7 SP1 isn't backwards
compatible? But if it works for other people using Windows XP SP1 I guess
that's not it.
Sorry I'm not much help!
Doesn't matter, I can still use pgAdmin2 on NT. Great tool by the way.
Cheers!
Mike.
> -----Original Message-----
> From: Michael Judd [mailto:mjudd@optushome.com.au]
> Sent: 19 April 2003 06:32
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Error Message
>
> Hi,
> I was using version 1.4.12 regularly until it stopped working
> (with the same error as above) after I upgraded from Windows
> 2000 SP3 to Windows XP SP1. I tried uninstalling it and
> reinstalling 1.4.12 as well as mdac 2.7 SP1 and older
> versions but nothing has worked so far. I was surprised not
> to find anyone else with the same problems on google, but as
> far as I know the windows upgrade completed successfully.
Hi,
I have heard of this problem before following a Win2k -> XP upgrade, and
unfortunately never found a fix myself, or heard of anyone else who did.
> Anyway I checked out pgadmin2, pgschema, activex and binaries
> from CVS. This message is from the version in binaries. I
> have been unable to build the source so far due to
> installation specific values in the vb project files.
If you have a copy of VB then that might be the easiest fix. What were
the installation specific values you found? If you are referring to the
dll paths in each file, don't worry about them - VB uses the GUID and
completely ignores the path. One of our developers is in Italy, and you
can imagine how different his paths are yet his code works fine in .uk.
> I'm about to look into pgadmin3. Cheers!
I obviously don't know your requirements, but you might find it a little
immature for production use. If you just want to browse the schema
hierarchy, and execute the odd SQL query, then you should be OK though.
Regards, Dave.
> -----Original Message----- > From: Michael Judd [mailto:mjudd@optushome.com.au] > Sent: 20 April 2003 01:15 > To: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Error Message > > > Hello, > The paths to VB6.exe in the BuildAll.bat file were easy to > fix, but I get message boxes popping up with messages similar > to the following as each target is built when executing it... > 'X:\correct\path\to\pgDatabase.cls' could not be loaded Hi, It sounds like you have got the files from the CVS with Unix line ends. Did you download a tarball, or use CVS itself? Regards, Dave.
> -----Original Message----- > From: frank_lupo [mailto:frank_lupo@email.it] > Sent: 19 April 2003 22:27 > To: Dave Page > Cc: mjudd; pgadmin-support > Subject: Re: [pgadmin-support] Error Message > > > Hi Dave, > > You could explain better the problem to me? Hi Frank, It's giving an error: Method '~' or object '~' failed. I've seen this following a win 2k->XP upgrade before, but never heard of, or found a fix. Regards, Dave.
Hi, After wasting everyone's time I've finally worked out that my problems aren't PostgreSQL/pgadmin2 specific. Since the upgrade all code that uses Adodc controls and Connection objects have stopped working though code that uses rdoConnection objects still work fine, no matter what the data source (PostgreSQL/MS Access Files). That'll teach me to upgrade for no reason...maybe. Cheers! Mike. -----Original Message----- From: Dave Page [mailto:dpage@vale-housing.co.uk] Sent: Sunday, 20 April 2003 6:21 PM To: frank_lupo Cc: mjudd; pgadmin-support Subject: RE: [pgadmin-support] Error Message > -----Original Message----- > From: frank_lupo [mailto:frank_lupo@email.it] > Sent: 19 April 2003 22:27 > To: Dave Page > Cc: mjudd; pgadmin-support > Subject: Re: [pgadmin-support] Error Message > > > Hi Dave, > > You could explain better the problem to me? Hi Frank, It's giving an error: Method '~' or object '~' failed. I've seen this following a win 2k->XP upgrade before, but never heard of, or found a fix. Regards, Dave.
>Hi, > >It sounds like you have got the files from the CVS with Unix line ends. >Did you download a tarball, or use CVS itself? > >Regards, Dave. Hi Dave, Yep, you're right...I was checking out with CVS using Unix line ends. It's building fine now. Thanks for that! Mike.
> -----Original Message----- > From: Michael Judd [mailto:mjudd@optushome.com.au] > Sent: 21 April 2003 13:57 > To: pgadmin-support@postgresql.org > Subject: Re: [pgadmin-support] Error Message > > > >Hi, > > > >It sounds like you have got the files from the CVS with Unix > line ends. > >Did you download a tarball, or use CVS itself? > > > >Regards, Dave. > > Hi Dave, > Yep, you're right...I was checking out with CVS using Unix > line ends. It's building fine now. Thanks for that! Mike. Excellent. Let me know if you have any problems. Regards, Dave.