Configure the Data Source (ODBC)
sales@landfx.com
+1 805-541-1003

Configure the Data Source (ODBC)

This guide will help you configure the ODBC data source.

What are ODBC, MySQL, and the F/X Server? For information on how these three integral components work together to allow you to use our software, see our Definitions article.

 

 

Step 1: Open the ODBC Control Panel

The steps for opening the ODBC control panel will vary depending on your version of Windows.

 

 

1. From your Control Panel, select Administrative Tools.

Administrative Tools option in Control Panel

 

 

 

ODBC Data Sources folders

2. Double-click one of the following folders:

  • ODBC Data Sources (64-bit) if you have a 64-bit operating system, or
  • ODBC Data Sources (32-bit) if you have a 32-bit operating system

Most operating systems are 64-bit. Find out which type you have

 

 

 

3. In the ODBC Data Source Administrator dialog box, select the System DSN tab.

 

Highlight your LandFX folder, then click Continue. The ODBC control panel will open.

 

You can now proceed with configuring the ODBC Data Source.

Did you see a System Error 126 message when you clicked Configure? If so, follow our steps to uninstall and reinstall the MySQL Connector.

ODBC Data Source Administrator, System DSN tab, LandFX folder

 

 

 

 

1. Navigate to the folder C:/Windows/SysWOW64.

 

 

Locate and double-click the file odbcad32.exe within this folder.

odbcad32.exe file in the folder C:/Windows/SysWOW64

 

 

 

ODBC Data Source Administrator, System DSN tab, LandFX folder

2. In the ODBC Data Source Administrator dialog box, select the System DSN tab.

 

Highlight your LandFX folder, then click Continue. The ODBC control panel will open.

 

You can now proceed with configuring the ODBC Data Source.

Did you see a System Error 126 message when you clicked Configure? If so, follow our steps to uninstall and reinstall the MySQL Connector.

 

 

 

 

 

Step 2: Configure the ODBC Data Source

The following steps pertain to both Windows 10 and Windows 7 users.

 

 

You'll now see the MySQL Connector / ODBC Data Source Configuration dialog box (the ODBC control panel).

 

Depending on your installation, follow our troubleshooting steps below for:

  • Single-User installations
  • Multi-User installations (office server or Cloud Licensing)
  • Cloud Data installations

Not sure which type of installation you have? Ask your IT administrator.

MySQL Connector / ODBC Data Source Configuration dialog box

 

 

 

 

Here's how to troubleshoot your ODBC Connection if you have a single-user installation – your computer does not connect to an office server to use our software, and you don't have cloud licensing.

 

 

Server name listed in TCP/IP Server text field

Listed in the TCP/IP Server text field is your server name.

 

 

If you have a Single-User installation, this field should read 127.0.0.1

 

 

Click Test.

 

 

 

 

You should see a Connection Successful message almost instantaneously.
.Connection Successful message

 

Connection Failed message

If you see a Connection Failed message at this point, follow our steps to configure your MySQL connection.

 

 

 

 

Here's how to troubleshoot your ODBC Connection if you have a multi-user installation, which means either:

  • Your computer connects to a central office server to use our software, or
  • Your office has cloud licensing

 

 

TCP/IP Server text field showing server name

You should see your server name in the TCP/IP Server text field.

 

If you don't see your server name, you'll need to type it here.

 

If you have cloud licensing, type landfx.com

Don't know your server name or whether you have cloud licensing? Ask your IT administrator.

 

Once the TCP/IP Server field contains your correct server name, click Test.

 

 

 

You should see a Connection Successful message almost instantaneously.
.Connection Successful message

If you experience lag time before the Connection Successful window pops up, you most likely have a network connection issue. Follow our steps to Ping Your Server Name.

If the test takes more than a second to show Connection Successful, follow our steps for troubleshooting a slow connection.

 

 

 

 

 

Here's what to do if your office has a Cloud Data installation.

Cloud Data and cloud licensing are separate things. You might have Cloud Data if you have a Single-User or Multi-User installation of our software. Not sure whether you have Cloud Data? Ask your IT administrator.

 

TC/IP Server field

If you have Cloud Data, type landfx.com in the TC/IP Server field. Then click OK.

You do not need to click Test. If you do, you'll see a Connection Failed message. If this happens, don't worry – just type landfx.com in the TCP/IP Server field and click OK.

 

You can close the dialog box when finished.

 

 

Last modified on Apr 20, 2022

Contact

  • Land F/X

Our software tailors AutoCAD to the needs of landscape architects, irrigation designers, and other professionals. We automate your most tedious tasks and ensure accuracy, giving you more time to design.

Log in to landfx.com:

Username:

Password: