Connecting to incorrect Server

[erisoov]

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

 

[ChrisHirst]

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

 

[erisoov]

Sorry I will upload again

 

[guitarzan]

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

 

[erisoov]

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

 

[erisoov]

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?

 

[guitarzan]

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.

 

[erisoov]

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

 

[guitarzan]

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

 

[erisoov]

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

 

[guitarzan]

I haven't used versions of Access newer than 2003, which didn't support stored procedures directly, but this link shows where it would be in Access 2010:

http://stackoverflow.com/questions/3287545/how-do-i-make-a-stored-procedure-in-ms-access

 

[erisoov]

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