Обсуждение: ODBC Problem

Hello,

I'm a VFP - PostgreSQL Developer and I have the following problem when I
try to connect to my PostgreSQL Database:

ODBC Driver Version: psqlODBC_x64_8.3.4.0
PostgreSQL Version: 9.0.1-1
OS: Windows 7 Home Premium

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;"

That's pratically it, please help me out with this, I'm stucked wiht my
project.


Thanks in advance.



Marco Murillo.

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.