CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 ODBC connect to secure share?

Print topic Send  topic

Author Message
cobom


Posts: 55
Posted: 12/08/2004, 5:06 AM

My app runs fine in development - but when I move the database to a network share that has permissions set so that only administrators have access it stops working. I have changed the ODBC connections to point to the new location.

What permissions do I need to add to the share so that it will work? The dbase is in access, the share is on a Network Aplliance file server - so the permissions are set using domain user level security. :-(
_________________
cmckinney@searay.com

Will program for a Sea Ray 680 SS ;}
View profile  Send private message
E43509

Posts: 283
Posted: 12/08/2004, 5:18 AM

Those darn IT folk that love to lock down the world and make it inconvenient to the rest of us.
I assume that it is a MsAccess db
Access requires modify/read&execute/list folder contents/read/write
Login as that domain user and see if you can open up that db in regular MS access and update a row in a table. If you can, then you want to make sure that the user on the webserver that maps to that directory can also do it.
View profile  Send private message
peterr


Posts: 5971
Posted: 12/08/2004, 10:43 AM

Yes, the Web users are anonymous and therefore they cannot run your Web programs as an administrator and connect to a database as an administrator. Instead, they are executing Web applications as Web Server user, which is usually "IUSR_xyz" or "ASPNET", depending on which programming language you use. You probably will need to setup similar permissions as shown at http://support.yessoftware.com/kb_article.asp?article_id=4
I'm actually not sure if this will work, while there could be some other methods to go about this, like changing some IIS settings so that IIS runs as an administrator. Do some researching on Google:
http://www.google.com/search?hl=en&q=odbc+access+network
http://www.google.com/search?hl=en&lr=&q=odbc+access+network+share

_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.