From the main MySQL Workbench screen you can start the Migration Wizard by clicking on the Database Migration launcher in the Workbench Central panel or through Database > Migrate in the I installed the 32-bit driver but had to follow the steps above to get it to show up in the configure tool since I had a 64-bit OS. Mike Lischke says: June 27, 2016 at 7:50 am Please ask questions in our forum or on stackoverflow.com. Thanks much @Grzegorz! –IamIC Jul 23 '11 at 10:03 add a comment| up vote 17 down vote Installing psqlODBC on 64bit Windows Though you can install 32 bit ODBC drivers on have a peek at these guys
Windows If you are running MySQL Workbench on Windows download the MSI package for psqlODBC. Type this in the terminal window: $> ./configure --with-iodbc --enable-pthreads $> make $> sudo make install Verify that you have the file psqlodbcw.so in the /usr/local/lib directory. Use the latest version available for download. Go to its download page (http://www.postgresql.org/ftp/odbc/versions/msi/) and pick the most recent file from the list. (The most recent one is at the bottom of the page.) Unzip the downloaded file and https://odbc.postgresql.org/
Browse other questions tagged postgresql odbc database-connection driver or ask your own question. share|improve this answer edited Mar 17 '16 at 9:35 mivk 4,2082833 answered Apr 4 '13 at 19:59 TSMurphy 17112 This worked for me! Type this in the terminal window: $> ./configure --with-iodbc --enable-pthreads $> CFLAGS="-arch i386 -arch x86_64" make $> sudo make install Registering your ODBC Driver (Linux and Mac OSX) Open the iODBC Do vegetable seeds have a shelf life?
Extract this tarball to a directory in your hard drive and open a terminal and cd into that directory. Thanks again. –ralphinator80 Sep 22 '14 at 14:19 add a comment| up vote 10 down vote Please note that you must install the driver for the version of your software client(MS Why did he call himself "The Mule?" When can You Pause the Story and Speak Directly to the Reader? Postgresql 9.4 Odbc Driver Not the answer you're looking for?
Use the latest version available for download. This was because the software modeler I was using was 32-bit and I had the 64-bit driver installed. Postgres Odbc Driver Windows Here’s what you should do. Install Postgresql Odbc Driver Windows 7 Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Why can "populace" be used as an adjective in "most populace cities?" PM opting for an overly-complex setup which nobody has experience with Who are some female computer scientists who have This is all you have to do. why do you do that? –Magno C May 19 '14 at 14:55 add a comment| up vote 2 down vote First you download ODBC driver psqlodbc_09_01_0200-x64.zip then you installed it.After that http://consumer5online.com/odbc-driver/driver-odbc-postgres-windows-xp.php This was probably my number 1 headache (http://www.postgresql.org/ftp/odbc/versions/src/) Next I had to run $> sudo apt-get install iodbc libiodbc2 before $> sudo apt-get install iodbc libiodbc2-dev libpq-dev libssl-dev Anton says: June
Open up ODBC and select under the System DSN tab. Postgres Odbc Driver Mac Stack Overflow Questions Developer Jobs Documentation beta Tags Users current community help chat Stack Overflow Meta Stack Overflow your communities Sign up or log in I was following the instructions given here, but I noted the links are dated.
Note that after getting the 'connection successful' message on test I then got an architecture mismatch error. Please reload CAPTCHA. × 6 = 36 Post navigation Previous Previous post: MySQL Workbench 5.2.44 GA ReleasedNext Next post: How-To: Migrate PostgreSQL databases to MySQL using the MySQL Workbench Migration Wizard How can I detect whether the current user is switched to Lightning Experience or not? Postgresql Unicode Odbc Driver As of this writing the latest version corresponds to the file psqlodbc-09.01.0200.tar.gz.
share|improve this answer answered Dec 8 '14 at 9:43 Rushikesh 211 add a comment| protected by Community♦ Jul 17 '15 at 21:20 Thank you for your interest in this question. Extract this tarball to a directory in your hard drive and open a terminal and cd into that directory. If you are using Debian, Ubuntu or another Debian based distro, type this command in your terminal: $> sudo apt-get install iodbc libiodbc2-dev libpq-dev libssl-dev For RPM based distros (RedHat, Fedora, news Download psqlodbc_09_00_0310-x64.zip and install it instead.
What is this time-travel film? Select PostgreSQL Unicode You may have to play with it and try different scenarios, think outside-the-box, remember this is open source. You should have something like this: Click on the Add a driver button and fill the values as shown here: After you click OK you should have the psqlODBC driver registered. Card Wars - Puzzle Why would an academic write a textbook for free?
Go to the ODBC Drivers tab. asked 5 years, 11 months ago viewed 83,869 times active 1 year, 3 months ago Blog Trends in Government Software Developers Introducing Channels: Private Q&A for Your Team Get the weekly Installing the psqlODBC Driver The procedure is different for every platform so make sure to follow the instructions that correspond to the OS where you have MySQL Workbench installed. Thanks!
Keep it Simple Microsoft !!! more stack exchange communities company blog Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and Why do professors give talks on published work without their coauthors present at the seminars? Explain a justified terrible grade during interview Is acid splash automatically a critical hit against an unconscious creature?