Saved Bookmarks
| 1. |
Solve : ODBC Batch? |
|
Answer» Hi, is it possible to set up a ODBC CONNECTION using a batch file and if so how? What exactly are you trying to achieve? What operating systems does this involve? What source DBs? Etc. I have a large number of USERS, most of which aren't very technically minded so instead of trying to talk people through setting up the ODBC connection over the PHONE I would like to automate the process somehow and I thought probably the easiest way would be to create a batch file that I could send to them. Using Win XP as are all the users on the domain. Connection is to a SQL Server Thanks What I found useful in these types of situations is to do some screen captures of the install process and post them on a company Knowledge base area or Intranet if you have one.Ack. How's your C programming? As far as I know the ODBC system (which is a bit of a hotchpotch at best) doesn't have a command LINE interface. You can probably achieve what you want using the API (see >MSDN<) or maybe someone on one of the MS advanced forums could help with this. It's over my head, I'm afraid. :-/No problem, I was unsure if there was a command interface for this. I can do this in vb but it's a pain... oh well best get to it! Thanks againGood luck. Maybe you'll be able to release a bit of shareware/freeware at the end of it. |
|