You'd better use Web Service or remoting, the client app won't store connection. It should be store on the server that offer web service.
Take this for your reference, hope this helps. If you want any detail help, please tell us. http://www.codeproject.com/KB/webservices/myservice.aspx On Fri, Jul 3, 2009 at 12:51 PM, vineet <[email protected]> wrote: > > Dear Friends, > May I request for a small help regarding VB-MySQL ! > I have ERP solution in VFP for medium scale businesses. > I am now converting it to VB-MySQL. > In this, different users need to login with their ID's. > So, the connection string can't be defined while writing code. It will > be different for each session (to be entered from login screen) > Secondly, there are more that 100 VB.NET forms, each requiring > connection string to MySQL. > If we store conn string in app.config of a particular form, how other > forms can retrieve it ? > My query is that, where & how to store the connection string sothat -- > 1) it will be available to all different VB.NET forms, and > 2) connection string to MySQL will be different for every session. > You are requested to throw some light on the above-mentioned task. > Thanks, > Vineet. > -- Sincerely, Kira Qian E-mail: [email protected]
