如何清除odbc连接中的错误 [英] How can I clear the error in odbc connection

问题描述

海，


我有一些编码可以将其连接到演播提示器odbcdriver.但是在连接演播提示器时遇到错误，请清除它.

Hai,


I have some coding to connect it into tally odbcdriver.But I am getting an error while connecting into tally.Please clear it.

private void Form1_Load(object sender, EventArgs e)
       {
           string query = "SELECT Company.`$_DBName`, Company.`$_ThisYearBeg`, Company.`$_ThisYearEnd`, Company.`$_PrevYearBeg`, Company.`$_PrevYearEnd`, Company.`$_ThisQuarterBeg`, Company.`$_ThisQuarterEnd`, Company.`$_PrevQuarterBeg`, Company.`$_PrevQuarterEnd`, Company.`$_Name`, Company.`$_Address1`, Company.`$_Address2`, Company.`$_Address3`, Company.`$_Address4`, Company.`$_Address5` FROM Techweb.TallyUser.Company Company ORDER BY Company.`$_DBName`";
           string source = "Dsn=tally;uid=sa;password=sa;app=Microsoft® Visual Studio® 2008;wsid=SLNN-207";
           OdbcConnection con = new OdbcConnection(source);
           OdbcCommand cmd = new OdbcCommand(query, con);
           con.Open();---->In this line i am getting error.


           //ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver] Cannot open

          database ''(unknown)''.  It may not be a database that your application
          recognizes, or the file may be corrupt.//

          //ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid
         connection string attribute password //


           OdbcDataAdapter da = new OdbcDataAdapter(query, con);
           DataTable dt = new DataTable("table1");
           da.Fill(dt);
           dataGridView1.DataSource = dt;
           dataGridView1.DataMember = "table1";
           con.Close();
       }

推荐答案

_DBName`，Company.`

_DBName`, Company.`

_ThisYearBeg`，Company.

_ThisYearBeg`, Company.`

_ThisYearEnd`，公司.

_ThisYearEnd`, Company.`

这篇关于如何清除odbc连接中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！