RE: Windows setup

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 share it 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 medical researches and the public.
> They have a method (database version in postgreSQL) to access the data directly. The instructions are poor and for an unsupported version.
> 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't seem 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 Windows 7 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 not allowed 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 error such as "no pg_hba.conf entry for host .... was found"? That would suggest your IP is not approved or the username and 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-bit application 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 cause its 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-bit version 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 not with your setup, but something else like a Firewall you have locally or your ip is not allowed or your password is not right.

> If you are really feeling charitable, it would be amazing if you could provide the specific steps for pgadmin4 windows 7 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 me they want help.

Thanks,
Regina