• 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

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 36 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 224 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 jwilliam 3.9k points
1 vote
1 answer 483 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 Gavin 15.3k points
0 votes
1 answer 52 views
Problem : I wanted to install a .NET 472 developer pack on my Windows 10 machine from long time, and when I tried to install it got below error. I was able to install .NET 472 developer pack on my other Win10 machines, and also on my Win7 machine. So I don&rsquo;t ... OSInstallationType = "Client")) OR (VersionNT = v6.3) OR (VersionNT = v10.0 AND OSBuildNumber >= 14393) OR (VersionNT > v10.0))
asked Jan 27 jwilliam 3.9k points
0 votes
1 answer 11 views