Skip site navigation (1) Skip section navigation (2)

Re: Trouble creating a DSN-file

From: "Kelvin Varst" <kelvin(at)varst(dot)dk>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Trouble creating a DSN-file
Date: 2004-04-28 17:07:17
Message-ID: NDBBJEKICKIBAAGMLICDOEJKDDAA.kelvin@varst.dk (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)org
[mailto:pgsql-odbc-owner(at)postgresql(dot)org]Pa vegne af Dave Page
Sendt: 28. april 2004 10:04
Til: Kelvin Varst; pgsql-odbc(at)postgresql(dot)org
Emne: Re: [ODBC] Trouble creating a DSN-file




> -----Original Message-----
> From: Kelvin Varst [mailto:kelvin(at)varst(dot)dk]
> Sent: 28 April 2004 07:10
> To: pgsql-odbc(at)postgresql(dot)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



In response to

pgsql-odbc by date

Next:From: Ibrahim El-FayoumiDate: 2004-04-29 07:56:15
Subject: psqlodbc and wide characters under windows and Unix
Previous:From: Dave PageDate: 2004-04-28 08:03:54
Subject: Re: Trouble creating a DSN-file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group