[THIN] Re: DSN and Access db

  • From: StGeorge <wcsconnect@xxxxxxxxx>
  • To: thin@xxxxxxxxxxxxx
  • Date: Tue, 24 Jun 2008 09:55:30 +0800

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@xxxxxxxxxxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxx> 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:
> //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
> ************************************************
>

Other related posts: