Tech Tip: Using 4D Database Name Syntax with SQL LOGIN
PRODUCT: 4D | VERSION: 12 | PLATFORM: Mac & Win
Published On: March 3, 2011
Normally it is possible to connect to a 4D Server database via the SQL Server using the syntax:
SQL LOGIN("4D:my_db_name:19812";"Designer";"my_password";*) |
This uses the database's publication name in "my_db_name" above. Obviously this won't work if the database is not being published. This also will only work if the database Application Server is published on the default port, 19813. If you are using a custom port for publishing the Application Server then the IP address syntax for SQL LOGIN must be used, as shown here:
SQL LOGIN("IP:127.0.0.1:19812";"Designer";"my_password";*) |
(Use your 4D Server machine's IP address instead of 127.0.0.1.)