[THIN] Re: DSN and Access db
- From: "Greg Reese" <gareese@xxxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Mon, 23 Jun 2008 20:13:51 -0500
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
>
Other related posts:
