Connecting to PostgreSQL Linux Implementation from Visual Studio 2008

What is the best method to connect from Visual Studio (and SSRS) to linux. I have tried DSN but keep seeing this message "The specified DSN contains an architecture mismatch between the Driver and Application".

Have also tried using connection string but no luck.

Please provide guides as to best method to use and complete syntax of connection string if required.

My Windows SQL and Visual Studio box is Windows 2008 Server.
nussedogAsked:
Who is Participating?
 
nussedogConnect With a Mentor Author Commented:
Thanks everyone.
I had already visited both the sites referenced above.

Turns out the actual issue was the configuration of the ODBC driver. There are two ODBC configuration tools provided by Microsoft. The default tool is the 32bit version and will install only 32 ODBC driver. I had to manually run the 64bit configuration tool  so that the correct 64bit ODBC driver would be installed.

The ODBC.ini file was correctly modified and lines 5 & 6 added after executing %windir%\syswow64\odbcad32.exe.
001 [ODBC 32 bit Data Sources]
002 PeopleNet=PostgreSQL ANSI(x64) (32 bit)
003 PeopleNet64=PostgreSQL Unicode (32 bit)
004 [PeopleNet]
005 Driver32=C:\Program Files\psqlODBC\0903\bin\psqlodbc30a.dll
006 [PeopleNet64]
007 Driver32=C:\Program Files (x86)\psqlODBC\0903\bin\psqlodbc35w.dll

I found a complete explanation of this 'oddity' at the link below:
http://www.easysoft.com/developer/interfaces/odbc/64-bit.html#odbc-windows
0
 
Dave BaldwinConnect With a Mentor Fixer of ProblemsCommented:
There are some connection string listed here that you might try:  http://www.connectionstrings.com/postgresql/
0
 
Mike LloydConnect With a Mentor Engineer II - Automation and DevOpsCommented:
It sounds like you have the wrong ODBC drivers. Try the PostgreSQL drivers, located here: http://www.postgresql.org/ftp/odbc/versions/msi/
0
 
nussedogAuthor Commented:
"A" for effort
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.