Re: Trouble creating a DSN-file

> -----Original Message-----
> From: Kelvin Varst [mailto:kelvin@xxxxxxxx] 
> Sent: 28 April 2004 07:10
> To: pgsql-odbc@xxxxxxxxxxxxxx
> 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