![Antiguo](http://static.forosdelweb.com/fdwtheme/images/statusicon/post_old.gif)
20/10/2004, 15:28
|
![Avatar de GeoAvila](http://static.forosdelweb.com/customavatars/avatar50035_15.gif) | Colaborador | | Fecha de Ingreso: diciembre-2003 Ubicación: Antigua Guatemala
Mensajes: 4.032
Antigüedad: 20 años, 8 meses Puntos: 53 | |
Tipos de Conexiones a Bases de Datos en Visual Basic Pregunta :
Tipos de Conexiones a Bases de Datos en Visual Basic
Respuesta:
Bueno por alli yo investigando he econtrado estos tipos de conexiones
SQL Server
ODBC Standard Security: "Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asda sd;" Trusted connection: "Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connect ion=yes;" Prompt for username and password: oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"
Access
ODBC Standard Security: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;" Workgroup: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatab ase.mdw;" Exclusive: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=adm in;Pwd="
Oracle
ODBC New version: "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;Uid=Username;Pwd =asdasd;" Old version: "Driver={Microsoft ODBC Driver for Oracle};ConnectString=OracleServer.world;Uid=myUse rname;Pwd=myPassword;"
MySQL
ODBC Local database: "Driver={mySQL};Server=mySrvName;Option=16834;Data base=mydatabase;" Remote database: "Driver={mySQL};Server=data.domain.com;Port=3306;O ption=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"
Interbase
ODBC, Easysoft Local computer: "Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:C:\mydat abase.gdb;Uid=username;Pwd=password" Remote Computer: "Driver={Easysoft IB6 ODBC};Server=ComputerName;Database=ComputerName:C: \mydatabase.gdb;Uid=username;Pwd=password"
ODBC, Intersolv Local computer: "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=localhost;Database=localhost:C:\my database.gdb;Uid=username;Pwd=password" Remote Computer: "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};Server=ComputerName;Database=ComputerName :C:\mydatabase.gdb;Uid=username;Pwd=password"
Sybase
ODBC Standard Sybase System 12 (or 12.5) Enterprise Open Client: "Driver={SYBASE ASE ODBC Driver};Srvr=Aron1;Uid=username;Pwd=password" Standard Sybase System 11: "Driver={SYBASE SYSTEM 11};Srvr=Aron1;Uid=username;Pwd=password;" Intersolv 3.10: "Driver={INTERSOLV 3.10 32-BIT Sybase};Srvr=Aron1;Uid=username;Pwd=password;" Sybase SQL Anywhere (former Watcom SQL ODBC driver): "ODBC; Driver=Sybase SQL Anywhere 5.0; DefaultDir=c:\dbfolder\;Dbf=c:\mydatabase.db;Uid=u sername;Pwd=password;Dsn=""""" Informix
ODBC Informix 3.30: "Dsn='';Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myserver;Service=service-name;Protocol=olsoctcp;Database=mydb;UID=username; PWD=myPwd Informix-CLI 2.5: "Driver={Informix-CLI 2.5 (32 Bit)};Server=myserver;Database=mydb;Uid=username;P wd=myPwd"
Mimer SQL
ODBC Standard Security: "Driver={MIMER};Database=mydb;Uid=myuser;Pwd=mypw; " Prompt for username and password: "Driver={MIMER};Database=mydb;"
DSN
ODBC DSN: "DSN=myDsn;Uid=username;Pwd=;" File DSN: "FILEDSN=c:\myData.dsn;Uid=username;Pwd=;"
Excel
ODBC Standard: "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=C:\MyExcel.xls;DefaultDi r=c:\mypath;"
Text
ODBC Standard: "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv, tab,txt;"
DBF / FoxPro
ODBC standard: "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"
Visual FoxPro
ODBC Database container (.DBC): "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exc lusive=No;Collate=Machine;" Free Table directory: "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;E xclusive=No;Collate=Machine;"
Pervasive
ODBC Standard: "Driver={Pervasive ODBC Client Interface};ServerName=srvname;dbq=@dbname"
OLE DB Standard: "Provider=PervasiveOLEDB;Data Source=C:\path"
UDL
UDL UDL: "File Name=c:\myDataLink.udl;"
__________________ * Antes de preguntar lee las FAQ, y por favor no hagas preguntas en las FAQ
Sitio http://www.geoavila.com twitter: @GeoAvila
Última edición por GeoAvila; 20/10/2004 a las 15:39 |