Book a Demo

Author Topic: import data from postgres via odbc  (Read 3042 times)

student_blagger

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
  • heres my fist..kindly run into it
    • View Profile
import data from postgres via odbc
« on: March 20, 2006, 05:42:06 pm »
Hey folks,

I just tried to import my database from postgresl via odbc and it keep locking up...anyone had any probelms with this? i did this in an older version and it worked fine.

Im using postgres 8.0 and have the latest odbc driver.

Any advice appreciated.

Thanks,

Lee
« Last Edit: March 20, 2006, 05:42:34 pm by student_blagger »

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: import data from postgres via odbc
« Reply #1 on: March 21, 2006, 05:11:47 am »
An older version of what? Please provide your version numbers for Postgress, EA (including build number), ODBC driver (version and source), and MDAC.

I don't use Postgress myself, but this information may allow those who do to get a grip on your problem.

BTW, have you checked http://sparxsystems.com.au/resources/corporate/postgresql_instructions.html?
No, you can't have it!

student_blagger

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
  • heres my fist..kindly run into it
    • View Profile
Re: import data from postgres via odbc
« Reply #2 on: March 21, 2006, 08:32:24 am »
HI,

sorry youre right i should have posted more details!

my ea version is: 6.1.788 build 788
postgres version 8.0
odbc driver 8.00.01.03 from pgfoundry
mdac version: 2.8 sp1

any help greatly appreciated guys!

student_blagger

  • EA Novice
  • *
  • Posts: 8
  • Karma: +0/-0
  • heres my fist..kindly run into it
    • View Profile
Re: import data from postgres via odbc
« Reply #3 on: March 21, 2006, 08:47:48 am »
ok..i just reinstalled ea and it now works..no idea why but hey im not complaining

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: import data from postgres via odbc
« Reply #4 on: March 21, 2006, 12:41:26 pm »
Did you install Postgress after your original EA installation?

If so, it might be worth issuing a bug report to Sparx. If not, who knows what the problem was...
No, you can't have it!