Land F/X
  • Portal
  • Products
    • Design F/X
    • Planting F/X
    • Irrigation F/X
    • F/X CAD
    • Plugin for Revit®
    • Plugin for SketchUp®
    • Lighting
    • Plugin for Rhino®
    • Manufacturer Connection
    • Academic
  • Support
  • Videos
  • Who We Are
  • Trial
  • Purchase
Land F/X
  • Portal
    • Dashboard
    • Account
    • Licenses
    • Data
    • Support
  • Products
    • Design F/X
      • Product
      • Features
      • Trial
      • Purchase
    • Planting F/X
      • Product
      • Features
      • Trial
      • Purchase
    • Irrigation F/X
      • Product
      • Features
      • Trial
      • Purchase
    • F/X CAD
    • Plugin for Revit®
    • Plugin for SketchUp®
    • Plugin for Rhino®
    • Site & Hardscape
    • Lighting
    • Manufacturer Connection
    • Academic
    • Purchase
  • Support
    • Knowledge Base
    • Documentation
    • Submit Ticket
    • Updates
    • Forum
    • Install
    • Remote Assistance
  • Videos
    • Power Tips
    • Webinars
  • Who We Are
    • Contact Us
    • Careers
    • Gallery
    • News
  1. Knowledge Base
  2. Installation Troubleshooting & Errors
  3. MySQL
  4. MySQL Errors and Troubleshooting

Configure the Data Source (ODBC)

This guide will help you configure the ODBC data source.

  • Step 1: Open the ODBC Control Panel
  • Step 2: 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.

 

Windows 11 users

 

1. Open the Windows Start menu and search for ODBC. Select the Open file location option under ODBC Data Sources.

Open file location option under ODBC Data Sources in the Windows Start menu

 

 

 

2. Double-click one of the following files:

  • 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

 

ODBC Data Sources files

 

 

 

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

 

 Close

 

 

Windows 10 users

 

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

 

 Close

 

 

Windows 7 users

 

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.

 

 Close

 

 

 

 

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

 

 

 

Single-User installations

 

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.

 

 Close

 

 

Multi-User installations (office server or Cloud Licensing)

 

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.

 

 

 Close

 

 

Cloud Data installations

 

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.

 

 Close

 

Contact

  • Land F/X
  • PMB 351
    3940 Broad St. STE 7
    San Luis Obispo, CA 93401
  • +1 805-541-1003
Email Logo Facebook Logo Instagram Logo LinkedIn Logo
Land F/X Logo

Our software tailors AutoCAD®, Revit®, SketchUp®, and Rhino® 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.

  • Portal
  • Products
  • Support
  • Videos
  • Who We Are