Connecting to database using ODBC DSN file (C#)
This is how I do it but its not working

     public static void Connect()
        {
            if (null == connection)
            {
                //connection = new OdbcConnection("DSN=PrismServerReportViewerDSN;");
                connection = new OdbcConnection("FILEDSN=c:\test123.dsn;");
            }

            if (connection.State != ConnectionState.Open)
            {
                connection.Open();
            }
        }

However if I change the connection to system dsn, it works, for example

    connection = new OdbcConnection("DSN=test123;");


This is how my dsn file looks like and I save it in C:/test123.dsn

    [ODBC]
    DRIVER=MySQL ODBC 5.1 Driver
    UID=root
    PORT=3306
    DATABASE=db_name
    SERVER=localhost


I still need to use the 'filedns' type. Point me my mistake please .. :)
Connecting to database using ODBC DSN file (C#)
===

This is how I do it but its not working

     public static void Connect()
        {
            if (null == connection)
            {
                //connection = new OdbcConnection("DSN=PrismServerReportViewerDSN;");
                connection = new OdbcConnection("FILEDSN=c:\test123.dsn;");
            }

            if (connection.State != ConnectionState.Open)
            {
                connection.Open();
            }
        }

However if I change the connection to system dsn, it works, for example

    connection = new OdbcConnection("DSN=test123;");


This is how my dsn file looks like and I save it in C:/test123.dsn

    [ODBC]
    DRIVER=MySQL ODBC 5.1 Driver
    UID=root
    PORT=3306
    DATABASE=db_name
    SERVER=localhost


I still need to use the 'filedns' type. Point me my mistake please .. :)