OLEDB and Provider=Microsoft.JET.OLEDB.4.0;DataSource....

Posted on 2004-11-15
Last Modified: 2012-06-27

Our customer use this type of connection to connect to an Access DB from a Website


is there a limit to connect to databases with this method, if so: how can we limit this (especially in shared hosting enviroments)?

thanks in advance for your trouble

best regards


Question by:elias12
    LVL 48

    Expert Comment

    what do you wanna limit?
    LVL 9

    Expert Comment

    Yeah, like Mikal613 said, what do you want to limit??
    The computers that can access the db?


    Author Comment

    not the computers the users or better say:

    if a user is creating a connection (and has a ODBC Connection limit from the hosting Software which we use for our shared hosting customers) he shoud not be able to add new connection by this way, i'm not shure if he is able to do that at the moment or not
    LVL 48

    Expert Comment

    probably not
    LVL 69

    Expert Comment

    by:Éric Moreau
    add a password to your database.
    LVL 3

    Accepted Solution

    There are lots of ways to solve your problem.

    Are you limiting from the client side or the server side?

    If from the client side you can load the connection count into a system variable and write your script to check the system variable (in case the user try to load another client server connection in excess of the limit).

    If from the server side it is sorta the same thing except a little trickier for the layman.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Here we come across an interesting topic of coding guidelines while designing automation test scripts. The scope of this article will not be limited to QTP but to an overall extent of using VB Scripting for automation projects. Introduction Now…
    Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now