Odbc Error The Specified Dsn
Contents |
resources Windows Server 2012 resources Programs MSDN subscriptions Overview Benefits Administrators Students Microsoft Imagine Microsoft Student Partners ISV Startups TechRewards Events Community Magazine Forums Blogs Channel 9 Documentation APIs and reference Dev architecture mismatch between the driver and application odbc centers Samples Retired content We’re sorry. The content you requested has been removed.
The Specified Dsn Contains An Architecture Mismatch Mysql
You’ll be auto redirected in 1 second. Microsoft ODBC Driver for SQL Server Microsoft Open Database Connectivity (ODBC) ODBC the specified dsn contains an architecture mismatch between the driver and application oracle Data Source Administrator ODBC Data Source Administrator Managing Data Sources Managing Data Sources Managing Data Sources About Drivers and Data Sources Managing Data Sources Setting Tracing Options Setting ODBC Connection Pooling 32-bit mysql odbc connector Options Viewing Drivers TOC Collapse the table of content Expand the table of content This documentation is archived and is not being maintained. This documentation is archived and is not being maintained. Managing Data Sources After you have installed an ODBC driver from the driver's setup program, you can define one or more data sources for it. The data source name (DSN) should provide
The Specified Dsn Contains An Architecture Mismatch Between The Driver And Application Excel
a unique description of the data; for example, Payroll or Accounts Payable. The user and system data sources that are defined for all currently installed drivers are listed in the User DSN or System DSN tabs of the ODBC Data Source Administrator dialog box. The file data sources in a given directory are listed in the File DSN tab; the directory to be shown is entered in the Look in box in the File DSN tab.Note To manage a data source that connects to a 32-bit driver under 64-bit platform, use c:\windows\sysWOW64\odbcad32.exe. To manage a data source that connects to a 64-bit driver, use c:\windows\system32\odbcad32.exe. In Administrative Tools on a 64-bit Windows 8 operating system, there are icons for both the 32-bit and 64-bit ODBC Data Source Administrator dialog box.If you use the 64-bit odbcad32.exe to configure or remove a DSN that connects to a 32-bit driver, for example, Driver do Microsoft Access (*.mdb), you will receive the following error message: Copy The specified DSN contains an architecture mismatch between the Driver and Application To resolve this error, use the 32-bit odbcad32.exe to configure or remove the DSN
here for a quick overview of the site Help Center Detailed answers the specified dsn contains an architecture mismatch between the driver and application informatica to any questions you might have Meta Discuss the workings 64 bit odbc driver and policies of this site About Us Learn more about Stack Overflow the company Business
Error Im014
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack https://msdn.microsoft.com/en-us/library/ms712362(v=vs.85).aspx Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up The specified DSN contains an architecture mismatch between the Driver and Application. JAVA up vote 47 down vote favorite 18 I'm trying to connect http://stackoverflow.com/questions/8895823/the-specified-dsn-contains-an-architecture-mismatch-between-the-driver-and-appli to a database made by MS Access using Java, but I cannot seem to manage. I am using ODBC and I'm getting this exception: java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application My Java: package javaapplication2; import java.sql.Statement; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; /** * * @author Owner */ public class JavaApplication2 { /** * @param args the command line arguments * */ public static void main(String[] args) { // TODO code application logic here try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String sourceURL = new String("jdbc:odbc:myDatabase"); System.out.println(sourceURL); Connection dbConnection = DriverManager.getConnection(sourceURL,"admin",""); Statement myStmt = dbConnection.createStatement(); String query = "INSERT INTO People(ID, Name, Surname, Age, Contact, Location, Course) VALUES" + " (1007, 'Elroy', 'Smith', '33', 21366688, 'Somewhere', 'somecourse')"; myStmt.executeUpdate(query); ResultSet results = myStmt.executeQuery("SELECT * FROM People"); while(results.next()) { System.out.print(results.getString(1)); System.out.print(results.getString(2)); System.out.print(results.getString(3)); System.out.println(results.getString(4)); } results.close(); } catch(ClassNotFoundException cnfe) { System.out.println(cnfe); } catch(SQLException
Posted October 30, 2012 by Chris Luongo in Windows 7
This will fix a common error trying to add or configure a database http://www.tech-recipes.com/rx/32525/odbc-error-the-specified-dsn-contains-an-architecture-mismatch/ source in Windows 7. When attempting to add a new data source on my Windows 7 64-bit machine, I ran into this frustrating error. I needed to create a data source with a Microsoft Access Driver and experienced the following error: Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed Errors Found: The specified DSN contains an architecture mismatch between the Driver the specified and Application This is due to the fact that Microsoft Access is a 32-bit program with 32-bit drivers which is causing the compatibility issues. Windows 7 64-bit has two different versions of the ODBC Data Source Administrator. The ODBC Data Source Administrator that is reached through the Control Panel is the 64-bit version. What we need to do is the specified dsn use the 32-bit version of the ODBC Data Source Administrator instead. 1 Navigate to c:\Windows\sysWOW64\odbcad32.exe You can use the search feature as there are a lot of files in this folder if needed. 2 Double click to start the executable. You should have no problems adding the 32-bit based driver to your 64-bit machine. About Chris Luongo Chris is a self-taught web designer and developer out of Atlanta, GA. This geek enjoys coffee, cold brews, bike riding, and twisting any form of tech into submission. View more articles by Chris Luongo Share this article If this article helped you, please THANK the author by sharing. Your participation helps us to help others. The Conversation Follow the reactions below and share your own thoughts. rush I don't seem to be getting your newsletter. Randhir Yadav Thanks man. Your post helped. Paul Tried 10 other solutions, but this is the only one that actually worked. Thanks for pointing out the fact that I needed to run oadcad32 from c:\Windows\sysWOW64\odbcad32.exe and not from the c:\Windows\system32\odbcad32.exe. Initially seems counter