ODBC System DSN problem in Visual Basic 6.0
Posted on 2011-05-06
I am creating a software to produce student's transcript in which different department will enter marks for students from their office computers and data should come to a centrally located computer which will have an Access mdb file in a shared folder.
This folder I configured as shared folder across Local Area Network. This shared folder appears as drive letter Z and I create ODBC system DSN on each computer so that my visual basic application running on different computers can access this centralized data using System DSN from Network drive.
It works on each computer 1st time. But PROBLEM COMES when I turn off all computers and restrart next day, visual basic application fails to find ODBC connectivity and I am obliged to go in each computer's ODBC and configure the network drive path again.
If central computer is turn off then it should show the problem but when all computers are turned on then why this problem comes?
How I can make it permanent that each time a client computer wants to access data from centralized access database, it gets without reconfiguration.
Someone advised me to use PHP-MYSQL and make it web-like application but PHP-MYSQL is new for me and I am somehow familiar with Visual Basic 6 and Ms-Access.
How to make Network based database oriented application with proper security and reliability in Visual Basic 6.0 and Ms-Access?