Re: Trouble creating a DSN-file - Mailing list pgsql-odbc

From Kelvin Varst
Subject Re: Trouble creating a DSN-file
Date
Msg-id NDBBJEKICKIBAAGMLICDOEJKDDAA.kelvin@varst.dk
Whole thread Raw
In response to Re: Trouble creating a DSN-file  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-odbc
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



pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Trouble creating a DSN-file
Next
From: "Fred Parkinson"
Date:
Subject: Re: Any W2K issues around odbc driver install?