Обсуждение: 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
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

Tom Lahey wrote:
> The instructions are poor and for an unsupported version.
>
> https://aact.ctti-clinicaltrials.org/pgadmin

The three links to pgAdmin are broken, and should be replaced (there is
now the additional "pgadmin" directory in the path):

https://www.postgresql.org/ftp/pgadmin/pgadmin3/
https://www.postgresql.org/ftp/pgadmin/pgadmin3/v1.22.2/win32/
https://www.postgresql.org/ftp/pgadmin/pgadmin3/v1.22.2/osx/

Postgres 9.6 and pgAdmin 3 are no longer the current versions, but they
still work fine.

> I am now struggling to setup the postgresql ODBC driver

The pgAdmin tool does not need the ODBC driver.

It is possible that other query tools require ODBC, but as long as those
other tools are not mentioned on the AACT web page, the ODBC driver
should not be mentioned there either.


Regards,
Clemens