.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Sandeep Singh
Post New Web Links

ODBC Fails in 64 bit environment - Access MDB

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server

Posting here because I saw other ODBC issues referred here.  Please help a poor scripter...

The short version...  Scripts fail to connect to MDB databases; same scripts that have worked well for a long time on onther systems.

This has been bugging me for a while and I've been working around it; but now I need to fix it..

I think I have narrowed it down to a 32/64 driver issue.

Sypmptom: Error attempting to create connection to Access (MDB) database.

Error message: "Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

Environment: Windows7 64 bit.  Office 2010(64 bit) installed.  Only version of office ever installed on this system.  No other ODBC drivers installed.

Note: Running from the (64 bit) Command Prompt generates the error above.  Running as 32 Bit seems to work.  If I run the script(s) within my editor (VbsEdit, installed as 32 bit app) everything works.  Same problem with many scripts that have run well on 32 bit systems.

ODBC Drivers installed:
Using the ODBC Data Source Administrator from the system's Administrative Tools folder (64 bit version) shows the "Microsoft Access Driver (*.mdb, *.accdb)" as version 14.00.4760.1000.
Running OdbcAd32.exe, from th

View Complete Post

More Related Resource Links

SQL Server doesn't exist or access denied while connecting with Access 2010 ODBC

Hello all. I am using Access 2010 and SQL Server 2008 (locally). I can easily connect to server using SSMS and it works excellent. But when I want to import a table to Access 2010 using ODBC, it says that "SQL Server doesn't exist or access denied". It worked previously - almost 3 days ago, but now, it doesn't! Please help! Thanks Mohammad Javahery

Problem with ODBC from MS Access 2007 to MS Sql Server 2008

Hi experts, I need some help with ODBC Connection Settings from MS Access 2007 to Sql Server 2008. Here is the Scenario, I have created a Database(StagingDB) with 5 tables on SQlServer 2008 and I have  Developed an MS Access 2007 Front End using Linked tables and ODBC to Insert/ Update data into these 5 tables. This is just working fine in my Dev database. ODBC Connection Settings are pointing to my DevServer. All I wanted to do now is, I want to point the ODBC Settings to the same database on my Test Server and then to Production Server. I have Changed the Server name in the ODBC File to point it to my Test Server and If I try to Insert  some data into test server its stil going into the database on Dev server. Is this the right way to do. Please help me with this. thanks In Advance..

Windows 7 RC ODBC Access driver

Many apologies for posting here, but it's the nearset I can find. I am running the Windows 7 RC (x64) and need the MS Access 32-bit ODBC driver in order to connect to an in-house application. The driver doesn't appear to be shipped with Windows 7 and I cannot find anywhere to download it.On further inspection, the 32-bit SQL Server ODBC driver appears not to ship either and I need that as well.

64 bit ODBC driver for Microsoft Access

Hello,I am trying to connect to one of my Access databases (.mdb file on my local) from ODBC connection. The problem is, I am using 64-bit Xp Pro and it does not see any Access driver on 64-bit architecture. Does anybody have 64-bit compatible ODBC driver for Microsoft Access ? Any other help also will be appreciated....

Cannot access a SQL data base since a .net application usin ODBC and/or one by one instructions


At the time when we try to access a database the followin message is showed: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'Mid' is not a recognized function name.

I created an ODBC and when the database connection is tested there is no problem, the problem is when I try to access since the program.

MS Access on windows 7 not connecting to ODBC oracle driver


1.I added oracle driver using odbc admin. This dsn is displaying in MS access windows 7 , but failed in connecting.The following message displayed

ODBC - call failed.

