K
K
Kooper_pro2018-02-22 15:28:23
PostgreSQL
Kooper_pro, 2018-02-22 15:28:23

How to make friends 1c and postgres?

Hello, I can't figure it out. How to connect 1c with external database postgresql
1c client version 8.3.11.3034
postgres 9.5.11-1, both 32 bit.
In external data sources I create a new source -> Data - Add a new table - Select from the list - I select PostgreSQL ODBC (UNICODE) from the list of drivers, as a result of which an error falls out.
5a8eb6f31fb20887156219.jpeg
How to fix?
But the test connection to the base
5a8eb74ebb206993273891.jpeg
Which way to drip?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
D
Dmitry Kinash, 2018-03-01
@Dementor

If the problem is working with the connection string constructor, then do not use it - write the string manually (or copy it from another program in which you tested). I connected an external source many years ago, as soon as they appeared, and the only problem I had to face was tied to the specifics of the implementation of ODBC under Linux (not your option).
Also, as an option, you can re-download the driver from the postgres site and reinstall it (perhaps it just somehow became crooked).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question