[THIN] Re: DSN and Access db

This isnt a mod to the db though, its a mod to the environment.

Setting up a dsn is effectively a reg key, so setting it in a policy
shouldnt be an issue.

Berny

On 6/24/08, StGeorge <wcsconnect@gmail.com> wrote:
> Just heard that Austrade will not support a dB that is modified in this way
> - the only alternative is to merge the data - will check this out.
>
> Many thanks
>
> Rob
>
> On Tue, Jun 24, 2008 at 9:39 AM, Berny Stapleton <berny@technology.net.au>
> wrote:
>
>> Umm, what about a user dsn, set in a registry key? The app would make
>> a call to a dsn, it couldnt determine user from system could it? Get a
>> test instance and try a user dsn and see if it works.
>>
>> Berny
>>
>> On 6/24/08, Greg Reese <gareese@gmail.com> wrote:
>> > it's a shame they hard code it. Multiple DSN's would do the trick for
>> you.
>> >
>> > On Mon, Jun 23, 2008 at 6:00 PM, StGeorge <wcsconnect@gmail.com> wrote:
>> >
>> >> Good Morning,
>> >>
>> >> We have a client running an Aust trade db Application. The application
>> >> uses
>> >> a System DSN to talk to an access db.
>> >> We require for good governance to run a separate db for each state,
>> >> does
>> >> anybody have any ideas as to get round this
>> >> problem? Currently if we change the DSN to point to Victoria then all
>> >> users
>> >> get the Victoria db and similar for QLD.
>> >> I was thinking of changing the DSN on the fly but I am not sure if the
>> >> application after locating the db would continue using the DSN,
>> >> this would cause a corruption with users updating the wrong db. The
>> >> DSN
>> >> is
>> >> hard coded in the the application.
>> >>
>> >> They are running a single 4.5 Adv Citrix server.
>> >>
>> >> Regards
>> >>
>> >> Rob
>> >>
>> >
>>
>> --
>> Sent from Gmail for mobile | mobile.google.com
>> ************************************************
>> For Archives, RSS, to Unsubscribe, Subscribe or
>> set Digest or Vacation mode use the below link:
>> http://www.freelists.org/list/thin
>> NEW! Follow Thin List on Twitter!
>> http://twitter.com/thinlist
>> Thin List discussion is now available in blog format at:
>> http://thinmaillist.blogspot.com
>> HOT! Thinlist MOBILE Feed!
>> http://thinlist.net/mobile
>> Thinlist quick pick
>> http://thinlist.net
>> ************************************************
>>
>

--
Sent from Gmail for mobile | mobile.google.com
************************************************
For Archives, RSS, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://www.freelists.org/list/thin
NEW! Follow Thin List on Twitter!
http://twitter.com/thinlist
Thin List discussion is now available in blog format at:
http://thinmaillist.blogspot.com
HOT! Thinlist MOBILE Feed!
http://thinlist.net/mobile
Thinlist quick pick
http://thinlist.net
************************************************