• Register
0 votes
90 views

Problem :

I am facing following PostgreSQL 9 error

[microsoft][odbc driver manager] data source name not found and no default driver specified

6 5 3
6,930 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

I had faced this error because I had the Data Source Name in User DSN instead of System DSN as shown below:enter image description here

It solved my issue.
9 7 4
38,600 points

Related questions

0 votes
1 answer 117 views
117 views
Problem : I want to open a program for the first time on Windows XP Pro that uses PostgreSQL 9. I am facing an error message that says : A problem was encountered while trying to log into or create the production database. Details: [Microsoft][ODBC Driver Manager] ... = MSDASQL". Changing this entry alters a error message I get to "Provider cannot be found, it may not be properly installed".
asked Jan 17, 2020 jwilliam 3.9k points
0 votes
1 answer 446 views
446 views
Problem : I want to connect to the database made by MS Access using the Java, but I am unable to manage it. I am using the ODBC and I am facing below exception: “java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application”
asked Feb 4, 2020 jwilliam 3.9k points
0 votes
1 answer 21 views
21 views
Problem: microsoft ole db provider for odbc drivers error '80004005'
asked Feb 18 charles mathews 5.5k points
0 votes
1 answer 4 views
4 views
Problem: Hello ... Can anyone tell me that why I got this error? run time error 3146 odbc call failed
asked Mar 26 Ifra 24.4k points
0 votes
1 answer 1 view
1 view
Question: I had this application source and I moved from w7 32 to w7 64. Code is in vb6. It was working well on 32 bit machine, but now get this error. [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed But strange thing is if I compile on 64 ... driver for 64bit but could not download it. Can someone give idea what to do? Odbc source is correct in C:\Windows\SysWOW64\odbcad32.exe
asked 1 day ago munim01 12.9k points
0 votes
1 answer 3 views
3 views
Problem: Please help me . I am stuck. Getting the following error as Microsoft odbc driver manager driver's sqlsetconnectattr failed
asked Apr 8 Sana8989 8.9k points
0 votes
1 answer 2 views
2 views
Problem: As I previously stated in my question, I am having difficulty learning. Could someone help assist me in completing my project?
asked Apr 1 rakib1 51.5k points
0 votes
1 answer 11 views
11 views
Problem: sqlstate[42s02]: base table or view not found: 1146 table.
asked Feb 24 Ethan ross 2.7k points
0 votes
1 answer 7 views
7 views
Problem : sqlstate[42s02]: base table or view not found: 1146
asked Feb 14 Shovo210 14k points
0 votes
1 answer 10 views
10 views asked Feb 21 Akhil k 1.3k points