Deploying Jet OleDb Provider

If I'm posting to the wrong forum, please correct me.

I'd like to use an Access database for an application I'm developing for retail sale, and I need to do these things:

Determine during setup if the target machine has the Jet OleDb Provider installed. If so, determine whether the version is adequate. If necessary, install the correct provider.

I don't seem to be able to find any documentation or downloads covering this scenario, however. This seems odd, since I would have imagined the scenario to be rather common.

Has anyone had any successful experience with these issues?

Thanks

Hi,

if you are having a installer package, you can query the registry for the MDAC key which is described and worked for me in many cases here:

http://support.microsoft.com/?kbid=301202

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

That looks good, thanks.

Would you happen to know where I can get a redistributable Jet provider? I'm looking here:

http://msdn.microsoft.com/data/mdac/downloads/

But all of those are user-initiated setups. You're correct—I'm using an installer.

|||Hi there,

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257604

HTH, Jens Suessmeyer.

PS: The one included in VS is only to check the existence of MDAC.

http://www.sqlserver2005.de
|||

Ah, you're the greatest!

|||:-D Nice to hear that. :-D

-Jens.|||

Say, tell me... did you look those articles up specifically for this thread, or did you already have them on hand.

The reason I ask is because of the cumbersome task of sifting through the KB. I know I probably shouldn't, but lately I've pretty much given up on trying to find anything useful there among the myriad of articles that don't apply to the issue I'm looking for.

You must be pretty good at it.

|||Thats something in the middle, for the most cases I ran into the same problems / issues like the posters. Knowing the *right* keywords from my experience its easy to find the right articles on the internet.

-jens.|||

Ah, I see. Makes sense.

Tell me—since clearly you've already fought this battle—do you have your programs install MDAC in order to support Access, or do you instead opt for the OleDb provider?

The reason I ask is, according to my research on the subject, MDAC stopped including it after version 2.5. In fact, the second KB article you referred me to (thanks again) discusses MDAC only, and not OleDb.

That said, have you even been able to find a silent install for the standalone OleDb provider?

Thanks.

Deploying Custom Task to Production Server

This seems like a rather simple questions that I've hesitated posting for a day now, but as of yet I can't really find an answer through my searches online.

My SSIS package is using a couple of the Konesans Transforms, this worked fine on my development box with my dev SQL server. The time has come now to deploy my package to my production SQL server. The instructions on installing the transforms on my dev box all uses Visual Studio to add the components.

Is there a way to deploy 3rd party (own my own) SSIS tasks with the package? Does it require a seperate install? How can I do it without Visual Studio?

Thanks for any help,

-Dan

You don't need Visual Studio to install the custom components. You need to add them to the toolbox in BIDS in order to use them, but that's not teh same as installing them.

All you need to do on your production server is make sure that the DLLs are in the GAC (c:\windows\assembly)

-Jamie

|||

Thanks Jamie. I can do that.

I'm hoping though the future might hold a little more functionality in the "Deployment Utility." I'm also using my own libraries for some script tasks and it'd be nice if the deployment utility recognized the dependancy in visual studio and provides a way for it to be installed into the GAC on deployment.

|||

Nice idea. Request it at the Feedback Centre: http://lab.msdn.microsoft.com/productfeedback/default.aspx

-Jamie

|||

Thanks for the link, it was handy for submitting a bug on my FTP issue.

|||I downloaded Visual Basic studio 2005 Trying to do a project for my class final and it has no toolbox? Please help|||

>I downloaded Visual Basic studio 2005 Trying to do a project for my class final and it has no toolbox? Please help

Sorry, we'll not be able to answe this here. Please repost this in the appropriate Visual Studio forum where I'm sure they will jump on it.

Deploy local SQL Server on internet?

Hello,

Sorry for posting this here, I couldn't find an accurate forum name to post this in.

We are using Windows SBS Server 2003 with SQL Server installed. We have a static IP. I am wondering if we can host our database. I am specifically interested in having outside websites access our database. Is there anything special I need to do to make this happen? I am pretty clueless about this.

Thanks!I dont think this question can be answered here. You could try other database app development related developer forums.|||

Hi Yaron,

IMHO its simple when you have experienced hosting database driven Intranet site, the difference is just to BOUND dedicated IP address in the IIS's Directory. As you have SQL server installed on your SBS now just copy the website files in folder and map those using IIS. map your Static IP to that IIS Directory(where your website file is located)

Open DNS manager, create a forward and reverse lookup zone , create a pointer record, bound your static ip address. Reboot your server and that's it!!!!

If still you find problem hosting it, refer article here

http://www.webmasterstop.com/122.html

http://support.microsoft.com/kb/317604

http://support.microsoft.com/kb/247931

http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsc02.mspx

HTH

Hemantgiri S. Goswami

Deny Anything to sa Account in SQL Express?

No.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:88E5AC42-E241-4365-9D82-5D000664A2F3@.microsoft.com...
> Hello. My client is distributing an application that uses SQL Server 2005
> Express and mixed mode authentication. Most, if not all, of our users
> will
> be installing SQL Server 2005 Express only for our application.
> We want to be able to prevent ANY users (including sa) from being able to
> select, insert, create tables, views, etc. except through the application.
> Is this even possible?
> Thanks,
> JohnHello. My client is distributing an application that uses SQL Server 2005
Express and mixed mode authentication. Most, if not all, of our users will
be installing SQL Server 2005 Express only for our application.
We want to be able to prevent ANY users (including sa) from being able to
select, insert, create tables, views, etc. except through the application.
Is this even possible?
Thanks,
John|||No.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"JohnJohn" <JohnJohn@.discussions.microsoft.com> wrote in message
news:88E5AC42-E241-4365-9D82-5D000664A2F3@.microsoft.com...
> Hello. My client is distributing an application that uses SQL Server 2005
> Express and mixed mode authentication. Most, if not all, of our users
> will
> be installing SQL Server 2005 Express only for our application.
> We want to be able to prevent ANY users (including sa) from being able to
> select, insert, create tables, views, etc. except through the application.
> Is this even possible?
> Thanks,
> John