Re: ODBC Problem

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: ODBC Problem
Дата
Msg-id E2A4A919-D989-4C5A-B962-B416DE047689@gmail.com
обсуждение исходный текст
Ответ на ODBC Problem  (murillomarco@sigmahn.com)
Список pgsql-odbc
Дерево обсуждения




On Oct 22, 2010, at 5:48 PM, murillomarco@sigmahn.com wrote:

The error reads something like this:
Error Message:1526
Connectivity Error:[Microsoft][Controller Administrator ODBC]
Data Source name not found and no predetermined controller was specified.

The string I'm sending to the server contains:
"DRIVER={PostgreSQL
ANSI};SERVER=localhost;port=5432:DATABASE=cabletv;UID=cabletvusr;PWD=pcabletvsuperg;"

I'm going to give my best guess.  There were times when I upgraded the odbc driver where the driver name changes between versions.  Applications like ms-access and excel will store odbc connection properties in the registry.  Since the driver names changed, all of existing data sources connections would fail with an error message very similar to the one your getting.

By driver name I mean: DRIVER={PostgreSQL ANSI};

To fix the problem, I needed to find the affected pre-existing registry entries to update the driver name to match the name of the newly installed driver.

On a side note, why do you use the ANSI driver instead of the Unicode driver?

Sent from my iPod

В списке pgsql-odbc по дате отправления: