ODBC question

Discussion in 'H-Sphere Shared Hosting' started by marioletto, Nov 14, 2004.

  1. marioletto

    marioletto Guppy

    the following code

    =============
    <%
    Set Conn = Server.CreateObject("ADODB.Connection")
    Conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=D:\hshome\xxx\db\xxxx.mdb;"
    Conn.Close
    %>
    =============

    returns the follwoing error message:

    ===========
    Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
    [Microsoft][ODBC Microsoft Access Driver] Too many client tasks.
    file.asp, line 3
    ==========

    am i missing something?
    please advise...
    thanks
  2. Da Man

    Da Man Guppy

    no its a server error im getting the same message
  3. marioletto

    marioletto Guppy

    support told is because i have not created any dsn for the database.
    common sense tells me that i don't need a dsn for a dsnLes connection... or i'm i missing something?

    btw, are you on win7 as well?
  4. Da Man

    Da Man Guppy

    are you on win7??
  5. Da Man

    Da Man Guppy

    same here
  6. Da Man

    Da Man Guppy

    I have a DSN set up and im looking at it right now... it was working yesterday... and "I" did not change anything!!!!
  7. marioletto

    marioletto Guppy

    Re: ODBC question - please flush the toilet!

    someone on the server is not closing their connections and we are left with error messages... is like sharing your apt with somene who won't flush the toilet. it sucks!
  8. LegalAlien

    LegalAlien Perch

    Re: ODBC question - please flush the toilet!

    :D sorry - I had to laugh at that!!
  9. Yash

    Yash Bass

    This issue is caused by the Access ODBC driver. it the the most unreliable driver you can use on a shared hosting environement

    Although we fixed it, we cannot guarantee this error will not occur again. Please use Jet OLEDB instead as it has better connection pooling and handling. microsoft strong discourages using Microsoft Access ODBC driver as well
  10. marioletto

    marioletto Guppy

  11. marioletto

    marioletto Guppy

    ok, is working now with Jet OLEDB,
    thanks
    m.
  12. Da Man

    Da Man Guppy

    Thanks for fixing the problem Yash... i recieved your email and read this post http://support.jodohost.com/showthread.php?t=3146
    the only problem with this is that your ODBC Service in Hsphere does not have a jet option??? i use access DB's for sites that gets modified alot

    I like MS SQL alot its just alot more work to use it...
    So if you can add a jet set up in the ODBC Service ill change ASAP

    THanks,
    Tim
  13. Yash

    Yash Bass

    You can also use DSN-less Jet OLEDB connections. But yes, the CP only allows you to create Access ODBC DSNs, I'll check that out

Share This Page

JodoHost - 26,000 hosting end-users in 100 countries
Plesk Web Hosting
VPS Hosting
H-Sphere Web Hosting
Other Services