Aman, Yes, you can, but: 1) force the use of UNC path in the ODBC settings. Your drive mappings are not reliable when things are running as a service. 2) Ensure the user id running the service is a domain account and has access to that drive/directory. Apache may be running as "local system" or a local user instead of as some domain account -- which would/should mean it doesn't have access to the network drives. We can take this off line after this, and if you still have problems, you can email me directly. Regards, Jeff
-----Original Message----- From: Aman Raheja [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 12:56 AM To: [EMAIL PROTECTED]; dbi-users Subject: Re: Win32::ODBC probem when using apache Thanks Jeff. I think that's where the problem is - it is a network mapped directory. Does that mean that there's no way i could use it ? Input appreciated. Regards Aman [EMAIL PROTECTED] wrote: 1) I suggest to not create DSNs with spaces. It may cause issues. 2) If you use DBI, you can get a good error message and turn on tracing to get better information (DBI->trace(9, "c:/trace.txt");) 3) Ensure the user running apache has permissions to the drive/directory that the dBASE Files points to. 4) Ensure the DSN is using UNC instead of drive letter, if the drive/directory is located on a separate machine. Regards, Jeff I will create DSN w/o spaces. The situation is that the dBase files are at d:\DBTEMP and apache at d:\Program Files\Apache Group\apache2 With this cause a problem - by saying apache should be able to access, do you mean it has to be in apache's root directory? Thanks for the input No, I mean that the user account running apache must have access to the d:\dbtemp directory. I'm assuming that D is a local drive, not a mapped one. If you are using NTFS, though, check the permissions on the d:\dbtemp directory. Also -- ensure that the apache user has access to the perl directory tree too... Jeff -- Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with [EMAIL PROTECTED] http://shopnow.netscape.com/
