I'm having a "Database" connection problem! 1

[garymgordon]

Here the dilemma.

We have an NT server.

We just installed the database drivers.

Now .. for my stupid question:

If I am trying to access a Microsoft ACCESS database .. using OLE DB .. (through an ASP script) .. does Microsoft ACCESS have to be installed on the server?

I know this is a dumb question.

But .. does the server itself have to have ACCESS installed in order for the ASP script to connect to the .mdb file and open it, etc., etc.???

If it doesn't have ACCESS installed on the server .. what kind of error will I get. (Currently it is saying it can't connect to the databse. Would that be why?)

Don't laugh at me.

But I am the web developer and not familiar with the server side of things .. but it would make sense that ACCESS needs to be installed on the server. I just need to find out why it's not able to access the .mdb file.

HELP!!!!

Gary
Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer

http://www.garymgordon.com/

 

[browolf]

u need to be more specific about the error msgs.


I'm not absolutely sure that access has to be installed but i installed it last time i set up an ASP server and it makes sense that you'll be sure the server has the correct version of the ODBC drivers.

===============
Security Forums

http://www.security-forums.com

 

[garymgordon]

Ok.

The error I get when I try to connect is:

"Microsoft JET Database Engine error '80004005'

Unspecified error

/dept/its/njcu_directory/directory.asp, line 7 "



Lines 5,6 and 7 say:

Line 5) Set objConn=Server.CreateObject("ADODB.Connection&quot

Line 6) objConn.Provider="Microsoft.Jet.OLEDB.4.0"

Line 7) objConn.Open(Server.Mappath("directory.mdb&quot)


Now .. I have this installed on another server and it is running fine. But I need to move it to a different server. This is where the problem is now.

So, ... I am not sure:

1) Aside from installing the database drivers (which they recently did about 2 weeks ago ... do they need to configure them in some manner???? Anything special after they install them .. and see them showing up?

2) Does MS Access need to be installed on the server or not .. in order to have the ASP script read, write, etc. to the .mdb file??

If you need more info .. please list the questions out and I'll answer them the best I can.

Thanks,
Gary

Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer

http://www.garymgordon.com/

 

[browolf]

the thing to do, what i do, is paste the error msg into google and google groups and read msgs until u find one that helps.

i found this one

http://groups.google.co.uk/groups?q...TF-8&selm=Oo9WpDuvBHA.2676@tkmsftngp04&rnum=7

===============
Security Forums

http://www.security-forums.com

 

[browolf]

+ i think this is helpful

Microsoft Jet database engine advice
Who should read this article: Anyone hitting an Access database from ASP

http://www.aspalliance.com/PeterJohnson/JetAdvice.aspx

aparently it's not access u need but the latest version of Jet. 4.0 is the access 2000 version. ===============
Security Forums

http://www.security-forums.com

 

[garymgordon]

Thanks.

I give all of this a look and see what I can make of it.


Gary
Gary M. Gordon, LLC
webmaster@garymgordon.com
Certified Web Developer ::
Application Programmer

http://www.garymgordon.com/