Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Connecting to incorrect Server

Status
Not open for further replies.

erisoov

Technical User
Nov 6, 2014
9
GB
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 and then click here at item 4.

the script is applydb.asp which calls common.asp where the server is assigned
 
There is a distinct lack of any files at the links provided.


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
 
It looks like the error is happening when you execute a stored procedure "update_titles", is the old server hardcoded in there?
 
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]
 
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?
 
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.
 
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
 
 http://files.engineering.com/getfile.aspx?folder=04f1309a-e330-4232-a308-2c59a1a10707&file=applydb.asp
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
 
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
 
Cannot find that procedure anywhere, used mdb viewer and fileviewer, the database would probably be circa 2000
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top