asked on

Server.CreateObject Failed

Hi,

Earthlink is hosting our company website, and we use a small access db to track the user, nothing fancy...
The site was working fine yesterday, but I got this err this morning,

006~ASP 0177~Server.CreateObject Failed~8007045a

I did some research on the web, all pointed to the server, but Earthlink keeps sayng that is a coding issue.......any ideas? Thx

MGrassman

can you list some code.

mcrmg

ASKER

dim oConn
dim filePath
on error resume next
Set oConn = Server.CreateObject("ADODB.Connection") ..........ERROR LINE

      if(err.number<>0)then
            Response.Write err.Description
            Response.End
      end if
'oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath

      on error resume next
      oConn.Open "myDB.Mydsn"


      if(err.number<>0)then
            Response.Write err.Description
            Response.End
      end if

If not oConn.state then
response.write("Connection failed")
response.end
else
'response.write("OK")
End If

Ryan Chong

Is MDAC installed on targeted server?

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

ASKER CERTIFIED SOLUTION

Ryan Chong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mcrmg

ASKER

I have no idea because it was working fine yesterday and they keep saying that it is on the coding side............ :(

mcrmg

ASKER

Can we conclude that it is something wrong on the server? Thx

Ryan Chong

Did you do any changes on your server setting?

if the error is on the line:

Set oConn = Server.CreateObject("ADODB.Connection")

means the server failed to create ADODB object, this is very unusual, then i would suggest you backup your files, and then re-install MDAC. Hope it helps

mcrmg

ASKER

So, it is something on the server not the coding side?

SOLUTION

Clif

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ryan Chong

>>So, it is something on the server not the coding side?
Not 100% sure, to prove this point is correct, you need to duplicate a server setting on another machine, then try to deploy your scripts to that new machine, run it and we'll know is it script or server problem ;-)

SOLUTION

peterxlane

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mcrmg

ASKER

That turned out that Earthlink did do something on the server (of course, they would not admin that)...because all of the sudden, the site is working again.........Thanks for the help...