• Register
0 votes

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] Data source name not found and no default driver specified

In the ODBC manager, I have a list of User DSN's and System DSN's. I tried installing the postgres odbc driver to see if that would help, but it didn't work for me.

There is the connect.dat file in the program file with a line saying "OLE DB Provider = MSDASQL". Changing this entry alters a error message I get to "Provider cannot be found, it may not be properly installed".

7 5 2
3,870 points

Please log in or register to answer this question.

1 Answer

0 votes

Solution :

Your Problem might be from a driver name for example instead of DRIVER={MySQL ODBC 5.3 Driver} you should try DRIVER={MySQL ODBC 5.3 Unicode Driver} you can see the name of your driver from administration tool.


I faced this with data driven tests using:

Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)

The problem is with above driver it is only is 32 bit. I had switched visual studio testsettings file to 64 bit to test the 64-bit-only application.

So switching back to 32 bit in a testsettings file fixed the issue.

9 7 4
38,600 points

Related questions

0 votes
1 answer 90 views
Problem : I am facing following PostgreSQL 9 error [microsoft][odbc driver manager] data source name not found and no default driver specified
asked Nov 18, 2019 peterlaw 6.9k points
0 votes
1 answer 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 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 21 views
Problem: microsoft ole db provider for odbc drivers error '80004005'
asked Feb 18 charles mathews 5.5k points
0 votes
1 answer 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
Problem : sqlstate[42s02]: base table or view not found: 1146
asked Feb 14 Shovo210 14k 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
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 10 views
10 views asked Feb 21 Akhil k 1.3k points
1 vote
1 answer 878 views
Problem: Hello all, I have started learning python recently. I installed python 3.2 on my Linux machine. I come to know about a function .clear() that clears the value inside a list. I am trying to clear the values of my list but it&rsquo;s not working for my case ... () Traceback (most recent call last): File "<stdin>", line 1, in <module> AttributeError: 'list' object has no attribute 'clear'
asked Apr 5, 2020 Gavin 15.3k points