Tech Tip: Using SQL LOGIN to connect with SSL
PRODUCT: 4D | VERSION: 12.1 | PLATFORM: Mac & Win
Published On: December 21, 2010
When connecting from one 4D application to another via the SQL Server and SQL LOGIN, a special syntax is required when using SSL: add ":ssl" at the end of the IP address.
For example a regular SQL LOGIN statement to connect to another database on your machine might be:
| SQL LOGIN("IP:127.0.0.1:19812";"Designer";"123") |
To connect via SSL the statement would instead be:
| SQL LOGIN("IP:127.0.0.1:19812:ssl";"Admin";"123") |