Skip site navigation (1) Skip section navigation (2)

Re: Database Migration Wizard

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Sarah Atkinson" <Sarah(dot)Atkinson(at)lonelyplanet(dot)com(dot)au>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Database Migration Wizard
Date: 2003-03-27 21:41:47
Message-ID: 03AF4E498C591348A42FC93DEA9661B8259E72@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
Hi Sarah,
 
From what I can tell, the error lies with the MySQL ODBC driver. When
connecting to it, it crashes where other drivers on my system work just
fine. If there are other drivers for MySQL you could try one of those,
or, contact the vendors for a fix. I have attached my VB test code in
case it helps.
 
Sorry I cannot be more help.
 
Regards, Dave.

	-----Original Message-----
	From: Sarah Atkinson [mailto:Sarah(dot)Atkinson(at)lonelyplanet(dot)com(dot)au]

	Sent: 26 March 2003 23:20
	To: Dave Page; pgadmin-support(at)postgresql(dot)org
	Subject: RE: [pgadmin-support] Database Migration Wizard
	
	
	 
	Hi Dave,
	 
	Thanks for your email.
	 
	Attached are the various log files.
	 
	Thanks for your help.
	 
	Sarah.
	 

	Sarah Atkinson
	Global Applications Team Leader
	 
	Lonely Planet Publications, Aust.
	Telephone: +61 3 8379 8000
	saraha(at)lonelyplanet(dot)com(dot)au <mailto:saraha(at)lonelyplanet(dot)com(dot)au> 

	 

		-----Original Message-----
		From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk] 
		Sent: Wednesday, 26 March 2003 7:10 PM
		To: Sarah Atkinson; pgadmin-support(at)postgresql(dot)org
		Subject: RE: [pgadmin-support] Database Migration Wizard
		
		
		Hi Sarah,
		 
		The error you are seeing is almost certainly not caused
by that SQL query as that is a standard tried and tested query executed
by the main application to get statistics info. Can you please send me a
complete Full Debug log of the crash occuring? You can change the log
level under Tools -> Options.
		 
		Regards, Dave.

			-----Original Message-----
			From: Sarah Atkinson
[mailto:Sarah(dot)Atkinson(at)lonelyplanet(dot)com(dot)au] 
			Sent: 26 March 2003 03:52
			To: pgadmin-support(at)postgresql(dot)org
			Subject: [pgadmin-support] Database Migration
Wizard
			
			
			 
			Hello,
			 
			I am attempting to migrate a mysql database to
postgres, via the Database Migration Wizard.
			 
			I have setup the DSN on my XP workstation. I am
able to test the datasource and connect successfully.
			 
			However, when following the steps required to
connect to the datasource via the migration wizard (
http://pgadmin.postgresql.org/pgadmin2.php?ContentID=15), pgAdmin is
crashing on me. The logs show the following:
			 
			2003-03-26 14:44:30 - SQL (template1): SELECT
datname, numbackends, xact_commit, xact_rollback, blks_read, blks_hit
FROM pg_stat_database ORDER BY datname
			 
			FYI - I am using the mysql ODBC driver found at 
http://www.mysql.com/downloads/download.php?file=Downloads%2FMyODBC3%2FM
yODBC-3.51.06.exe&pick=mirror
			 
			Any insight would be greatly appreciated.
			 
			Thanks,
			Sarah.
			 

			Sarah Atkinson
			Global Applications Team Leader
			 
			Lonely Planet Publications, Aust.
			Telephone: +61 3 8379 8000
			saraha(at)lonelyplanet(dot)com(dot)au
<mailto:saraha(at)lonelyplanet(dot)com(dot)au> 

			 

			 
______________________________________________________________________
This email, including attachments, is intended only for the addressee
and may be confidential, privileged and subject to copyright.  If you
have received this email in error, please advise the sender and delete
it.  If you are not the intended recipient of this email, you must not
use, copy or disclose its content to anyone.  You must not copy or 
communicate to others content that is confidential or subject to 
copyright, unless you have the consent of the content owner.



Attachment: Form1.frm
Description: application/octet-stream (2.7 KB)

pgadmin-support by date

Next:From: Osvaneo Ap. FerreiraDate: 2003-03-27 23:49:12
Subject: [ Possible problem with Postgres ]
Previous:From: Dave PageDate: 2003-03-27 13:23:10
Subject: WARNING: CVS Server potential downtime

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group