• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 380
  • Last Modified:

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.
  • 2
3 Solutions
Dave BaldwinFixer of ProblemsCommented:
There are some connection string listed here that you might try:  http://www.connectionstrings.com/postgresql/
Mike LloydEngineer 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/
nussedogAuthor 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:
nussedogAuthor Commented:
"A" for effort
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.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now