Showing results for databases - Scripting Blog [archived]

Hey, Scripting Guy! How can I retrieve a list of the System DSNs on a computer?-- RT Hey, RT. You know, there’s an old Hollywood superstition that suggests that famous movie stars always die in threes: if a famous star dies today, then according to legend two more famous stars are doomed to die in the next week as well. We don’t know if that’s t...

Hey, Scripting Guy! How can I get a list of the ODBC drivers that are installed on a computer?-- VV Hey, VV. This is one of those questions that end up driving us crazy. That’s because it: a) seems so simple and, b) appears as though there are a number of ways to get this information. For example, on our Windows XP computer we have no fewer than...

Hey, Scripting Guy! How can I tally items in a text file?-- JA Hey, JA. If we understand you correctly you have a text file that consists of a number of lines, each line representing a particular item. Just to keep things simple, let’s say your text file consists of city names:City Seattle Seattle Los Angeles Chicago Seattle Los Angeles Pittsbur...

Hey, Scripting Guy! How can I use ADO to open a text file that has spaces in the file name?-- TL Hey, TL. You might not even remember sending us this question; to say it’s been awhile would be an understatement. (You should have seen all the dust and cobwebs we had to brush off this question before we could post it in the Script Center.) A long ...

Hey, Scripting Guy! Can I delete a table from a Jet database using a script?-- AK Hey, AK. Of course you can delete a table from a Jet database using a script; after all, you can do anything using a script! Well, OK, maybe not DHCP server stuff. And maybe you can’t change the display resolution of your computer. And maybe not - well, let’s just ...