读书人

紧急求救,该如何解决

发布时间: 2012-04-15 18:39:21 作者: rapoo

紧急求救
访问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= "

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

读书人网 >SQL Server

热点推荐