ODBC link Suitable for database type link mode 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 link type link embodiment suitable database 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.je T.OLEDB.4.0; Data Source = Your_path; Extended Properties'Text; FMT = DELIMITED '"Oracle Database Connection Summary:
ASPX Connect Oracle 8i
Constr = "provider = msdaora.1; user ID = ljc; data source = tttt; password = ***" Alias configured through Oracle7 client
Constr = "provider = oraoledb.racle.1; user ID = ljc; data source = liujincai; password = ***" Alias configured through Oracle8 client
ASP connection Oracle 8i
Constr = "provider = oraoledb.racle.1; user ID = ljc; data source = ljcai; password = ***" Alias constr = "via the alias configured by Oracle8 client =" provider = ljc; data source = TTTT; password = *** "The alias configured through the Oracle7 client, but there will be the case of RecordCount = -1.
Set this RS.CURSORLOCATION = 3 to solve it!
VB Connect Oracle 8iconstr = "Provider = Oraoledb.Oracle.1; User ID = LJC; Data Source = liujincai; Password = ***"
Constr = "provider = msdaora.1; user ID = ljc; data source = tttt; password = ***" Alias configured through Oracle8 client
