RE: Windows setup - Mailing list pgsql-odbc
From | Regina Obe |
---|---|
Subject | RE: Windows setup |
Date | |
Msg-id | 000201d448b8$8e41b440$aac51cc0$@pcorp.us Whole thread Raw |
In response to | Windows setup (Tom Lahey <tomlaheyh@gmail.com>) |
List | pgsql-odbc |
Tom, > I'm sorry to bother your for a simple question, but I think it will help a lot of people and I will do my best to shareit with Medical school librarians and others who will find it very useful. > ClinicalTrials.gov is the repository where the US stores information on clinical trials. It's a great resource for medicalresearches and the public. > They have a method (database version in postgreSQL) to access the data directly. The instructions are poor and for an unsupportedversion. > https://aact.ctti-clinicaltrials.org/pgadmin > I got this to work on my windows 7 computer but it took a while and I have no idea how I finally got it to work on pgadmin4. > I am now struggling to setup the postgresql ODBC driver (64 bit) on my windows 10 system. I can see the drivers but I can'tseem to get a new connection working. I also could not get pgadmin to work, but the driver will be better anyway. Connecting on windows 7 vs. windows 10 using pgAdmin4 should be no different. I've successfully connected on both Windows7 and Windows 10 with no issue. The process is much the same as it is in pgAdmin3 I got as far with the link you provided to get an error message that I don't have the right credentials and my IP is notallowed from the postgres server. Could you be more specific about the error you get in pgAdmin4? Were you able to install pgAdmin4 at all? Was it an errorsuch as "no pg_hba.conf entry for host .... was found"? That would suggest your IP is not approved or the usernameand password you are using is wrong. > If at all possible could you send the specific steps to setup a ODBC driver on windows 10 that connects to the data source(settings on the link above). It would be greatly appreciated! Regarding the ODBC driver, first you need to determine if you need the 64-bit or 32-bit driver. If you are using a 32-bitapplication to connect e.g. MS Access Office 32-bit version, then you need the 32-bit driver (not the 64-bit) even if you are on a 64-bit OS. General steps for ODBC is to launch the ODBC Manager 1) C:\Windows\System32\ odbcad32.exe (this is the 64-bit version if you are on a 64-bit Windows - confusing I know causeits got 32 all over it) - this one is generally accessible from the control panel. The 32-bit version would be C:\Windows\SysWOW64\odbcad32.exe (confusing cause it has a 64 on it, trust me it's the 32-bitversion and generally not accessible via the control panel) Click on whichever is relevant (if you are using the 32-bit make sure you installed the 32-bit PostgreSQL odbc driver 2) Add a new System or User DSN and pick PostgreSQL Unicode. 3) You can set the data source name to anything you want, and fill in the other info (same information as you filled in pgAdmin4)and click the Test button. If you can connect you are set. If you can't connect or get a similar error as I mentioned before, then your issue is notwith your setup, but something else like a Firewall you have locally or your ip is not allowed or your password is notright. > If you are really feeling charitable, it would be amazing if you could provide the specific steps for pgadmin4 windows7 and windows 10 as well as the ODBC driver link to the database for Windows 7 and Windows 10. Sure I'd be willing to help, but don't want to send unsolicited help if it's not going to be used. It's not clear to methey want help. Thanks, Regina
pgsql-odbc by date: