不用设置ODBC的DSN的,上次我设置了,但是我刚才把DSN删除了,也正常运行的 using System; using System.Data.Odbc;namespace Paradox { class Program { public static void Main(string[] args) { Console.WriteLine("Getting Data...");
GetData(); Console.Write("Press any key to continue . . . "); Console.ReadKey(true); }
static string strConn = @"Driver={Microsoft Paradox Driver (*.db )};UID=;Pwd=;DriverID=538;Fil=Paradox 5.X;DefaultDir=C:\Paradox;Dbq=C:\Paradox;CollatingSequence=ASCII;"; static string strSQL = "SELECT TOP 10 * FROM Patient1"; public static void GetData() { using (OdbcConnection conn = new OdbcConnection(strConn)) { try { OdbcCommand cmd = new OdbcCommand(strSQL, conn); conn.Open(); OdbcDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { Console.WriteLine( "{0}\t{1}\t{2}", reader.GetString(0).ToString(), reader.GetString(1).ToString(), reader.GetString(2).ToString() ); } } else { System.Diagnostics.Debug.Print("No rows found."); } reader.Close(); } catch (Exception ex) { Console.WriteLine(ex.Message); } // The connection is automatically closed when the // code exits the using block. } } } }
我看你设置的是用户DSN,在"ODBC数据源管理器"中,设置用于连接数据库的DSN有三种: 用户DSN、系统DSN和文件DSN.你改成系统DSN试试看。如果还有问题告诉我一下。
我看你设置的是用户DSN,在"ODBC数据源管理器"中,设置用于连接数据库的DSN有三种: 用户DSN、系统DSN和文件DSN.你改成系统DSN试试看。如果还有问题告诉我一下。
还是不行,错误是一样的,不晓得什么问题。
using System;
using System.Data.Odbc;namespace Paradox
{
class Program
{
public static void Main(string[] args)
{
Console.WriteLine("Getting Data...");
GetData();
Console.Write("Press any key to continue . . . ");
Console.ReadKey(true);
}
static string strConn = @"Driver={Microsoft Paradox Driver (*.db )};UID=;Pwd=;DriverID=538;Fil=Paradox 5.X;DefaultDir=C:\Paradox;Dbq=C:\Paradox;CollatingSequence=ASCII;";
static string strSQL = "SELECT TOP 10 * FROM Patient1";
public static void GetData()
{
using (OdbcConnection conn = new OdbcConnection(strConn))
{
try
{
OdbcCommand cmd = new OdbcCommand(strSQL, conn);
conn.Open(); OdbcDataReader reader = cmd.ExecuteReader(); if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine(
"{0}\t{1}\t{2}",
reader.GetString(0).ToString(),
reader.GetString(1).ToString(),
reader.GetString(2).ToString()
);
}
}
else
{
System.Diagnostics.Debug.Print("No rows found.");
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
// The connection is automatically closed when the
// code exits the using block.
}
}
}
}