◎ODBC链接 适合数据库类型链接方式 ...... ODBC链接 适合数据库类型 链接方式 access "Driver={microsoft access driver(*.mdb)};dbq=*.mdb;uid=admin;pwd=pass;" dBase "Driver={microsoft dbase driver(*.dbf)};driverid=277;dbq=------------;" Oracle "Driver={microsoft odbc for oracle};server=oraclesever.world;uid=admin;pwd=pass;" MSSQL server "Driver={sql server};server=servername;database=dbname;uid=sa;pwd=pass;" MS text "Driver={microsoft text driver(*.txt; *.csv)};dbq=-----;extensions=asc,csv,tab,txt;Persist SecurityInfo=false;" Visual Foxpro "Driver={microsoft Visual Foxpro driver};sourcetype=DBC;sourceDB=*.dbc;Exclusive=No;" MySQL "Driver={mysql};database=yourdatabase;uid=username;pwd=yourpassword;option=16386;" OLEDB链接 适合的数据库类型 链接方式 access "Provider=microsoft.jet.oledb.4.0;data source=your_database_path;user id=admin;password=pass;" Oracle "Provider=OraOLEDB.Oracle;data source=dbname;user id=admin;password=pass;" MS SQL Server "Provider=SQLOLEDB;data source=machinename;initial catalog=dbname;userid=sa;password=pass;" MS text "Provider=microsof.jet.oledb.4.0;data source=your_path;Extended Properties′text;FMT=Delimited′" oracle数据库连接总结: aspx 连接 oracle 8i constr ="Provider=MSDAORA.1;User ID=ljc;Data Source=tttt;Password=***" 通过 oracle7客户端配置的别名 constr ="Provider=OraOLEDB.Oracle.1;User ID=ljc;Data Source=liujincai;Password=***" 通过 oracle8客户端配置的别名 asp 连接 oracle 8i constr ="Provider=OraOLEDB.Oracle.1;User ID=ljc;Data Source=liujincai;Password=***" 通过 oracle8客户端配置的别名 constr ="Provider=MSDAORA.1;User ID=ljc;Data Source=tttt;Password=***" 通过 oracle7客户端配置的别名,但是会有recordcount=-1的情况。 设置这个 rs.CursorLocation=3 就能解决! vb 连接 oracle 8i constr ="Provider=OraOLEDB.Oracle.1;User ID=ljc;Data Source=liujincai;Password=***" constr ="Provider=MSDAORA.1;User ID=ljc;Data Source=tttt;Password=***" 都通过 oracle8客户端配置的别名 |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-30 01:42 , Processed in 0.162818 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.