INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Connecting to incorrect Server

Connecting to incorrect Server

(OP)
I have an vbasic script that updates a webpage database records.

The script updates additions and deletions, but will not update field changes, this is because the run is pointing to an old server InetPub (I recently updated to the Arvixe host site) and produces the error message below

Microsoft JET Database Engine error '80004005'

'E:\InetPub\esvc000072\DB\NetBooklist.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

/newadmin/ApplyDB.asp, line 199

The script is run at http://musick-cokerybooks.com/newadmin/ and then click here at item 4.

the script is applydb.asp which calls common.asp where the server is assigned

RE: Connecting to incorrect Server

There is a distinct lack of any files at the links provided.


Quote:

Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.

And have you done the above?

Is your script using Server.MapPath('database') or is the path to the Access database hardcoded?

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

RE: Connecting to incorrect Server

It looks like the error is happening when you execute a stored procedure "update_titles", is the old server hardcoded in there?

RE: Connecting to incorrect Server

(OP)
It is hard coded in there, but my vbasic is, well basic so I cannot find it, I also don't know the syntax to replace it with the new server [sad]

RE: Connecting to incorrect Server

(OP)
It actually does the first half of the procedure it succesfully completes
function InsertNewTitle(vconNetBooklistLive)
function DeleteExistingTitle(vconNetBooklistLive)

But if a field is changed in the database, it does not update any of the fields?

RE: Connecting to incorrect Server

First you need to locate the stored procedure "update_titles"... it's not defined in the two vbs files you posted, so I would check the database for it.

RE: Connecting to incorrect Server

(OP)
Yes it is in the applydb.asp about 3/4 way down

function UpdateExistingTitle(vconNetBooklistLive)

dim cmdBooklist
dim lngNumRows

set cmdBooklist = createobject("ADODB.Command")

with cmdBooklist
.ActiveConnection = vconNetBooklistLive
.CommandType = 1
.CommandText = "EXEC update_titles"
.execute lngNumRows
end with

set cmdBooklist = nothing

UpdateExistingTitle = lngNumRows

end function

RE: Connecting to incorrect Server

Yes, i already saw that. That is the vbscript where the stored procedure called "update_titles" is being EXECUTED from. But somewhere else (not in the .asp files you posted) is the definition of the stored procedure called "update_titles". It's a SQL command, and i guess its defined inside the database you are using... so let's talk about that, what database are you using? Can you find that stored procedure? that will probably solve your problems

RE: Connecting to incorrect Server

(OP)
The database is only an Access database, I am not sure which version of Access, I will do a search of the files for update_titles and come back.

Thanks so much for your help

RE: Connecting to incorrect Server

(OP)
Cannot find that procedure anywhere, used mdb viewer and fileviewer, the database would probably be circa 2000

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close