Stack Overflow
Stack Overflow

Questions tagged [mdac]

32 questions
8
votes
1 answer

ADO.Net change "Persist Security Info" default back to True

Information: We have a 3rd party application we use for production at our company. This program uses a DSN to connect up to our SQL Server 2012 database through ODBC. This application works properly under Server 2003 (MADC 2.8) however when i bring…
Random Developer
  • 1,334
  • 2
  • 12
  • 31
7
votes
3 answers

.Net framework require MDAC installed in server 2008

My company recently using tivoli workload scheduler (TWS) to remote trigger jobs from an z/OS to window server. we have tested the tivoli can trigger the mssql services successfully. The problem now is we have a .NET CL program that we used daily…
Luis Mok
  • 161
  • 3
  • 10
5
votes
2 answers

No data exists for the row/column

While executing the following code in ASP.NET with C#, I am getting an exception like "No data exists for the row/column." OdbcConnection DbConnection = new OdbcConnection(ConfigurationManager.AppSettings["ConnectionStr"]); …
Able Alias
  • 3,824
  • 11
  • 58
  • 87
4
votes
1 answer

VB6 App won't work on Server 2008 after recompile

I'm trying to move web servers. Our app (be kind) was written back in 1998 (I think) in VB6. I've got it working on our new server (Windows Server 2008 R2 64 bit). However, when I take the source code on my machine (Windows 7 64 Bit), and…
Matt Dawdy
  • 19,247
  • 18
  • 66
  • 91
3
votes
3 answers

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…
Eli
  • 1,315
  • 1
  • 16
  • 29
3
votes
1 answer

How do I know which version of MDAC is installed?

How can I find out which version of MDAC is installed on a computer?
Magnus Lindhe
  • 7,157
  • 5
  • 48
  • 60
2
votes
2 answers

ADODB COM object not found

I am using ADODB COM object in my c# application which is developed on Windows 2008 R2 Standard 64bit. Now I have moved application on prod server with Windows 2008 Standard 64bit(not R2) and now I get error below. It seems MDAC 2.8 is not installed…
Tomas
  • 17,551
  • 43
  • 152
  • 257
2
votes
2 answers

Apache/Perl Cannot Find MDAC without CommonProgramFiles(x86)

I am having a problem with using Apache/Perl to get access to Excel files using Microsoft Data Access Component (MDAC). Somehow I must set the "CommonProgramFiles(x86)" system environment variable in order to get this to work. Otherwise, I keep…
Jay C
  • 141
  • 1
  • 12
2
votes
0 answers

MDAC ADODB in Win 2012 R2

I've to deploy classic asp application on windows 2K12 R2 environment. This app also uses COM+ component to connect to sql server using adodb sql driver. As Microsoft has changed MDAC ADODB, creation of object of COM+ is failing. Is there any…
user1480864
  • 1,455
  • 3
  • 16
  • 23
2
votes
2 answers

VB.net Setup Issue

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…
Yogi
  • 233
  • 5
  • 19
2
votes
3 answers

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…
Ptah- Opener of the Mouth
1
vote
3 answers

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…
EightyOne Unite
  • 11,665
  • 14
  • 79
  • 105
1
vote
2 answers

Repackaging Installshield 5.0 installer to MSI and removing dependencies

I have an installation package that installs a mapping program I use for work. As I now have to upgrade to Windows 10, unfortunately the program won't install as some components are no longer valid and it crashes out part way through…
matthew
  • 377
  • 3
  • 5
  • 16
1
vote
0 answers

Why my MDAC 2.7 reference doesn't work on Windows 10?

I have 2 machines, one with Windows 7 64-bit, one with Windows 10 64-bit. Both have Visual Studio 2017 v15.7.5 installed. I have an old application that still uses ADODB (MDAC 2.7). The project compiles and runs perfectly on the Windows 7 machine.…
Cesar Daniel
  • 707
  • 1
  • 9
  • 25
1
vote
5 answers

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?
Chris Morledge
1
2 3