SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
DatabaseConnectEx statement

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
DatabaseConnectEx statement
Author Message
Loril



Joined: 21 Feb 2007
Posts: 82

Post DatabaseConnectEx statement Reply with quote
I've downloaded the latest version 5.2.417 and installed it. Using JAL, I am trying to use the DatabaseConnectEx statement to connect to a sql server database. This is the error I received: "An error occurred while executing automation script Line 8: DBMS SQLServer is not supported in your current installation." I am wondering if my syntax is correct:

DatabaseConnectEx "SQLServer", "server_name", "database_name", "user", "password", TRUE

Please advise. Thanks.
Fri Jul 11, 2014 2:23 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Try "MS SQL Server" instead of "SQLServer"
Fri Jul 11, 2014 10:08 pm View user's profile Send private message
Loril



Joined: 21 Feb 2007
Posts: 82

Post Reply with quote
Thanks, I tried that and now I receive this error:

"DBMS MSS is not supported in your current installation"

Perhaps I missed installing a component?
Tue Jul 15, 2014 5:57 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
That message indicates that the legacy DBLib driver is not installed on the system. Can you connect using ODBC driver?

Code:
 DatabaseConnectEx ODBC", "ODBC profile name (32-bit)", "user", "password", True
[/code]
Tue Jul 15, 2014 6:57 pm View user's profile Send private message
Loril



Joined: 21 Feb 2007
Posts: 82

Post Reply with quote
Yes, I am able to connect via ODBC. So the best practice going forward is to use ODBC with JAL?
Tue Jul 15, 2014 7:44 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Not necessarily ODBC, you can use other database drivers as well, but it's just the easiest method for MS SQL Server, because every Windows copy comes with SQL Server ODBC driver pre-installed on it.
Tue Jul 15, 2014 10:15 pm 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.