DatabaseConnectEx statement

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.

Try "MS SQL Server" instead of "SQLServer"

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?

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]

Yes, I am able to connect via ODBC. So the best practice going forward is to use ODBC with JAL?

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.