Classic ASP

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Ejikeme — Mon, 22 Jun 2009 15:53:36 GMT

Dear Curly

I forgot to mention

What do you mean by "enctype"

thankyou Curley

Sincerely

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Ejikeme — Mon, 22 Jun 2009 15:49:46 GMT

yes its an ms access Form converted to a webpage but not yet published and the buttons dont work.

I have been playing with them as suggested however i gave up to seek fresh ideas.

My html and vb landguage is not too strong however i have tried various commands unsussefully.

you suggested post and get can you elaborate on both languages so i can have another go.

Sincerely

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

curly101 — Mon, 22 Jun 2009 15:43:11 GMT

Wish I could help you, but I am not sure what you are referring to. When you say "dataAccessPages", do you mean a web page with a Microsoft Access database on it? If so, you might want to check your buttons...are you setting it to Post, Get, and is your enctype correct? You should play with them and see what happens/works.

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Ejikeme — Mon, 22 Jun 2009 15:34:46 GMT

Dear Curley

I dont know if our problems are related, I dont know if its just a virus

I had problems converting my forms to DataAcessPage,(ie re - register ole) message kept coming up.

When i finally registered to microsoft ole db my forms were able to convert but my buttons dont work.

is it a virus?, is it ms ole db provider .

Are you farmilar with dataAccessPages and am i doing anything wrong.

Sincerely

Ejike

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

tomkmvp — Mon, 22 Jun 2009 15:30:06 GMT

curly101:
MM_connUrge_STRING = "dsn=connUrge;"

So you're using a DSN. I can't tell the details of the connection from that.

Why don't you do it this way?
http://databases.aspfaq.com/database/what-should-my-connection-string-look-like.html

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Ejikeme — Mon, 22 Jun 2009 15:21:54 GMT

Dear friend they are all inter-twined.

Form = ms acess

howwever it stops being access when saved as a webpage.

I received a message stating "provider" begin ms ole provider .

I joined this forum when i had that you have been having problems with ole db provider approximately when i started converting my files to webpages.

anyway thankyou for your time

Sincerely

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

curly101 — Mon, 22 Jun 2009 15:15:18 GMT

Here is our connection...

<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_connUrge_STRING
MM_connUrge_STRING = "dsn=connUrge;"
%>

Anyone who goes to any MS Access page, on any of the sites, can't see it. They get the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

/default.asp, line 9

Line 9: rsHomePageBody_cmd.ActiveConnection = MM_connUrge_STRING

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

tomkmvp — Mon, 22 Jun 2009 15:09:45 GMT

I have no idea what you're talking about. I am not familiar with a DataAccessPage. Perhaps this is something for an MS Access forum?

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Ejikeme — Mon, 22 Jun 2009 14:30:11 GMT

My Form buttons do not work when i save as DataAccessPage.

Before i even got to DataAccessPage my forms refused to save as webpage.

when it finally saved as webpage the buttons wouldnt work.

I received error messages like "the provider" being ms OLE provider.

i have used ms script editor to edit vb command script.

the response i get when i click the button is "stack 10 overflow"

I have also been reading up on dhtml and it says that i can run vb command scripts with iis.

this has led me to your forum.

How do i install IIS to run my Buttons on DataAccessPage.

Or is there something that i am not doing right to activate form buttons on dataAccessPage

yOur advise will be appreciated

Sincerely

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

tomkmvp — Mon, 22 Jun 2009 13:42:28 GMT

What is the connection string used?

Does this involve anonymous access or authenticated users?

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

curly101 — Fri, 19 Jun 2009 22:16:01 GMT

Thanks. I've seen you post that page before, and I've been to it. But it doesn't show me anything we haven't tried already. None of those options worked.

Thanks.

Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'

tomkmvp — Fri, 19 Jun 2009 19:52:54 GMT

http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

curly101 — Fri, 19 Jun 2009 17:26:22 GMT

Hi,

We're running Server 2003, and we have a number of websites on our server that are running Access Databases.

For some reason, last week, none of the websites/web pages that have an ASP Access connection, are working. We've searched google for answers and all we get are "permission" settings...but for every website? We've checked the settings and they are fine. We've even uninstalled and reinstalled ASP.

Here is the error:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

/default.asp , line 9

It points to the same line on every website: rsBio_cmd.ActiveConnection = MM_connMGW_STRING

Any assistance would be appreciated. Thanks.