Create odbc driver for access

If you provide a DSN, this information isn't visible. If you only have a bit driver, or have to use a bit driver, search for or browse to ODBC Data Sources bit instead. Launch the applet. Here's what the applet looks like. Check the name, then go back to the wizard and enter it in the Dsn field on the Choose a Data Source or Choose a Destination page. Skip the rest of this page and continue to the next step of the wizard. This example creates a new System DSN.

In the Create a New Data Source dialog box, select the driver for your data source, then click Finish. The driver now displays one or more driver-specific screens where you enter the info needed to connect to your data source. For the SQL Server driver, for example, there are four pages of custom settings.

After you finish, the new system DSN appears in the list. Continue to the next step of the wizard. If you want to provide your connection information with a connection string, the rest of this topic helps you get the connection string you need.

This example is going to use the following connection string, which connects to Microsoft SQL Server. After you enter the connection string, the wizard parses the string and displays the individual properties and their values in the list. The connection options for an ODBC driver are the same whether you're configuring your source or your destination.

That is, the options you see are the same on both the Choose a Data Source and the Choose a Destination pages of the wizard. This third-party site contains sample connection strings and more info about data providers and the connection info they require. This requires several steps, but helps to make sure you have a valid connection string. The procedure steps might vary depending on the specific database products and ODBC drivers used. About ODBC data sources. Add an ODBC data source. A data source is a source of data combined with the connection information that is required to access that data.

Examples of connection information include server location, database name, logon ID, password, and various ODBC driver options that describe how to connect to the data source. This information can be obtained from the administrator of the database to which you want to connect. Machine data sources store connection information in the Windows Registry on a specific computer. You can use machine data sources only on the computer they are defined on.

There are two types of machine data sources — user and system. User data sources can be used only by the current user and are visible only to that user. System data sources can be used by all users on a computer and are visible to all users on the computer and system-wide services.

A machine data source is especially useful when you want to provide added security, because only users who are logged on can view a machine data source and it cannot be copied by a remote user to another computer.

File data sources also called DSN files store connection information in a text file, not the Windows registry, and are generally more flexible to use than machine data sources. For example you can copy a file data source to any computer that has the correct ODBC driver so that your application can rely on consistent and accurate connection information to all the computers it uses.

Or you can place the file data source on a single server, share it between many computers on the network, and easily maintain the connection information in one location. A file data source can also be unshareable. Dear PlectoBne, I downloaded the both versions available on the link given by you When I tried to install the 64 bit version, It gave error saying that the Office version you have is 32 bit, so install 32 bit version When I tried to install the 32 bit version, the problem persisted as it was before installing the drivers If someone could help me to enable desabilite 32bit and that the bit on a server x I found a link on the web before which you just typed into your run command and then it opened up the appropriate window to add MA Access ODBC for 64 bit.

I will have a look on the Internet sea at I can find this again. Microsoft Developer Network. Sign in. United States English. Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Ask your questions here! Sign in to vote. Hello, I am trying to connect to one of my Access databases.

The problem is, I am using bit Xp Pro and it does not see any Access driver on bit architecture. Any other help also will be appreciated Saturday, August 5, AM. There is not one available. You need to compile your application for the x86 processor to force it to use the 32 bit driver. Ken is correct - I ran into the same problem. And, compiling against x86 fixed the problem. Monday, August 7, PM. Monday, August 28, PM. Tuesday, August 29, AM. Friday, November 10, PM.

Hi To continue the theme. Monday, November 20, PM. Hi there! Brgds, Sergej. Friday, March 28, PM.