[THIN] Re: DSN and Access db

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
************************************************