I am developing a small vb application which process a file(s) from user's machine and output a file into user's machine. Everything works fine when I test using my machine. However, when I launched the vb exe from a server into my machine thru drive mapping, I can't retrieve the desired file. The error message given is as follow :-

"Item cannot be found in the collection corresponding to the registered name or ordinal"

The structure of the system and the user is as following:-

sql database: server A
vb exe: server B
users: individual workstation
folders that contains data to be processed: individual workstation

In the vb program, I code it to pick the file from C drive. The coding looks like below:-

txtAttach.Text = "C:<folder1><folder2><filename.txt>"

Please tell me how to correct this. Thanks   

Everything I saw with that error was related to ADO... If you gave the exact line where the error happened (you can guess by what all is done before the program errors, or if it's logged, by that) it would be useful.

Personally I perfer using the UNC path (IE: \ComputernameSharedFolder) instead of mapped drives, the latter causes problems a lot I've found.

Since you've mentioned SQL, I'm assuming that you're accessing data from it although you never mentioned it. Given that assumption, I'd have to say that you'd need to make sure the MDAC controls are installed on the server where the program is running.





____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)

Hi,

Thanks for the reply. What is MDAC controls and how to check whether the application host server has it yet installed?

Common reply, but always with diffenent question types...

http://www.microsoft.com/data/

There's "An Updated version of Component Checker Now Available" that you can download and run on the server. It will tell you what version (if any) is installed. MDAC controls are also available there. Although if it is a server (Server OS [NT Server/Advanced Server]) and you're not the administrator; have the admin do the installation of the controls - certain versions can't be installed on some servers, and you don't want to crash it.

Oh, MDAC controls are data access DLL's (controls) for like SQL/Access (ADO/DAO).



[Edited by JLRodgers on 24-12-2002 at 01:47 AM GMT]

____________________________
Everywhere's Local (classifieds, job postings, & more for everycity in the world - user entered)