[pgadmin-support] Migration Wizard failure

2004-04-26 Thread Sitraka Ratsimanohatra
Hi, I'm using PgAdmin II with Migration Wizard ,all version 1.6.0 and I get the following error: Creating table: An error occured at: 22/04/2004 16.12.10: -2147467259: ERROR: Relation '' already exists Does the Migration Wizard cannot perform data-only migrations? help... Thanks, Sitraka

[pgadmin-support] Migration Wizard failure

2004-04-23 Thread Sitraka Ratsimanohatra
Hi, I'm using PgAdmin II with Migration Wizard ,all version 1.6.0 and I get the following error: Creating table: An error occured at: 22/04/2004 16.12.10: -2147467259: ERROR: Relation '' already exists Does the Migration Wizard cannot perform data-only migrations? help... Thanks, Sitraka

Re: [pgadmin-support] Migration Wizard - Access 97 Autonumber

2003-07-16 Thread D Tim Cummings
Thanks Dave, I understand that numeric is a safer option than float8 for Currency fields, but in the type map editor I can't set the precision and scale. If I use numeric without setting precision and scale, Access 97 sees the field as "text" which is definitely not what I want. If I could s

Re: [pgadmin-support] Migration Wizard - Access 97 Autonumber

2003-07-13 Thread Dave Page
Hi Tim, It's rumoured that D Tim Cummings once said: > I am trying to migrate an Access 97 database to PostgreSQL 7.3 using > pgAdmin 1.4.12 and the Migration Wizard 1.4.12. I want to keep using > the Access 97 front end connected to the PostgreSQL backend. > > The default type mapping didn't wor

[pgadmin-support] Migration Wizard - Access 97 Autonumber

2003-07-12 Thread D Tim Cummings
I am trying to migrate an Access 97 database to PostgreSQL 7.3 using pgAdmin 1.4.12 and the Migration Wizard 1.4.12. I want to keep using the Access 97 front end connected to the PostgreSQL backend. The default type mapping didn't work for me but I discovered that mapping Boolean -> int2 (in

Re: [pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-23 Thread Dan Langille
On 23 Jun 2003 at 14:35, Dave Page wrote: > > 23/06/2003 9:04:58 AM - SQL (phorum_conversion): INSERT INTO > > "newforum1_bodies" ("id", "body", "thread") VALUES ('151', > > 'Uh, Internal Server Errors may be triggered by a > > particular browser, but the problem _lies on the server > > itself

Re: [pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-23 Thread Dave Page
> -Original Message- > From: Dan Langille [mailto:[EMAIL PROTECTED] > Sent: 23 June 2003 14:45 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: RE: [pgadmin-support] Migration wizard cannot > connect via ODBC > > > On 23 Jun 2003 at 14:35, Dave Page w

Re: [pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-23 Thread Dave Page
> -Original Message- > From: Dan Langille [mailto:[EMAIL PROTECTED] > Sent: 23 June 2003 15:18 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: RE: [pgadmin-support] Migration wizard cannot > connect via ODBC > > > > Are you saying that databases

Re: [pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-23 Thread Dan Langille
On 23 Jun 2003 at 15:00, Dave Page wrote: > > On 23 Jun 2003 at 14:35, Dave Page wrote: > > > > > > 23/06/2003 9:04:58 AM - SQL (phorum_conversion): INSERT INTO > > > > "newforum1_bodies" ("id", "body", "thread") VALUES ('151', > > > > 'Uh, Internal Server Errors may be triggered by a > > > > p

Re: [pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-23 Thread Dan Langille
On 23 Jun 2003 at 8:56, Dave Page wrote: > > For what it's worth, the migration gets this error: > > > > Creating table: newforum1_bodies > > Copying data... > > > > An error occured at: 22/06/2003 5:11:40 PM: > > -2147467259: ERROR: parser: unterminated quoted string at or near > > "'tr -d

Re: [pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-23 Thread Dave Page
> -Original Message- > From: Dan Langille [mailto:[EMAIL PROTECTED] > Sent: 22 June 2003 22:19 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: RE: [pgadmin-support] Migration wizard cannot > connect via ODBC > > > On 22 Jun 2003 at 21:33, Dave Page

Re: [pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-22 Thread Dan Langille
On 22 Jun 2003 at 21:33, Dave Page wrote: > > Thanks. http://pgadmin.postgresql.org/ seems to be down just now... > > Looks OK from here. And now from here. > From > http://archives.postgresql.org/pgadmin-support/2003-03/msg00068.php: > > FYI - If you have anyone else reporting this issue,

Re: [pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-22 Thread Dave Page
> -Original Message- > From: Dan Langille [mailto:[EMAIL PROTECTED] > Sent: 22 June 2003 17:51 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Migration wizard cannot > connect via ODBC > > > Thanks. http://pgadmin.postgresql.

Re: [pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-22 Thread Dan Langille
On 22 Jun 2003 at 16:51, Dave Page wrote: > It's rumoured that Dan Langille once said: > > > > It it then that I get the lovely Windows message "pgAdmin II has > > encountered a problem and needs to close. We are sorry for > > inconvenience." > > > > > Any ideas? Thanks. > > Yes, there is a bu

Re: [pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-22 Thread Dave Page
It's rumoured that Dan Langille once said: > > It it then that I get the lovely Windows message "pgAdmin II has > encountered a problem and needs to close. We are sorry for > inconvenience." > > Any ideas? Thanks. Yes, there is a bug in the MySQL driver. One of the older ones works fine, but I

[pgadmin-support] Migration wizard cannot connect via ODBC

2003-06-22 Thread Dan Langille
I'm trying to copy the data in a MySQL database over to a PostgreSQL database. I'm running: - mysql 3.23.57-nt under Windows XP - PostgreSQL 7.3.3 under FreeBSD 4.8 - pgAdmin II 1.4.12 Here are my steps: 1 - Connect to my pg db 2 - Select menu item Plugins -> Database Migration Wizard 3 - clic

Re: [pgadmin-support] Migration Wizard doesn't appear

2003-06-19 Thread Dan Langille
On 19 Jun 2003 at 20:34, Dave Page wrote: > You must connect to the server otherwise you will only see plugins that > don't require a connection to work. DOH! That part is mentioned at http://pgadmin.postgresql.org/pgadmin2.php?ContentID=15 but I missed the very important point which is at the

Re: [pgadmin-support] Migration Wizard doesn't appear

2003-06-19 Thread Dave Page
> -Original Message- > From: Dan Langille [mailto:[EMAIL PROTECTED] > Sent: 19 June 2003 18:36 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Migration Wizard doesn't appear > > > Hi, > > I'm using pgAdmin II v 1.4.12 under Windows NT.

[pgadmin-support] Migration Wizard doesn't appear

2003-06-19 Thread Dan Langille
Hi, I'm using pgAdmin II v 1.4.12 under Windows NT. I've downloaded pgMigration v1.4.12 (after initally trying pgMigration v1.5.60), installed it to H:\Program Files\pgAdmin2\Plugins (which is where pgAdmin is installed). I've run regsvr32 "H:\Program Files\pgAdmin2\Plugins\pgMigration.dll"

Re: [pgadmin-support] Migration Wizard problem

2003-03-28 Thread Dave Page
Sent: 28 March 2003 03:30 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Migration Wizard problem > > > Hi > > I have a problem with a database brought in from an MS Access > database through the "Database Migration Wizard". > > I have

[pgadmin-support] Migration Wizard problem

2003-03-27 Thread Mark Levene
Hi I have a problem with a database brought in from an MS Access database through the "Database Migration Wizard". I have a table ("tblPurchaseOrderDetails") which has a field ("PurchaseOrderDetailID"). In Access this is an "Autonumber" field. The "default" value generated for "PurchaseOrderDeta

[pgadmin-support] Migration Wizard 1.4.12 failure

2003-02-28 Thread Ferdinando Licheri
Hi, I’m using pdAdmin II with Migration Wizard, all version 1.4.12. When I try to migrate a MS Access table in to a schema of a postgres database  I get the following error dialog:   -- Creating table:   An error occured at: 28/02/2003 18.12.31: -2147467259: ERROR:  Relation '' alr

Re: [pgadmin-support] Migration Wizard error type mismatch

2003-02-17 Thread Dave Page
2: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

[pgadmin-support] Migration Wizard error type mismatch

2003-02-17 Thread Silje Ausen
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. T

Re: [pgadmin-support] migration wizard

2002-09-19 Thread Dave Page
IL PROTECTED] > Subject: [pgadmin-support] migration wizard > > > Error when migrate mdb with numbers like columns names > > 2002-09-19 12:28:55 - SQL (ayuntamientos): CREATE TABLE > estadisticaeconomica2001 ( clave varchar(255), 1 float8, 2 > float8, 3 float8, 4 float8, 5 flo

[pgadmin-support] migration wizard

2002-09-19 Thread Lrat
Error when migrate mdb with numbers like columns names 2002-09-19 12:28:55 - SQL (ayuntamientos): CREATE TABLE estadisticaeconomica2001 ( clave varchar(255), 1 float8, 2 float8, 3 float8, 4 float8, 5 float8, 6 float8, 7 float8, 8 float8, 9 float8, 10 float8, 11 float8, 12 float8, 13 float8, 14

Re: [pgadmin-support] Migration Wizard Error: Library not registe

2002-05-30 Thread Whiteley, Kenneth M.
To: Whiteley, Kenneth M.; [EMAIL PROTECTED] >Subject: RE: [pgadmin-support] Migration Wizard Error: Library not >registered > > >> -Original Message- >> From: Whiteley, Kenneth M. [mailto:[EMAIL PROTECTED]] >> Sent: 30 May 2002 15:29 >> To: [EMAIL PROTECTED

Re: [pgadmin-support] Migration Wizard Error: Library not registered

2002-05-30 Thread Dave Page
> -Original Message- > From: Whiteley, Kenneth M. [mailto:[EMAIL PROTECTED]] > Sent: 30 May 2002 15:29 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Migration Wizard Error: Library > not registered > > > I am trying to migrate an Access databas

[pgadmin-support] Migration Wizard Error: Library not registered

2002-05-30 Thread Whiteley, Kenneth M.
I am trying to migrate an Access database to PostgreSQL (behind our firewall) using the Database Migration Wizard. I select "Access" as the Database Type and enter the local path in the ".mdb File". After clicking on "Next", I get the following message (lifted from the "pgAdmin II_xxx.log" file)