mdac

Automation Error when using ADO/MDAC

OK, struggling to get a definitive answer to this one... I have an application written in VB6 which requires MDAC (2.8 for this installation). MDAC is included in the installer for my application. When the software is removed and re-installed on the same machine MDAC seems to go awry and I receive the following error as soon as my appli...

How to re-install MDAC on SQL server 2008?

I am having problems when connecting to my SQL server 2008 and think it might be a problem related to MDAC. Is there a download to re-install these? ...

SQL through classic ADO - Undefined Function 'Round' ?

I'm working on a legacy product and i have some SQL being executed through ADO, to an Access database with linked tables to SQL Server. I'm getting the error 'Undefined function 'Round' when i execute the SQL but if i take the query and run directly in Access it works fine. I know that EVERYTHING is correct and that this is a machine s...

How do I know if my program needs MDAC?

I have a set of Windows programs that is mostly created with VB6 and VC++ 6. Its installer is created using InstallShield. A couple users have recently reported a problem trying to install it on Vista. It is complaining that "MDAC 2.6 Sp2 cannot be installed on this machine. MDAC 2.6 Sp2 requires any one of the following configuratio...

Microsoft Access - The 'Miccrosoft.Jet.OLEDB.4.0' provider is not registered on the local machine

I get the following error: The 'Miccrosoft.Jet.OLEDB.4.0' provider is not registered on the local machine When I run this code: string dbConn = @"Provider=Miccrosoft.Jet.OLEDB.4.0;Data Source=C:\structuredfunds.mdb"; string cmdText = "select * from StructuredFundPosition"; DataTable dt = new DataTable(); using (OleDbDataAdapter da = n...

OleDbConnection.Open() throws a "No error message available" error before even contacting the SQL Server

Hi all Using a connection string of "Provider=SQLOLEDB;Data Source=localhost;User ID=foo;password=bar;Database=CodeLists;Pooling=true;Min Pool Size=20;Max Pool Size=30;" I get the following stack trace System.Data.OleDb.OleDbException: No error message available, result code: -2147024770(0x8007007E). at System.Data.OleDb.O...

How do I know which version of MDAC is installed?

How can I find out which version of MDAC is stalled on a computer? ...

Problems opening Access Database from Delphi 7

I am developing Delphi 7 application, which is operating with Access Database (MDB format). It works fine on my PC, and some other PCs as well. But on some machines application gives error when trying to access database sometimes, saying something like "Unkown database format (mdb)". Additionally I noticed one thing: When you open that d...

MDAC Componeted issue in VB.Net application

Hi, I have a VB.net application which is using the MS-Access database. I created setup for this application to deploy it on to the other machine. When I connect it to the database it is showing the following error message: "The .Net Framework Data Provider require Microsoft Data Access Components(MDAC). Please install Microsoft Data Acce...

VB.net Setup Issue

Hi, While creating the setup for VB.net application I am getting the following warning: "Warning 1 'msado15.dll' should be excluded because its source file 'C:\Program Files\Common Files\System\ado\msado15.dll" is under Windows System File Protection. Please suggest me how to over come this type of issue. Thanks, ...

How do I use an ADO.NET managed provider in Excel?

I have an ADO.NET Managed Data Provider that is registered in machine.config in DbProviderFactory - It is available for use from, say, Analysis Services, so I know it is correctly registered. However, I need to be able to query the managed provider from Excel, but the managed provider doesn't appear as a choice from Data Link Properties...

MDAC and ActiveSync for Windows 7 64bit - need help

hi i try to install my C# program on Windows 7 64bit and i got error. i need to install MDAC and ActiveSync on computer. from where i can download MDAC (that fit for Win-7 64 bit) and ActiveSync ? thank's in advance ...

Problem wit MDAC when trying to compile in VS2008 using x64 bit target platform

I am trying to compile an 32 bit application. I am aware of problems with it but that is why its being compiled on 64 bit version. I am hanging at this problem. Application uses lots of sql stuff. In sqltypes.h file: (provided by MDAC) #ifdef _WIN64 typedef INT64 SQLLEN; typedef UINT64 SQLULEN; typedef UINT64 SQLSETP...

Comparing DLL sets from the same app on two different machines

Is there a good way to compare the DLLs loaded between two machines running the same app. (And to replicate the process between N other machines, two at a time?) Background: I am trying to track down a configuration/setup issue. It's the age-old, DLL-hell-type problem where an app will run on one machine but not on another. I have elim...