 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
liangzhu
Joined: 30 Nov 2011 Posts: 42 Country: Singapore |
|
setting up new odbc connections to mssql via JAL / auth |
|
would be nice if i could get some pointers how to do this:
1. read a config file
2. use the information in the config file to create new odbc connection profiles to mssql
3. the platform should be win 2008r2, using the last windows edition of 24x7
4. connect to various databases to check on accounts
5. and if possible, not use SA but instead use the user that 24x7 is running as to do the queries
|
|
Tue Apr 24, 2012 9:52 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
1. read a config file
Check on-line help and script examples for IniFileGetKey
In fact the example script in the help file provides how to read database configuration parameters
2. use the information in the config file to create new odbc connection profiles to mssql
Check on-line help for DatabaseConnectEx
3. the platform should be win 2008r2, using the last windows edition of 24x7
This method is not platform specific.
4. connect to various databases to check on accounts
DatabaseConnectEx ...
Or if you mean databases, not servers, then DatabaseExecute "USE [db name here]", rows
5. and if possible, not use SA but instead use the user that 24x7 is running as to do the queries
If you mean Windows authentication account, try leaving user id and password blank in DatabaseConnectEx
Last edited by SysOp on Wed Apr 25, 2012 12:20 am; edited 1 time in total |
|
Tue Apr 24, 2012 10:26 pm |
|
 |
liangzhu
Joined: 30 Nov 2011 Posts: 42 Country: Singapore |
|
thanks! |
|
the other thing is, if i try to add a new ms sql server connection profile instead of adding a new odbc profile, i get "DBMS MSS is not supported in your current installation", is that because i'm using mssql express? or is that something i can configure?
|
|
Tue Apr 24, 2012 11:02 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
That legacy interface for MS SQL relies on DBLIB client (a key file is called NTWDBLIB.DLL) which is not pre-installed by default on modern Windows systems. The library last was shipped with SQL 2000, but then Microsoft stopped packaging it. If you have SQL 2000 installed or CD around, you can copy the DLL from there, or you can find a copy on the internet, for example, here
http://www.amazon.com/Microsoft-Server-2000-Developer-VERSION/dp/B000050AVL
As an alternative, you can use ADO/OLEDB interface or ODBC interface both of which are supported by 24x7.
Please note that 24x7 MP Edition supports JDBC interfaces as a primary connectivity method for SQL and for JavaScript jobs. These interfaces don't require database client software installed on the system, and the required database drivers are shipped with 24x7 and preconfigured for immediate use.
|
|
Wed Apr 25, 2012 12:19 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|