In regards to kace 1000 scripting, is it possible to create or configure an ODBC connection, point it to a different database, or entering credentials etc, Some software installs require a odbc connection to point to a different database or some require the odbc connection to be created from scratch. Just looking for anyone who might point me in the right direction to make a software install 100% complete instead of 75%. Thanks.

Lee
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

1
You mean connect a KScript to another database via ODBC? I don't believe this is possible.
Answered 03/07/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
1
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
Answered 03/07/2011 by: isolinear
Orange Belt

Please log in to comment
1
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.
Answered 03/07/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
1
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.
Answered 03/07/2011 by: isolinear
Orange Belt

Please log in to comment
1
http://msdn.microsoft.com/en-us/library/ee388579%28v=vs.85%29.aspx
Answered 03/07/2011 by: airwolf
Tenth Degree Black Belt

Please log in to comment
1
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.
Answered 03/07/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
Answer this question or Comment on this question for clarity