[pgadmin-support] Migration Wizard error type mismatch
Hi,
I'm trying to use the DB Migration Wizard to migrate an MS Access 97 .mdb
database to postgres 7.3. I first installed mdac and the jet engine, then
the wizard dll. In pgAdmin I connect to my database without any trouble,
but when I click on the migration wizard plugin, I get an errormessage.
This is the log:
2003-02-17 13:14:05 -
***
2003-02-17 13:14:05 - Error(s)
2003-02-17 13:14:05 -
***
2003-02-17 13:14:05 - Error in pgAdmin II:frmMain.mnuPluginsPlg_Click: 13
- Type mismatch
2003-02-17 13:14:05 - Windows Version: Windows NT v4.0 build 1381 Service
Pack 6
2003-02-17 13:14:05 - pgSchema Version: 1.4.12
2003-02-17 13:14:05 - MDAC Version: 2.7
2003-02-17 13:14:05 - DBMS Version: 07.02.0005 PostgreSQL 7.3 on
i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.1 20021207 (Gentoo Linux
3.2.1-20021207)
2003-02-17 13:14:05 - Connection String (Master Connection):
Provider=MSDASQL.1;Extended
Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=223.223.223.223;PORT=5432;UID=test;PWD=;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;TrueIsMinus1=0;BI=0"
Any idea what's causing this?
-S
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Re: [pgadmin-support] Migration Wizard error type mismatch
Hi,
It looks like you have the wrong version of the wizard for your version
of pgAdmin. Please download the correct version from
http://www.pgadmin.org/downloads
Regards, Dave.
> -Original Message-
> From: Silje Ausen [mailto:[EMAIL PROTECTED]]
> Sent: 17 February 2003 12:23
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Migration Wizard error type mismatch
>
>
> Hi,
>
> I'm trying to use the DB Migration Wizard to migrate an MS
> Access 97 .mdb database to postgres 7.3. I first installed
> mdac and the jet engine, then the wizard dll. In pgAdmin I
> connect to my database without any trouble, but when I click
> on the migration wizard plugin, I get an errormessage. This
> is the log:
>
> 2003-02-17 13:14:05 -
> ***
> 2003-02-17 13:14:05 - Error(s)
> 2003-02-17 13:14:05 -
> ***
> 2003-02-17 13:14:05 - Error in pgAdmin
> II:frmMain.mnuPluginsPlg_Click: 13
> - Type mismatch
>
> 2003-02-17 13:14:05 - Windows Version: Windows NT v4.0 build
> 1381 Service Pack 6 2003-02-17 13:14:05 - pgSchema Version:
> 1.4.12 2003-02-17 13:14:05 - MDAC Version: 2.7 2003-02-17
> 13:14:05 - DBMS Version: 07.02.0005 PostgreSQL 7.3 on
> i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.1 20021207
> (Gentoo Linux
> 3.2.1-20021207)
> 2003-02-17 13:14:05 - Connection String (Master Connection):
> Provider=MSDASQL.1;Extended
> Properties="DRIVER={PostgreSQL};DATABASE=template1;SERVER=223.
223.223.223;PORT=>
5432;UID=test;PWD=;ReadOnly=0;Protocol=6.4;FakeOidInde
> x=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSet
> tings=;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=254
> ;MaxLongVarcharSize=65536;Debug=0;CommLog=0;Optimizer=1;Ksqo=1
> ;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarchar=1
> ;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixe
> s=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0;Tr
> ueIsMinus1=0;BI=0"
>
> Any idea what's causing this?
>
> -S
>
>
> ---(end of
> broadcast)---
> TIP 3: if posting/reading through Usenet, please send an
> appropriate subscribe-nomail command to
> [EMAIL PROTECTED] so that your message can get through
> to the mailing list cleanly
>
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Re: [pgadmin-support] pgadmin2-1_4_12 CURSOR PROBLEM. IT RETURNS
I work with Devangj. If pgAdmin II doesn't support cursors, why were we consistently returning cursors with the PostgreSQL 7.2-compatable version of pgAdminII. Was that a fluke? Craig Addleman -Original Message- From: Dave Page [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 16, 2003 12:51 PM To: Devang Jadav Cc: [EMAIL PROTECTED] Subject: Re: [pgadmin-support] pgadmin2-1_4_12 CURSOR PROBLEM. IT RETURNS 'Query executed Ok'!!!Why?? It's rumoured that Devang Jadav once said: > Greetings. > > I have a problem. > I am able to execute a cursor from the backend(postgresql on linux) and > see the cursor returns rows. when i try to execute it from pgadmin sql > window, it does not return anyrows and says 'Query executed Ok'. Could > you please tell me what is the problem? pgAdmin II doesn't support cursors. I hope to implement support in pgAdmin III. Regards, Dave. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[pgadmin-support] Erros with pg-Admin
Hello: I tried to connect pgAdmin running on Windows 2000 to Postgres 7.2.3 runnig on another computer with RH8.0 received this error: 2003-02-17 18:46:05 - *** 2003-02-17 18:46:05 - Error(s) 2003-02-17 18:46:05 - *** 2003-02-17 18:46:05 - Error in pgAdmin II:frmConnect.cmdConnect_Click: -2147467259 - Could not connect to the server; Could not connect to remote socket. 2003-02-17 18:46:05 - Windows Version: Windows 2000 v5.0 build 2195 Service Pack 2 2003-02-17 18:46:05 - pgSchema Version: 1.4.12 2003-02-17 18:46:05 - MDAC Version: 2.5 2003-02-17 18:46:05 - cnPostgreSQL.State = adStateClosed I have checked that the client and the server can connect with "ping" and, also, that the server is listening (it was started up with the option "-i"). Thanks in advance -- --- Juan C. Casamayor Dept. Sistemas Informaticos y Computacion Universidad Politecnica de ValenciaTel: ++ 34 6 3877007 (ext. 73594) Camino de Vera s/n Fax: ++ 34 6 3877359 46071 Valencia email: [EMAIL PROTECTED] (SPAIN)www: http://www.dsic.upv.es/~jcarlos ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [pgadmin-support] Erros with pg-Admin
Set tcpip_socket = true in /var/lib/pgsql/data/postgresql.conf an set the necessary host access control in /var/lib/pgsql/data/pg_hba.conf to access your DB from your windows 2000 host I hope it will help Zoltan Sutto > > > > > - Original Message - > From: "Juan C. Casamayor" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, February 17, 2003 7:30 PM > Subject: [pgadmin-support] Erros with pg-Admin > > > > Hello: > > > > I tried to connect pgAdmin running on Windows 2000 to Postgres 7.2.3 > > runnig on another computer with RH8.0 received this error: > > > > 2003-02-17 18:46:05 - > > *** > > 2003-02-17 18:46:05 - Error(s) > > 2003-02-17 18:46:05 - > > *** > > 2003-02-17 18:46:05 - Error in pgAdmin II:frmConnect.cmdConnect_Click: > > -2147467259 - Could not connect to the server; > > Could not connect to remote socket. > > > > 2003-02-17 18:46:05 - Windows Version: Windows 2000 v5.0 build 2195 > > Service Pack 2 > > 2003-02-17 18:46:05 - pgSchema Version: 1.4.12 > > 2003-02-17 18:46:05 - MDAC Version: 2.5 > > 2003-02-17 18:46:05 - cnPostgreSQL.State = adStateClosed > > > >I have checked that the client and the server can connect with "ping" > > and, also, that the server is listening (it was started up with the > > option "-i"). > > > > Thanks in advance > > > > -- > > -- > - > > Juan C. Casamayor > > Dept. Sistemas Informaticos y Computacion > > Universidad Politecnica de ValenciaTel: ++ 34 6 3877007 (ext. 73594) > >Camino de Vera s/n Fax: ++ 34 6 3877359 > > 46071 Valencia email: [EMAIL PROTECTED] > > (SPAIN)www: > http://www.dsic.upv.es/~jcarlos > > > > > > > > ---(end of broadcast)--- > > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-support] Erros with pg-Admin
It's rumoured that Juan C. Casamayor once said: > Hello: > >I tried to connect pgAdmin running on Windows 2000 to Postgres 7.2.3 > > runnig on another computer with RH8.0 received this error: Hi Juan, What do you see if you telnet to the PostgreSQL port on the server from the workstation and hit return a couple of times? e.g. C:\> telnet server.mydomain.com 5432 Regards, Dave. ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