[microsoft)[odbc driver manager] data source name not found and default driver not specified(#0).

2. why the oracle 11g driver is not displayed in create new data source driver's list when exporting from MsAccess on windows 7.


 in advance.



SharePoint 2010 - Crawl Fails - Access is denied


Please help!!  I have recreated the Search Service Application and when I try to do any type of crawl - I get the following error.  I can not figure out where the problem is.  The event logs indicate the same error as well.  I think it should be pretty straight forward.  I have already disabled the loopBackCheck in the registry.

Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled.

Please help!  Thank you.


Image Upload Fails- access denied to folder


i am trying to use a fileopen dialog to select an image and copy it to my project folder .

i have used this code to do that.

OpenFileDialog ofd = new OpenFileDialog();
      ofd.Filter = "All Image Files| *.*";
          imgImagePath.Source=new BitmapImage(new Uri(ofd.FileName,UriKind.RelativeOrAbsolute));
          FileStream fs = new FileStream(ofd.FileName,FileMode.Open,FileAccess.Read);
          FileStream copyfs = new FileStream(@"../../Themes/Images", FileMode.CreateNew, FileAccess.Write);

The Error i am gettin is The so and so folder access is denied.

I have check that the folder is not read only. and its in d:

Any suggestions?


Add Web reference in Visual Studio 2008 fails with Access denied error


i am trying to add a wsdl file to a C# project by using Add Web Reference utility but the tool fails with the error access denied to the path .. is denied. quite not sure where to check the params. any help would be appreciated.

ODBC cannot access


I am currently using SQL Server 2008 R2 (64bit) on Windows 2008 server.  I try to access a Pervasive database as linked server.  I have created the DSN on the odbc control (32 bit).  The odbc itself can access the pervasive database.  However, the connection through SQL sever failed when I create the linked server by odbc option.  I am a newbie on the linked server through odbc.  Could anyone indicate me the steps to create linked server for pervasive database through ODBC? [Pervasive application has been installed on the same server]  Thanks you!

SQLDIAG fails in SQL Server 2008 Cluster environment.


SQLDIAG failing with following errors in SQL Server 2008 cluster environment:

SQLDIAG Error opening Software key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG Failed to open Software\Microsoft\MSSQLServer key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG Failed to open Software\Microsoft\MSSQLServer key . Function result: 2. Message: The system cannot find the file specified.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG Error opening HKLM key . Function result: 53. Message: The network path was not found.
SQLDIAG There are no instances of version 10 on this computer
SQLDIAG . Function result: 87. Message: The p

2008 server Access database connecting win7 workstation with ODBC link works extremely slowly


I have an Access database on a 2008 server (64 bit), and notebooks with 32 bit win7. The program using the mdb is written in delphy, and running on my notebook, and working on data extremely slow. What can be the problem?

The database connector is an ODBC linked network drive.

On that same configured PC with XP it works normally.


Access->ODBC->SQL "untrusted domain" 18452 error


I have a number of client databases written in MS Access connecting via ODBC to SQL 2008. The databases were originally developed on WinXP and Access 2003. They were used successfully when opened on Vista and Windows 7 on machines that are actually on the domain. The problem began when I upgraded my own development machine to Windows 7. I began receiving the now-famous 18452 error -- that I couldn't connect to the database from an untrusted domain.

Because I am a consultant and contractor with numerous clients, attaching to the domain is less-than-preferable. (In some cases, it might even be a violation of security and NDA issues with other clients.) Therefore, I need to be able to continue to develop and use these databases in the manner that I was able to do before.

This is the particulars and what I have tried/determined so far:

  • The SQL server is in mixed mode authentication -- which is why I have been able to do this for 3 years.
  • I can connect to the server (and other servers on the domain) and browse directories, etc. as long as I use a login prompt with my domain ID. This used to be enough to then permit connection to the SQL server. However, in Windows 7, this is no longer the case.
  • I can connect to the SSMS using SQL Authentication.
  • I can connect to the SMSS using Windows Authentication if I use t

Serial port open fails because application and spoolsv.exe both try to access: Is this a .NET bug or

Dear all,
after browsing around I could not find any answer to my issue.

I'm writing a program in C# to access a serial device. The serial device comes with a legacy DLL probably written in C++ that provides an OpenDevice (which I call via DLLImport). The device is connected to a USB port via a Prolific USB to serial converter.
My problem is that 1 out of 5 times, the OpenDevice fails when I run my application. I have workaround to call it until it succeeds and it never goes beyond 3 or 4 tries.
By monitoring the serial port with Portmon I noticed that:
1) when running the application in debug mode from Visual studio the Com port is open from my process (MyApplication.EXE)
2) when running from command line the Com port communication belongs to windows print spooler service (spoolsv.exe) but Portmon also tracks an open command from MyApplication.EXE and here the collision happens: I'm suprised to see that the main communication is managed by spoolsv.exe so it is not just spoolsv.exe running in the background: I'm calling it!
3) the demo software from the supplier uses the same DLL but it is written in C++ and when I run it spoolsv.exe does not show up

Does anybody have an insight on serial port handling in .NET when a legacy DLL and a serial to USB converter are on the path? I would like to connect directly

"Actions / Open With Access" Always Fails with Access 2007.



I am trying to open a List with the Actions / Link with Access functionality.  Every time I try, it simply opens up the MS Access interface as though I had gone through the Start button and selected MS Access.  However, it shows the name of the database, in the right side panel, that was in the "Open with Microsoft Access" dialog box that opens after you select Link with Access.  If you click on the database name, I get an error box saying that the database doesn't exist.

The caveat here is that it used to work.  I have a database that I have been using to run reports and custom queries on a List.  Now, if I click on the Linked Table, I get the error message "You do not have the necessary permissions to use the '[object]' object.  Have your sys admin or the person who created the object establish teh appropriate permissions for you." 

I am the one who created the list and I have admin rights to this area of Sharepoint.

I have also tried to perform the same tasks to another Sharepoint site where I have full Admin rights over the entire site.  Same problem.

The version of Sharepoint is

I also have MS Office 2003, Project and Visio, installed on my PC.

Any ideas or thoughts on what the problem may be?  Our Sharepoint techs and our

MVC architecture in ASP.Net using C# and Microsoft Data Access Application block

The Model-View-Controller (MVC) pattern separates the modeling of the domain, the presentation, and the actions based on user input into three separate classes [Burbeck92]:

Model. The model manages the behavior and data of the application domain, responds to requests for information about its state (usually from the view), and responds to instructions to change state (usually from the controller).

View. The view manages the display of information.

Controller. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.

Store and Display Images from MS Access Database Using C#

There is only the difference of coding syntax to stream the binary data of image content type to upload it into MS Access Database using C#/VB in ASP.Net 2.0

Namespaces required:-
using System.Data.OleDb;

OleDb is used to connect the web site forms with MS Access Database using Microsoft.Jet.OLEDB.4.0
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend