I tried this and it didn't help. All the training stuff is so tied to Sql Server I think I am going to bag other DBs until I understand VS first.
Thank.
>>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();
>>
>>
>>
>
>Have you tried compiling your solution using the /platform:x86 switch to force it to run WoW on 64 bit machines and suck in the driver?
>
>
>1.Open the Properties page for the project.
>2.Click the Build property page.
>3.Modify the Platform target property.
>
>See:
http://msdn.microsoft.com/en-us/library/69t33bf7(v=VS.80).aspx and
http://msdn.microsoft.com/en-us/library/zekwfyz4(VS.80).aspx