紧急求救
访问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= "
不知道楼主用哪一种数据连接,只好都贴出来了。自己试试吧``