Hi all,
I have a strange problem that I have been working around for a while. Today it came to a head because I can't get vs2010 to connect to postgres.
To start with I have found that if I run the odbcadm32 from the windows32 dir I can only see ms sqlserver driver and the ianywhere (sqlanywhere11) driver. None of the other drivers such as Access, dbase, Excel show up. If I run the odbcadm32 from the \windows\SysWOW64 dir then all the drivers show up. Also as a side note, all the drivers seem to work just fine. I have searched the registry and found the same answer. Most of the ODBC drivers show up under the Wow6432Node including the driver for Postgres.
It seems that VS2010 and VS2008 both are looking at the list of drivers in the wind32 hive and they are not there. I can connect to the Postgres server using their data provider using code so I know the drivers are there. Any ideas how to fix this?
Thanks.
here is the code to connect to the Postgres database.
NpgsqlConnection conn = new NpgsqlConnection("Server=localhost;Port=5432;uid=*******;pwd=*******;Database=NorthwindEF;");
conn.Open();
conn.Close();