SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
setting up new odbc connections to mssql via JAL / auth

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
setting up new odbc connections to mssql via JAL / auth
Author Message
liangzhu



Joined: 30 Nov 2011
Posts: 42
Country: Singapore

Post setting up new odbc connections to mssql via JAL / auth Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
liangzhu



Joined: 30 Nov 2011
Posts: 42
Country: Singapore

Post thanks! Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.