Link to home
Start Free TrialLog in
Avatar of KjartanM-S
KjartanM-SFlag for Norway

asked on

Unable to include oledb32.dll into deployment project

Hi

I'm trying to make a deployment and setup project in order to deploy my application. I'm currently having difficulty in deploying my app.
Firstly when i try to use the wizard for the deployment project it searches for all the dependencies and among those oledb32.dll is included. It lists the following when it detect this dependency:

"The following files may have dependencies that cannot be determined automatically. Please confirm that all the dependencies have been added to the project
c:\program files\common files\system\ole db\oledb32.dll"

How do i check the dependecies of this file for my project manually?

When trying to build the solution with the deploy & setup project included it generates an error when oledb32.dll is included in the project. If i exclude it the solution compiles fine.
It generates the following error when compiling with it included:
"oledb32.dll' should be excluded because its source file 'C:\Program Files\Common Files\System\Ole DB\oledb32.dll' is under Windows System File Protection."

I know that the common files folder is read-only and i have tried to remove this but to no use (it actually turns back to read-only as soon as you click ok on the properties window after de-checking it)

So how do i successfully include oledb32.dll into my deployment project?
Please help - I really need to get my deployment working soon.

Thanks!

KjartanM-S
Avatar of Arthur_Wood
Arthur_Wood
Flag of United States of America image

there are no additional dependencies for oledb32.dll, so you can safely confirm that all (as there are none) have been added.

oledb32.dll SHOULD already be presnet on almost any PC, so you should not need it in your installation package.
Avatar of KjartanM-S

ASKER

Hi

Yes, the oledb32.dll is present in the common files folder on the target folder. I don't know if it matters for my program whether oledb32.dll is there already or the setup installs it (and then resides in the application folder of my app.)? (i assume it doesn't matter)

Do you know if it is coz it is already in the common files folder (on all comps??) that it will not be included in the deployment project (that you are not meant to distribute this)?
Something is wrong with my deployment and i would like to know for sure that oledb32.dll's inclusion or exclusion from the deployment has nothing to do with my app not working on target comp. (it works fine when installed on comp used for development)

KjartanM-S
ASKER CERTIFIED SOLUTION
Avatar of Arthur_Wood
Arthur_Wood
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Actually not sure why it is using oledb32.dll to be honest.

I developed my app in VB.NET and using a SQL Server 2000 database. I think that i have used the ADO.NET way of connecting to the database.....at least i read the book on ADO.NET by MS press and followed this using sqlDataAdapter and sqlConnection in the System.Data.SqlClient namespace and the DataSet

The only thing i used beside this is a call to the DataLink (to make a datalink file for the connection string) form but even that uses a ADODB connection, but i have commented the whole sub out coz i suspected this caused some trouble in the app but the oledb32.dll still is listed in the dependencies.
I also have a few CrystalReports in the project, with the SQL Server provider selected (could it be this that needs oledb32.dll?)

My app runs fine now when "deployed" to the developing comp.
Trying to deploy it on the target comp (with a clean XP pro installation and .NET Frameworks 1.1 installed) it crashes as i try to launch it:
"This program created an exception that could not be handled."
Then it lists the process id and thread id
The JIT debugger is not present - not sure how to include it or how much it would tell me if it was there.
I basically have no clue to what is causing my program to crash like this. I was under the impression that deploying for .NET was pretty much straight forward. The framework should include what was former distributed in the VB runtime package and included in any deployments.

Thanks

KjartanM-S
PS: It can take some time before i am back in the discussion.....bedtime....followed by work

Avatar of Ralf Klatt
Raisor

I read the article and tried to deploy a Hybrid solution, but my app still crashes on the target computer just like before.

KjartanM-S
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi again

Raisor; Looking into that last article of yours and going to experiment with different exception handling.
Correct me if i'm wrong, but isn't simply Exception the "root" of all exceptions in VB.NET? Shouldn't the following catch everything:
try
   'something
catch ex as exception
   'do something
end try

Anyway, a last question if i may. Do any of you know how to get the JIT debugger onto the target comp and whether this will give intelligent info??

Thanks

KMS