Thread: Trouble creating a DSN-file

Trouble creating a DSN-file

From
"Kelvin Varst"
Date:
Hi,

I'm having trouble creating a DSN-file in the ODBC manager in windows. I
have installed psqlodbc-07_02_0005 on my Windows, and when I add a DSN and
choose a Postgres driver, the detailed dialog asks for Database, Server,
User, Password and so on. When I fill in the data, and try to save, nothing
is saved to the actual file, other than the DRIVER-parameter. I need the
DSN-file for another program. What am I doing wrong?

Kelvin :-)



Re: Trouble creating a DSN-file

From
"Dave Page"
Date:

> -----Original Message-----
> From: Kelvin Varst [mailto:kelvin@varst.dk]
> Sent: 28 April 2004 07:10
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Trouble creating a DSN-file
>
> Hi,
>
> I'm having trouble creating a DSN-file in the ODBC manager in
> windows. I have installed psqlodbc-07_02_0005 on my Windows,
> and when I add a DSN and choose a Postgres driver, the
> detailed dialog asks for Database, Server, User, Password and
> so on. When I fill in the data, and try to save, nothing is
> saved to the actual file, other than the DRIVER-parameter. I
> need the DSN-file for another program. What am I doing wrong?

Hi Kelvin,

I can confirm that creating file DSNs doesn't seem to work at the moment
- however you should still be able to use them if you manually create
one. For example:

[ODBC]
DRIVER=PostgreSQL
Database=DatabaseName
Server=ServerName
Port=5432
UID=Username
PWD=Password

Regards, Dave

Re: Trouble creating a DSN-file

From
"Kelvin Varst"
Date:
Hi,

Is there a way to test the DSN-file when created? Just to verify the file is
working.

Is it possible to use an IP-adress as ServerName?

Kelvin :-)

-----Oprindelig meddelelse-----
Fra: pgsql-odbc-owner@postgresql.org
[mailto:pgsql-odbc-owner@postgresql.org]Pa vegne af Dave Page
Sendt: 28. april 2004 10:04
Til: Kelvin Varst; pgsql-odbc@postgresql.org
Emne: Re: [ODBC] Trouble creating a DSN-file




> -----Original Message-----
> From: Kelvin Varst [mailto:kelvin@varst.dk]
> Sent: 28 April 2004 07:10
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Trouble creating a DSN-file
>
> Hi,
>
> I'm having trouble creating a DSN-file in the ODBC manager in
> windows. I have installed psqlodbc-07_02_0005 on my Windows,
> and when I add a DSN and choose a Postgres driver, the
> detailed dialog asks for Database, Server, User, Password and
> so on. When I fill in the data, and try to save, nothing is
> saved to the actual file, other than the DRIVER-parameter. I
> need the DSN-file for another program. What am I doing wrong?

Hi Kelvin,

I can confirm that creating file DSNs doesn't seem to work at the moment
- however you should still be able to use them if you manually create
one. For example:

[ODBC]
DRIVER=PostgreSQL
Database=DatabaseName
Server=ServerName
Port=5432
UID=Username
PWD=Password

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match