KACE Product Support

You mean connect a KScript to another database via ODBC? I don't believe this is possible.

Thanks for the reply Andy

What I'm trying to accomplish is a script that installs a msi or installshield setup (doesn't matter to me - I'm ok with both) but after the install completes, I have to drive manually to control panel, ODBC connections, add a SQL server (or configure one that the software created but didn't configure) an add or change settings there to truly have the software setup correctly. Kace1000 performs the software installs perfectly, it's the little odbc setup on some of our software thats throwing a wrench into the plan. Let me know your thoughts if you have a moment

-Lee

OH! You want to create an ODBC connection on the client as part of the script/install? That should be possible. If the ODBC connection is configured as part of an MSI setup, then you'll simply need the command line options to configure the ODBC connection. If you need to manually configure the ODBC connection after the MSI has run, just use a command line utility to create the ODBC connection. I haven't done that before, but I'm sure there is a command line utility to do this.

I must be the worst google searcher out there because I've been searching for that exact thing with no luck. I'll keep looking. Thanks for the input.

http://msdn.microsoft.com/en-us/library/ee388579%28v=vs.85%29.aspx

You can create an ODBC DSN by taking the registry entries from another working machine. Don't forget to install the ODBC driver first (if it's not already). Do you want a system DSN or user DSN? That will determine where you put it in the registry.