日期:2014-05-18  浏览次数:20521 次

紧急求救
访问ODBC数据:
Provider=MSDASQL;DSN=dsnName;UID=userName;PWD=userPassword;
访问ORACLE数据库:
Provider=MSDAORA;Data   Source=serverName;User   ID=userName;   Password=userPassword;
访问MS   SQL数据库:
Provider=SQLOLEDB;Data   Source=serverName;Initial   Catalog=databaseName;   User   ID=userName;Password=userPassword;
访问ACCESS   数据库:
Provider=Microsoft.Jet.OLEDB.4.0;Data   Source=databaseName;User   ID=userName;Password=userPassword;

如果要访问FOXPRO的数据库应是什么呢?谢谢

------解决方案--------------------
DBF / FoxPro
ODBC

standard:
"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath; "

OLEDB, OleDbConnection (.NET)

standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password= "

OLEDB, OleDbConnection (.NET)

standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password= "


standard:
"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath; "


standard:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password= "

不知道楼主用哪一种数据连接,只好都贴出来了。自己试试吧``