![]() ![]() If you are looking for 64-bit Windows driver download the driver. Magnus Hagander, a Postgresql developer, elaborates on this: 'All users connecting from the local machine, your domain, or a trusted domain will be automatically authenticated using the SSPI. I would rather not have to make the users install the whole database software, just to be able to connect (remotely) through Access. Microsoft Windows Download at least the ODBC 8.4 driver from the PostgreSQL download site. Is there any way to fetch the postgres ODBC driver that was installed in a linux server and currently configured to be used as a default To give some context, One of processes (that returns the driver information) is giving us a different version from the one that should be installed. Is the Postgresql server running on Windows as well as the clients then you might test with this to see if this works: host all all 0.0.0.0/0 sspi. If I only install the odbc-drivers, I cannot create or use a file based connection, only machine based connections. PostgreSQL is available for download as ready-to-use packages or installers for various platforms, as well as a source code archive if you want to build it yourself. I can set up a file based connection if I install the official driver (the 32-bit works for me), and IF I have the PostgreSQL database software installed as well. will do a silent install without displaying any user interface. It's easier than using the EnterpriseDB installer to install just psqlODBC. My idea was to create an Access database with linked tables to the PostgreSQL database, and to use a file based dsn connection so that the users don't have to set up their own machine connections. Use the stand-alone MSI installers from the psqlodbc download directory rather than trying to do the install yourself. ![]() We will use it as a simple interface for updating data. I'm looking for the simplest way for Access users to connect to a PostgreSQL database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |