I need help in understanding connection strings and if I am approaching this problem correctly, my application is an intranet app that at present does not use security and it is an information (lookup & reporting) app. I am limited to development in A5-V10.5 with most feature packs.
I am reading against an existing package application that stores it’s data in Access .MDB files and uses a storage structure as follows. X:\Application_Dir = parent data and X:\Application_Dir\Client1 = customer-specific data. Now application Dir holds an MDB that is dynamic (Customers come and go) this database holds customer information and data directory associated with a customer I/E \Client1 or \Client2 etc.
My goal is to use the Customer.mdb as a dropdown list to select the given customer then build the connection string based on that chosen. Again all that is changing is the Directory the connection string points to so in theory I would be doing a string substitution based on selection.
Now the problem, I have searched the forum and read most threads on the topic of mutli-tenant applications and dynamic connection strings and have read most of the documentation I can find relating to this but it is NOT clicking. I am more of a procedural programmer C, VB, etc. where I can do this in an application based on variables but this is closed scope. In my test app, I am using a grid and setting the connection as SQL to access (not sure this is correct), then when I look at the source template header I can see the CS default connection setup and string and it is what I am expecting to deal with. Now is where I get fogged, I know I must somehow change the connections string and thus the connection session variable and do a refresh but I have no idea where to start or add. As a test, I would like to just use an input box to manually type the path and initiate data change and grow from there.
Please understand I get the concepts but as with much of the online documentation it assumes you know more than you might ;-) and at this point that’s me and I’m stuck.
Any help or pointing to good reading is more than appreciated
Rick
I am reading against an existing package application that stores it’s data in Access .MDB files and uses a storage structure as follows. X:\Application_Dir = parent data and X:\Application_Dir\Client1 = customer-specific data. Now application Dir holds an MDB that is dynamic (Customers come and go) this database holds customer information and data directory associated with a customer I/E \Client1 or \Client2 etc.
My goal is to use the Customer.mdb as a dropdown list to select the given customer then build the connection string based on that chosen. Again all that is changing is the Directory the connection string points to so in theory I would be doing a string substitution based on selection.
Now the problem, I have searched the forum and read most threads on the topic of mutli-tenant applications and dynamic connection strings and have read most of the documentation I can find relating to this but it is NOT clicking. I am more of a procedural programmer C, VB, etc. where I can do this in an application based on variables but this is closed scope. In my test app, I am using a grid and setting the connection as SQL to access (not sure this is correct), then when I look at the source template header I can see the CS default connection setup and string and it is what I am expecting to deal with. Now is where I get fogged, I know I must somehow change the connections string and thus the connection session variable and do a refresh but I have no idea where to start or add. As a test, I would like to just use an input box to manually type the path and initiate data change and grow from there.
Please understand I get the concepts but as with much of the online documentation it assumes you know more than you might ;-) and at this point that’s me and I’m stuck.
Any help or pointing to good reading is more than appreciated
Rick
Comment