Dale Fye
asked on
can authentication service affect ADO communications?
I have a client who has an application which involves a combination of VBScript and Access to download data from an FTP site and then process that data into multiple Access databases. I'm not happy with the way this was implemented but I'm stuck with it.
I received an email this afternoon which indicates that about 15-20 of the files that should have been downloaded and processed on Monday did not make it into the Access databases.
Indications are that something occurred on there servers which affected their authentication service. Any chance that this would have affected ADO communications between the VBScript and the Access BE databases? I'm not a huge fan of VBScript or ADO and don't use either often enough to know what will or will not affect them.
Dale
I received an email this afternoon which indicates that about 15-20 of the files that should have been downloaded and processed on Monday did not make it into the Access databases.
Indications are that something occurred on there servers which affected their authentication service. Any chance that this would have affected ADO communications between the VBScript and the Access BE databases? I'm not a huge fan of VBScript or ADO and don't use either often enough to know what will or will not affect them.
Dale
Sounds like a server error. Can't you manually connect to the FTP server and check that download is alive and well?
Could be anything....any logging as part of the process? Is there any indication of where the process broke down?
Jim.
Jim.
ASKER
Been really busy this afternoon, guys, so I told the client I would do some digging over the weekend.
The Access part of the process has good error handling, but VBScript, in my experience, sucks for error handling. Sometimes it raises errors, which cannot be debugged at runtime, others it doesn't.
I don't have any experience with the authentication service and whether it is used by or would affect ado commands which read from or write to an Access BE. Just looking for ideas and things to look for when I do my deep dive this weekend.
Dale
The Access part of the process has good error handling, but VBScript, in my experience, sucks for error handling. Sometimes it raises errors, which cannot be debugged at runtime, others it doesn't.
I don't have any experience with the authentication service and whether it is used by or would affect ado commands which read from or write to an Access BE. Just looking for ideas and things to look for when I do my deep dive this weekend.
Dale
I would start with seeing if the site can be reached manually as gustav suggested. I'd also check the event logs (Application, Security, and System) and see if anything was logged.
<<I don't have any experience with the authentication service>>
That entails a multitude of things. Why are you focusing on this...have you seen something specifically related to this?
Your really not giving us much to go on here.
Jim.
<<I don't have any experience with the authentication service>>
That entails a multitude of things. Why are you focusing on this...have you seen something specifically related to this?
Your really not giving us much to go on here.
Jim.
ASKER
Jim,
All I know is that the client reported that their authentication service was down for 24-48 hours, and that coincidentally, about 20 records which should have been downloaded from their clients FTP site and uploaded into their production tracking system were missing from data that should have been downloaded during the same time period.
The process involves a Windows Task Scheduler, which kicks off a VBScript file which checks the FTP site belonging to my clients client for files and downloads those files to my clients network file server.
The VB Script file then processes these XML files, reading them and writing them to Access BE database tables and calling a number of Access procedures in the process, but most of that processing is done via VBScript running SQL Append, Update, and Delete queries via ADO.
I have not had a chance to dig into the data, to determine what was downloaded, or what records were written to the Access database. I am just attempting to see whether the authentication service might be involved in ADO communications between the VBScript application and the Access database.
Dale
All I know is that the client reported that their authentication service was down for 24-48 hours, and that coincidentally, about 20 records which should have been downloaded from their clients FTP site and uploaded into their production tracking system were missing from data that should have been downloaded during the same time period.
The process involves a Windows Task Scheduler, which kicks off a VBScript file which checks the FTP site belonging to my clients client for files and downloads those files to my clients network file server.
The VB Script file then processes these XML files, reading them and writing them to Access BE database tables and calling a number of Access procedures in the process, but most of that processing is done via VBScript running SQL Append, Update, and Delete queries via ADO.
I have not had a chance to dig into the data, to determine what was downloaded, or what records were written to the Access database. I am just attempting to see whether the authentication service might be involved in ADO communications between the VBScript application and the Access database.
Dale
I am just attempting to see whether the authentication service might be involved in ADO communications between the VBScript application and the Access database.
in terms of getting access to the directory where the DB resides, yes definitely. In terms of accessing the DB no, I don't see how it would play a role.
Jim.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.