paul.hartland at fsmail.net
paul.hartland at fsmail.net
Wed Jul 23 09:50:42 CDT 2003
John, Very sorry about that, I will do from now on..... Paul From: <jcolby at colbyconsulting.com> Date: Wed 23/Jul/2003 14:40 GMT To: <dba-sqlserver at databaseadvisors.com> Subject: RE: [dba-SQLServer][AccessD] Auto Supply Connection strings and passwords to controls on forms(VB6 & SQL) Paul, Could you CC the other lists instead of putting all the list names in the To. I have rules that sort things out into mail boxes and it appears that the message server transmits the message several times (or maybe you're doing that?). I use a crude if [AccessD] is in the subject and... for example in my VB folder I have FIVE copies of the message with the following in the subject: [dba-VB] [dba-SQLServer][AccessD] Auto Supply Connection strings and passwords to controls on forms(VB6 & SQL) [dba-VB] [AccessD] [dba-SQLServer]Auto Supply Connection strings and passwords to controls on forms(VB6 & SQL) [dba-VB] [AccessD] Auto Supply Connection strings and passwords to controls on forms(VB6 & SQL) [dba-VB] [dba-SQLServer]Auto Supply Connection strings and passwords to controls on forms(VB6 & SQL) [dba-VB] Auto Supply Connection strings and passwords to controls on forms(VB6 & SQL) I am getting 2 copies in my AccessD folder as well as a copy in SQL Server folder and FIVE copies in my Access-VBA folder. I think if you put just the one list name you are sending to, plus the other list names in CC perhaps this wouldn't happen. I can't tell you precisely what is going on but I can tell you I got a grand total of EIGHT copies of this message. John W. Colby www.colbyconsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of paul.hartland at fsmail.net Sent: Wednesday, July 23, 2003 10:07 AM To: dba-sqlserver at databaseadvisors.com; accessd at databaseadvisors.com; dba-vb at databaseadvisors.com Subject: [dba-SQLServer][AccessD] Auto Supply Connection strings and passwords to controls on forms(VB6 & SQL) To all, I have a VB6 application which looks at a SQL Server 7 database (which is on a development server), and I am using a mixture of DataEnvironment and ADO Controls for the application. However when it's finshed It will be moved to the live server so that everyone can gain access to it. The problem being that when I move to the live server I will have to remember to change all the ADO controls and the DataEnvironment connection manually (I don't want to have to do this if I can help it). What I thought of doing is have a table consisting of the ConnectionString, Username & Password and then a table of all the form names and ADO Controls, and somehow looping through the tables and setting the connections automatically. This is where I am stuck, I have created the tables and entered the connection strings etc, and I can do the loop which will loop through the records, but I don;t know how to set the connection strings, using the form names and ADO Controls from the tables. Am I being stupid in doing it this way ? Is there a better way to do this ? Can anyone help on this, as the application is almost finished.....? Thanks for any help in advance.... Paul Hartland __________________________________________________________________________ Join Freeserve http://www.freeserve.com/time/ Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com __________________________________________________________________________ Join Freeserve http://www.freeserve.com/time/ Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.