Questions tagged [mdac]

32 questions
1
vote
2 answers

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…
Tony
  • 68
  • 2
  • 6
1
vote
1 answer

MDAC and ActiveSync for Windows 7 64bit - need help

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
Gold
  • 60,526
  • 100
  • 215
  • 315
1
vote
2 answers

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

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…
Antony Koch
  • 2,043
  • 1
  • 16
  • 23
0
votes
1 answer

IIS return Microsoft Data Access Components error

I have a web .net application, it will read an excel file using the Microsoft Access Database Engine. It works fine , but recently it is giving some error. From the log, these 2 points i think are the highlight, which I still could not find a…
Ryan
  • 51
  • 3
0
votes
2 answers

Problem with MDAC using windows 7

I'm working on an application using c# that needs to connect to a database to get the information of excel file that I have. The problem is that until i did a registry clean, I always get the follow error: System.InvalidOperationException : The…
FrioneL
  • 943
  • 2
  • 13
  • 19
0
votes
0 answers

SSIS error: Connection manager has not been assigned to the Excel

I have an issue trying to import data from Excel file (Source.xlsx) using dtsx package. The system is Windows Server 2019 Standard and there is no MS Office installation on this server, so I installed MDAC 2010 32 bit and added Excel Connection…
0
votes
1 answer

How to Get list of all ODBC or Access DataSources in 64 Bit Machine using C#

My application now supports 64-Bit only and I need to get all the ODBC or Access DataSouces present on the machine or newly created one. Below code was implemented for fetching the List in 32-bit but now it is crashing on calling the SQLAllocEnv…
Bhupesh
  • 35
  • 7
0
votes
1 answer

Is MDAC supported in Sql Server 2011 ("Denali")?

I have been told that next version of SQL Server (2011 - "Denali") won't use MDAC but a "vendor dll" as other RDBMS do. Is this true or MDAC will work anyway? If this is true the zero installation I have for my client application (because MDAC is…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
0
votes
1 answer

MDAC OLEDB Command Prompt 32-Bit Problem

A couple years ago I wrote a C#.NET program that used Microsoft ACE and JET OLEDB to convert Excel spreadsheets to CSV files. Recently we upgraded to a Windows Server 2008 x64 server. Since JET was deprecated that method no longer worked. Originally…
Tony Trozzo
  • 1,231
  • 6
  • 20
  • 34
0
votes
1 answer

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,…
Paul Sasik
  • 79,492
  • 20
  • 149
  • 189
0
votes
1 answer

MDAC Error on Windows XP - Deploy Vb.net

I am trying to deploy a VB.Net application using the built in Click Once. When a User tries to install the application they receive the following error message. https://i.stack.imgur.com/M0ayB.png The machines they are trying to install to are…
Lickrob
  • 61
  • 2
  • 11
0
votes
2 answers

What provider should I choose for my VB6 ADODB connection to SQL Server 2014?

I'm not sure how to interpret this quote from the MSDN documentation. Is the native client deprecated? There will be no more updates to the ODBC driver in SQL Server Native Client. The successor to the ODBC driver in SQL Server Native Client,…
moander
  • 2,080
  • 2
  • 19
  • 13
0
votes
2 answers

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…
grobartn
  • 3,510
  • 11
  • 40
  • 52
0
votes
1 answer

Windows job scheduled through TWS gives MDAC error

I have a job defined for a Windows FTA (TWS term). This job calls a bat script. When thte script is run from the command prompt on the windows box, it runs ok, but when it is scheduled through TWS it comes up with the errors: Application started at…
Mike
  • 1
  • 1
0
votes
5 answers

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…
Tofig Hasanov
  • 3,303
  • 10
  • 51
  • 81