Link to home
Start Free TrialLog in
Avatar of Dale Fye
Dale FyeFlag for United States of America

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
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

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.
Avatar of Dale Fye

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
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.
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
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
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial