clear100-com
asked on
Syntax issues...
Why is this not working??? Im trying to convert this: https://www.experts-exchange.com/questions/21253647/ADO-NET-using-mySQL-as-a-connection.html (VB.NET) to this...
using System;
using System.Collections.Generic ;
using System.Text;
namespace ConsoleApplication1
{
class Program
{
private System.Data.Odbc.OdbcConne ction mconnCurrent;
private const string mstrServerName = "localhost";
private const string mstrUsername = "root";
private const string mstrPassword = "wd006451";
static void Main(string[] args)
{
string sqlSelect;
System.Data.Odbc.OdbcDataA dapter com;
System.Data.Odbc.OdbcComma nd queryCom;
System.Data.DataSet ds;
string strConn;
string strDBName;
strDBName = "test";
strConn = "DRIVER={MySQL ODBC 3.51 Driver}" +
";SERVER=" + mstrServerName +
";DATABASE=" + strDBName +
";UID=" + mstrUsername +
";PWD=" + mstrPassword +
";OPTION=3";
this.mconnCurrent = new System.Data.Odbc.OdbcConne ction(strC onn);
this.mconnCurrent.Open();
}
}
}
using System;
using System.Collections.Generic
using System.Text;
namespace ConsoleApplication1
{
class Program
{
private System.Data.Odbc.OdbcConne
private const string mstrServerName = "localhost";
private const string mstrUsername = "root";
private const string mstrPassword = "wd006451";
static void Main(string[] args)
{
string sqlSelect;
System.Data.Odbc.OdbcDataA
System.Data.Odbc.OdbcComma
System.Data.DataSet ds;
string strConn;
string strDBName;
strDBName = "test";
strConn = "DRIVER={MySQL ODBC 3.51 Driver}" +
";SERVER=" + mstrServerName +
";DATABASE=" + strDBName +
";UID=" + mstrUsername +
";PWD=" + mstrPassword +
";OPTION=3";
this.mconnCurrent = new System.Data.Odbc.OdbcConne
this.mconnCurrent.Open();
}
}
}
Could you be more specific on what your problem is? What do you mean by "not working"?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.