sql server - Error connecting to database: MissingPluginException (no implementation found for method connect on channel mssql_c

I am trying to connect my Flutter App to a SQL Server database with using dart plugin mssql_connection, without using any API.

Can anyone tell me why I am getting this error?

Error connecting to database: MissingPluginException (no implementation found for method connect on channel mssql_connection)

import 'package:mssql_connection/mssql_connection.dart';

class DataHelper {
  final MssqlConnection _connection = MssqlConnection.getInstance();

  // Method to connect to the database

  Future<bool> connectToDatabase() async {
    try {
      bool isConnected = await _connection.connect(
        ip: 'iplink',
        port: '1433',
        databaseName: 'dataBaseIMS',
        username: 'datadataBaseIMS',
        password: 'ImSKrwData@123qweDevp',
        timeoutInSeconds: 15,
      );

      if (isConnected) {
        print('Database connected successfully!');
      } else {
        print('Failed to connect to the database.');
      }
      return isConnected;
    } catch (e) {
      print('Error connecting to database: $e');
      return false;
    }
  }

  // Method to execute a query
  Future<String> executeQuery(String query) async {
    try {
      // First, check if the connection is open
      if (await _isConnected()) {
        print("Connection is open, executing query...");
        String result = await _connection.getData(query);
        return result; // Return the query result
      } else {
        print("Database is not connected. Cannot execute query.");
        throw Exception('Database is not connected');
      }
    } catch (e) {
      print('Error executing query: $e');
      return 'Error executing query: $e';
    }
  }

  // Helper method to check if the database is connected
  Future<bool> _isConnected() async {
    try {
      bool isConnected = await _connection.isConnected;
      return isConnected;
    } catch (e) {
      print('Error checking connection status: $e');
      return false;
    }
  }
}

I am trying to connect my Flutter App to a SQL Server database with using dart plugin mssql_connection, without using any API.

Can anyone tell me why I am getting this error?

Error connecting to database: MissingPluginException (no implementation found for method connect on channel mssql_connection)

import 'package:mssql_connection/mssql_connection.dart';

class DataHelper {
  final MssqlConnection _connection = MssqlConnection.getInstance();

  // Method to connect to the database

  Future<bool> connectToDatabase() async {
    try {
      bool isConnected = await _connection.connect(
        ip: 'iplink',
        port: '1433',
        databaseName: 'dataBaseIMS',
        username: 'datadataBaseIMS',
        password: 'ImSKrwData@123qweDevp',
        timeoutInSeconds: 15,
      );

      if (isConnected) {
        print('Database connected successfully!');
      } else {
        print('Failed to connect to the database.');
      }
      return isConnected;
    } catch (e) {
      print('Error connecting to database: $e');
      return false;
    }
  }

  // Method to execute a query
  Future<String> executeQuery(String query) async {
    try {
      // First, check if the connection is open
      if (await _isConnected()) {
        print("Connection is open, executing query...");
        String result = await _connection.getData(query);
        return result; // Return the query result
      } else {
        print("Database is not connected. Cannot execute query.");
        throw Exception('Database is not connected');
      }
    } catch (e) {
      print('Error executing query: $e');
      return 'Error executing query: $e';
    }
  }

  // Helper method to check if the database is connected
  Future<bool> _isConnected() async {
    try {
      bool isConnected = await _connection.isConnected;
      return isConnected;
    } catch (e) {
      print('Error checking connection status: $e');
      return false;
    }
  }
}

• sql-server
• flutter
• dart

Share Improve this question Follow edited Jan 2 at 12:57 marc_s 757k184184 gold badges1.4k1.4k silver badges1.5k1.5k bronze badges asked Jan 2 at 12:34 DevikaDevika 17111 gold badge11 silver badge1212 bronze badges 3

• 1 Please don't add random, completely unrelated tags to your question; it does not help. According to it's wiki flutter is the UI tool, not the language. You should tag the language you are using here, not the UI. – Thom A Commented Jan 2 at 12:37
• @ThomA the plugin documentation says: "The mssql_connection plugin allows Flutter applications to connect...", so that tag is not unrelated and random, and your comment is misguided. – Rudiger W. Commented Jan 7 at 14:51
• "so that tag is not unrelated and random" if you check the revisions, the tags I removed were [mysql] and [.net], not Flutter, @RudigerW. I asked the OP to tag the language as Flutter is an UI according to the tag; Dart was missing from the tags. Are you therefore saying that MySQL is related to the question and Flutter is a .Net programming language? My Google-fu says otherwise, but I don't know about Flutter. – Thom A Commented Jan 7 at 14:59

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

This plugin (mssql_connection) is only for Android, so I assume you're running your code on iOS, which causes the issue

Look at the image, you can see that this package only has android folder, with native Kotlin language, so it doesn't have any Swift code to handle the native method connect on iOS side

If you haven't known about platform-specific code, quickly explain: that some libs need to call to native side (Android & iOS native code) to access some native platform feature, which can't be done in Dart code, and mssql_connection is the one like that