AI2sql Docs
Go to AppContact
  • 1. Introduction
    • 1.1. What is AI2SQL?
    • 1.2. Key features of AI2SQL
    • 1.3. How to get started with AI2SQL
    • 1.4. What Users Can Ask AI2SQL
  • 2. AI2SQL Dashboard
    • 2.1. Accessing the dashboard
    • 2.2. Generating SQL based on predefined datasets
    • 2.3. Exploring sample queries and use cases
  • 3. Managing Tables
    • 3.1. Importing tables using DDL
    • 3.2. Manually adding tables
    • 3.3. Editing, Updating, and Deleting Table Information
    • 3.4. Importing Database Schema via CSV
  • 4. AI2SQL Workspace
    • 4.1. Navigating the workspace
    • 4.2. Generating SQL for specific database engines
    • 4.3. Selecting tables for SQL generation
    • 4.4. Saving and organizing queries in the workspace
  • 5. Formatting SQL
    • 5.1. Accessing the SQL formatter
    • 5.2. Customizing formatting options
    • 5.3. Applying formatting to your SQL queries
  • 6. SQL Fixer
    • 6.1. Identifying SQL errors with SQL Fixer
    • 6.2. Understanding common SQL error messages
    • 6.3. Resolving SQL errors using AI2SQL's suggestions
    • 6.4. Handling Long SQL Queries
  • 7. Formula Generator
    • 7.1. Overview of Formula Generator
    • 7.2. Excel, Google Sheets, and regex formula translation
    • 7.3. Power BI DAX formula translation
    • 7.4. Airtable formula translation
    • 7.5. Using Formula Generator to enhance SQL queries
  • 8. CSV Analyzer
  • 9. Database Connectors
    • 9.1. Supported database connectors
    • 9.2. Setting up database connections (MySQL, SQL Server, or PostgreSQL)
    • 9.2.1. AI2sql Oracle Cloud Connector
    • 9.3. Setting up MongoDB Connectors
    • 9.4. Google BigQuery Setup and Service Account Key Creation
    • 9.5. Generating SQL queries for connected databases
    • 9.6. Setting up Snowflake Connectors
    • 9.7. Troubleshooting AI2sql Connector Issues: A Comprehensive Checklist
    • 9.8. Requesting new database connectors
    • 9.9. System Security Overview
  • 10. Dataset Questions Generation
  • 11. AI2SQL ChatGPT Plugin User Guide
    • 11.1. Introduction
    • 11.2. Getting Started
    • 11.3. Obtaining Your Token
    • 11.4. Using Your Token
    • 11.5. Connecting Your MSSQL (SQL Server) Database
    • 11.6. Connecting Your MySQL Database
    • 11.7. Connecting Your PostgreSQL Database
    • 11.8. Generating SQL Queries
    • 11.9. Troubleshooting
  • 12. Troubleshooting and Support
    • 9.1. Common issues and solutions
    • 12.2. Chat Support
    • 12.3. Contacting AI2SQL support
    • 12.4. Community resources and forums
  • 13. Templates
    • 13.1. Custom Template Creation
    • 13.2. Save the Template
    • 13.3. Generate SQL Using Template
  • 14. AI2sql: SQL Generation from Database ER Diagrams
    • 14.1. Introduction
    • 14.2. SQL Generation Process
    • 14.3. Troubleshooting & FAQs
  • 15. AI2sql API Integration
  • 16. AI2SQL Dictionary Template
  • 17. AI2sql GPTs
    • 17.1. Getting Started
    • 17.2. Obtaining Your Token
    • 17.3. Connecting Your MySQL Database
  • 18. Connecting Your Local Database
  • 19. SQL File Uploader
    • 19.1 Generating SQL queries
Powered by GitBook
On this page
  • 1. Verify your database credentials
  • 2. Check your database server
  • 3. Confirm the AI2sql connector compatibility
  • 4. Examine your configuration settings
  • 5. Inspect your firewall settings
  • 6. Check database firewall and reachable address
  • 7. Review your error logs
  1. 9. Database Connectors

9.7. Troubleshooting AI2sql Connector Issues: A Comprehensive Checklist

Follow this comprehensive checklist to ensure that your AI2sql connector settings are correctly configured and resolve any issues you may encounter while connecting to your database.

1. Verify your database credentials

  • Ensure that the username, password, and host address are correct and up-to-date.

  • Confirm that your user account has the necessary privileges to access the database.

2. Check your database server

  • Verify that your database server is up and running.

  • Ensure that your database server is not experiencing any network issues or undergoing maintenance.

3. Confirm the AI2sql connector compatibility

  • Make sure you are using the correct AI2sql connector that is compatible with your specific database (e.g., MySQL, PostgreSQL, SQL Server.).

  • Update the connector to the latest version if needed.

4. Examine your configuration settings

  • Revisit your AI2sql configuration settings and ensure that they are correct.

  • Double-check the connection string or URL for any typos or incorrect values.

  • Use the IP address instead of the DNS name when entering the host address.

5. Inspect your firewall settings

  • Verify that your firewall is not blocking the AI2sql connector's access to your database server.

  • Add the AI2sql connector's IPs to your firewall's whitelist, if necessary. (52.151.220.65,52.151.220.76,52.151.220.92,52.151.220.113,52.151.220.203,52.151.220.211,20.119.16.24)

6. Check database firewall and reachable address

  • Ensure that the database firewall settings are not preventing access to the server.

  • Confirm that the address entered is correct and reachable from the client machine.

7. Review your error logs

  • Carefully review the error logs to identify any specific issues or error codes.

  • Search for solutions to the specific error codes you find, or reach out to our support team with the error details.

Previous9.6. Setting up Snowflake ConnectorsNext9.8. Requesting new database connectors

Last updated 1 year ago

If you have gone through the checklist and are still experiencing issues, please contact our support team at with the details of the problem, including any error messages or logs. Our team will be more than happy to assist you in resolving the issue.

Note: If the direct connection to your database does not work for you, as an alternative, you can add your DDL (Data Definition Language) script to AI2sql. This way, you can still use our platform to generate SQL queries without directly connecting to your database. Follow the guide below to learn how to add your DDL script to AI2sql:

support@ai2sql.io
https://ai2sql.gitbook.io/ai2sql/3.-managing-tables/3.1.-importing-tables-using-ddl