Jon Tydda
Jon.Tydda at alcontrol.co.uk
Wed Mar 29 05:07:01 CST 2006
Ok, I give up again. I've spent all morning looking on Google for examples of a script I can modify to create the correct DSN. Has anyone got an example? Jon -----Original Message----- From: Jon Tydda Sent: 29 March 2006 09:46 To: 'Discussion of Hardware and Software issues' Subject: RE: [dba-Tech] VBScript Oh, that was simple <blush>. Yes, I imagine that'd work... I'll give that a go. Thanks for the suggestion Andrew :-) Jon -----Original Message----- From: Haslett, Andrew [mailto:andrew.haslett at ilc.gov.au] Sent: 28 March 2006 23:56 To: Discussion of Hardware and Software issues Subject: Re: [dba-Tech] VBScript Yuk. What type of application needs a mapped connection *per user* ? Must be pretty ancient. System DSN no good? -----Original Message----- From: dba-tech-bounces at databaseadvisors.com [mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Jon Tydda Sent: Wednesday, 29 March 2006 12:30 AM To: Dba-Tech (E-mail) Subject: [dba-Tech] VBScript Hi all I've got a database running that needs an ODBC connection to be mapped for each user on each computer, and it's getting a little tiresome having to open control panels, and fill in the boxes each time someone new uses a computer - to put it in perspective, there are 130 users and 130 PCs - the combinations are potentially huge... So I was wondering it it would be possible to write a scipt to do it for me that I can include in their login scripts on the server or something... but I don't know the first thing about VB Scripts. Would anyone be willing to talk me through it? Jon The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available on request from : webmaster at alcontrol.co.uk ALcontrol Laboratories is a trading division of ALcontrol UK Limited. Registered Office: Templeborough House, Mill Close, Rotherham, S60 1BZ. Registered in England and Wales No 4057291 _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com IMPORTANT - PLEASE READ *** This email and any files transmitted with it are confidential and may contain information protected by law from disclosure. If you have received this message in error, please notify the sender immediately and delete this email from your system. No warranty is given that this email or files, if attached to this email, are free from computer viruses or other defects. They are provided on the basis the user assumes all responsibility for loss, damage or consequence resulting directly or indirectly from their use, whether caused by the negligence of the sender or not. _______________________________________________ dba-Tech mailing list dba-Tech at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-tech Website: http://www.databaseadvisors.com The information in this e-mail is confidential and may also be legally privileged. The contents are intended for recipient only and are subject to the legal notice available on request from : webmaster at alcontrol.co.uk ALcontrol Laboratories is a trading division of ALcontrol UK Limited. Registered Office: Templeborough House, Mill Close, Rotherham, S60 1BZ. Registered in England and Wales No 4057291