常用ODBC连接字符串

最新推荐文章于 2024-10-14 15:12:45 发布
最新推荐文章于 2024-10-14 15:12:45 发布
阅读量862 收藏
点赞数
文章标签： 数据库 网络
原文链接：http://www.cnblogs.com/Dageking/archive/2013/03/13/2957337.html
版权

常用ODBC连接字符串

http://www.carlprothman.net/Technology/ConnectionStrings/ODBCDSNLess/tabid/90/Default.aspx

  • ODBC Driver for Access

For Standard Security:

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ 
           "Dbq=c:\somepath\mydb.mdb;"

If you are using a Workgroup (System database):

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ 
           "Dbq=c:\somepath\mydb.mdb;" & _
           "SystemDB=c:\somepath\mydb.mdw;", _
           "myUsername", "myPassword"

If want to open up the MDB exclusively

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
           "Dbq=c:\somepath\mydb.mdb;" & _
           "Exclusive=1;"

If MDB is located on a Network Share

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
           "Dbq=\\myServer\myShare\myPath\myDb.mdb;"

If MDB is located on a remote machine

- Call an XML Web Service that contains data access web methods for MDB
- Or upgrade to SQL Server and use an IP connection string

If you don't know the path to the MDB (using ASP)

<%  ' ASP server-side code
oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
           "Dbq=" & Server.MapPath(".") & "\db\myDb.mdb;"
%>

Make sure the Web identity has read/write permissions to the directory 
the MDB is located in. e.g. "db" would need the read/write permissions. 

If you don't know the path to the MDB (using VB)

oConn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
           "Dbq=" & App.Path & "\myDb.mdb;" 
This assumes the MDB is in the same directory where the application is running.

For more information, see: Microsoft Access Driver Programming Considerations

To view Microsoft KB articles related to Microsoft Access Driver, click here

  • ODBC Driver for AS/400 (from IBM)
oConn.Open "Driver={Client Access ODBC Driver (32-bit)};" & _
           "System=myAS400;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

For more information, see: A Fast Path to AS/400 Client/Server

  • ODBC Driver for dBASE
oConn.Open "Driver={Microsoft dBASE Driver (*.dbf)};" & _
           "DriverID=277;" & _
           "Dbq=c:\somepath"

Then specify the filename in the SQL statement:

oRs.Open "Select * From user.dbf", oConn, , ,adCmdText

Note: MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update dBase DBF files. (Q238431).

For more information, see: dBASE Driver Programming Considerations

To view Microsoft KB articles related to Microsoft dBASE Driver, click here

  • ODBC Driver for Excel
oConn.Open "Driver={Microsoft Excel Driver (*.xls)};" & _
           "DriverId=790;" & _
           "Dbq=c:\somepath\mySpreadsheet.xls;" & _
           "DefaultDir=c:\somepath"

For more information, see: Microsoft Excel Driver Programming Considerations

To view Microsoft KB articles related to Microsoft Excel Driver, click here

  • ODBC Driver for Informix

If using INFORMIX 3.30 ODBC Driver

oConn.Open "Dsn='';" & _
           "Driver={INFORMIX 3.30 32 BIT};" & _
           "Host=myHostname;" & _
           "Server=myServerName;" & _
           "Service=myServiceName;" & _
           "Protocol=olsoctcp;" & _
           "Database=myDbName;" & _
           "UID=myUsername;" & _
           "PWD=myPassword" & _

' Or
oConn.Open "Dsn=myDsn;" & _
           "Host=myHostname;" & _
           "Server=myServerName;" & _
           "Service=myServiceName;" & _
           "Protocol=onsoctcp;" & _
           "Database=myDbName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

If using INFORMIX-CLI 2.5 ODBC Driver

oConn.Open "Driver={Informix-CLI 2.5 (32 Bit)};" & _
           "Server=myServerName;" & _
           "Database=myDbName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword" & _

For more information, see: Informix Developer Zone, Connection to ODBC Data Source,

  • ODBC Driver for Interbase - from Easysoft

For the local machine

oConn.Open "Driver={Easysoft IB6 ODBC};" & _
           "Server=localhost;" & _
           "Database=localhost:C:\Home\Data\Mydb.gdb;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

For a remote machine

oConn.Open "Driver={Easysoft IB6 ODBC};" & _
           "Server=myMachineName;" & _
           "Database=myMachineName:C:\Home\Data\Mydb.gdb;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

For more information, see: Connecting to InterBase and Easysoft

  • ODBC Driver for Interbase - from InterSolv

For the local machine

oConn.Open "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};" & _
           "Server=localhost;" & _
           "Database=localhost:C:\Home\Data\Mydb.gdb;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

For a remote machine

oConn.Open "Driver={INTERSOLV InterBase ODBC Driver (*.gdb)};" & _
           "Server=myMachineName;" & _
           "Database=myMachineName:C:\Home\Data\Mydb.gdb;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

For more information, see: Google Search (if you know a direct URL email me)

  • ODBC Driver for Lotus Notes
oConn.Open "Driver={Lotus NotesSQL 3.01 (32-bit) ODBC DRIVER (*.nsf)};" & _
           "Server=myServerName;" & _
           "Database=mydir\myDbName.nsf;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword" & _

For more information, see: Connection keywords

  • ODBC Driver for Mimer
oConn.Open "Driver={MIMER};" & _
           "Database=myDatabaseName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

For more information, see: Opening a Connection

  • ODBC Driver for MySQL (via MyODBC)

To connect to a local database (using MyODBC Driver)

oConn.Open "Driver={mySQL};" & _ 
           "Server=MyServerName;" & _
           "Option=16834;" & _
           "Database=mydb"

To connect to a remote database

oConn.Open "Driver={mySQL};" & _ 
           "Server=db1.database.com;" & _
           "Port=3306;" & _
           "Option=131072;" & _
           "Stmt=;" & _
           "Database=mydb;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

To connect to a local database (using MySQL ODBC 3.51 Driver)

oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};" & _
           "Server=myServerName;" & _
           "Port=3306;" & _
           "Option=16384;" & _
           "Stmt=;" & _
           "Database=mydatabaseName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"
Or
oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=myServerName;" & _
"DATABASE=myDatabaseName;" & _
"USER=myUsername;" & _
"PASSWORD=myPassword;"

Note: When you first install MySQL, it creates a "root" user account (in the sys datbase's user table) with a blank password.

For more information, see: Programs Known to Work with MyODBC

  • ODBC Driver for Oracle - from Microsoft

For the current Oracle ODBC Driver from Microsoft

oConn.Open "Driver={Microsoft ODBC for Oracle};" & _
           "Server=OracleServer.world;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

For the older Oracle ODBC Driver from Microsoft

oConn.Open "Driver={Microsoft ODBC Driver for Oracle};" & _
           "ConnectString=OracleServer.world;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

For more information, see: Connection String Format and Attributes

To view Microsoft KB articles related to Microsoft ODBC for Oracle, click here

  • ODBC Driver for Oracle - from Oracle
oConn.Open "Driver={Oracle ODBC Driver};" & _
           "Dbq=myDBName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

Where: The DBQ name must be defined in the tnsnames.ora file

For more information, see: Oracle8 ODBC Driver Help, Oracle ODBC FAQs, [asporacle] listserv FAQs, and ASPDB Oracle

  • ODBC Driver for Oracle Rdb
oConn.Open "Driver={Oracle ODBC Driver for Rdb};" & _
           "UID=myUserID;" & _
           "PWD=myPassword;" & _
           "SVR=aServerName;" & _
           "XPT=2;" & _
           "DATABASE=Attach 'filename disk:[dir1.dir2]rootfile';" & _
           "CLS=aClassName;" & _
           "DBA=W;" & _
           "CSO=1;" & _
           "TLL=aLibName;" & _
           "TLO=0;" & _
           "DSO=0;" & _
           "PWV=secPassword"

For connecting to a database over TCP/IP, 
not using a specific SQL/Services class:

oConn.Open "Driver={Oracle ODBC Driver for Rdb};" & _
           "UID=myUserID;" & _
           "PWD=myPassword;" & _
           "SVR=aServerName;" & _
           "XPT=2;" & _ 
           "DATABASE=Attach 'filename disk:[dir1.dir2]rootfile'"

For connecting to a database over DECNET using a specific class, 
not using pre-attached connection:

oConn.Open "Driver={Oracle ODBC Driver for Rdb};" & _
           "UID=myUserID;" & _
           "PWD=myPassword;" & _
           "SVR=aServerName;" & _
           "XPT=1;" & _
           "DATABASE=Attach 'filename disk:[dir1.dir2]rootfile';" & _
           "CLS=aClassName"

For connecting to a database over TCP/IP through a class 
that uses pre-attached connections:

oConn.Open "Driver={Oracle ODBC Driver for Rdb};" & _
           "UID=myUserID;" & _
           "PWD=myPassword;" & _
           "SVR=aServerName;" & _
           "XPT=2;" & _
           "CLS=aClassName"

For more information, see: Oracle ODBC Driver for Rdb

  • ODBC Driver for Paradox
oConn.Open "Driver={Microsoft Paradox Driver (*.db )};" & _
           "DriverID=538;" & _
           "Fil=Paradox 5.X;" & _
           "DefaultDir=c:\dbpath\;" & _
           "Dbq=c:\dbpath\;" & _
           "CollatingSequence=ASCII"

Note: MDAC 2.1 (or greater) requires the Borland Database Engine (BDE) to update Paradox ISAM fDBF files. (Q230126).

Note: There is an extra space after "db" in the Paradox Driver name

For more information, see: Paradox Driver Programming Considerations

To view Microsoft KB articles related to Microsoft Paradox Driver, click here

  • ODBC Driver for SQL Server
Using the newer SQL Native Client driver (for SQL Server 2005) 

For Standard Security 
oConn.Open "ODBC;Driver={SQL Native Client};" &
           "Server=MyServerName;" & _
           "Database=myDatabaseName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"
For Trusted Connection Security 
oConn.Open "ODBC;Driver={SQL Native Client};" & _
           "Server=MyServerName;" & _
           "Database=myDatabaseName;" & _
           "Trusted_Connection=yes"
Using the MDAC ODBC Driver 

For Standard Security 
oConn.Open "Driver={SQL Server};" &
           "Server=MyServerName;" & _
           "Database=myDatabaseName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"
For Trusted Connection Security 
oConn.Open "Driver={SQL Server};" &
           "Server=MyServerName;" & _
           "Database=myDatabaseName;" & _
           "Trusted_Connection=yes"

To connect to SQL Server running on a remote computer (via an IP address)

oConn.Open "Driver={SQL Server};" & _
           "Server=xxx.xxx.xxx.xxx;" & _
           "Address=xxx.xxx.xxx.xxx,1433;" & _
           "Network=DBMSSOCN;" & _
           "Database=myDatabaseName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

Where:
- xxx.xxx.xxx.xxx is an IP address
- 1433 is the default port number for SQL Server.
- "Network=DBMSSOCN" tells ODBC to use TCP/IP rather than Named 
Pipes (Q238949)

For more information, see: SQLDriverConnect (ODBC)

To view Microsoft KB articles related to ODBC Driver for SQL Server, click here

  • ODBC Driver for Sybase

If using the Sybase System 12 (or 12.5) Enterprise Open Client ODBC Driver

oConn.Open "Driver={SYBASE ASE ODBC Driver};" & _
           "Srvr=myServerName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

If using the Sybase System 11 ODBC Driver

oConn.Open "Driver={SYBASE SYSTEM 11};" & _
           "Srvr=myServerName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

If using the Intersolv 3.10 Sybase ODBC Driver

oConn.Open "Driver={INTERSOLV 3.10 32-BIT Sybase};" & _
           "Srvr=myServerName;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword"

For more information, see: Sybase System 10 ODBC Driver Reference Guide

To view Microsoft KB articles related to ODBC Driver for Sybase, click here

  • ODBC Driver for Sybase SQL Anywhere
oConn.Open "ODBC; Driver=Sybase SQL Anywhere 5.0;" & _
           "DefaultDir=c:\dbpath\;" & _
           "Dbf=c:\sqlany50\mydb.db;" & _
           "Uid=myUsername;" & _
           "Pwd=myPassword;" & _
           "Dsn="""""

Note: Including the DSN tag with a null string is absolutely critical or else you get the dreaded -7778 error.

For more information, see: Sybase SQL Anywhere User Guide

  • ODBC Driver for Teradata
oConn.Open "Provider=Teradata;" & _
           "DBCName=MyDbcName;" & _ 
           "Database=MyDatabaseName;" & _ 
           "Uid=myUsername;" & _
           "Pwd=myPassword"

For more information, see Teradata ODBC Driver

  • ODBC Driver for Text
oConn.Open _
    "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
    "Dbq=c:\somepath\;" & _
    "Extensions=asc,csv,tab,txt"

Then specify the filename in the SQL statement:

oRs.Open "Select * From customer.csv", _
         oConn, adOpenStatic, adLockReadOnly, adCmdText

Note: If you are using a Tab delimited file, then make sure you create a schema.ini file, and include the "Format=TabDelimited" option.

For more information, see: Text File Driver Programming Considerations

To view Microsoft KB articles related to Microsoft Text Driver, click here

  • ODBC Driver for Visual FoxPro

With a database container

oConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
           "SourceType=DBC;" & _
           "SourceDB=c:\somepath\mySourceDb.dbc;" & _
           "Exclusive=No"

Without a database container (Free Table Directory)

oConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
           "SourceType=DBF;" & _
           "SourceDB=c:\somepath\mySourceDbFolder;" & _
           "Exclusive=No"

转载于:https://www.cnblogs.com/Dageking/archive/2013/03/13/2957337.html

weixin_33966095
关注
jdbc-odbc桥数据库连接及jdbc和odbc连接字符串.doc
04-11
jdbc-odbc桥数据库连接工作原理,JDBC-ODBC所用的配置及jdbc和odbc连接字符串 示例代码
常用JDBC驱动与连接字符串整理.docx
05-18
在实际应用中，我们需要选择合适的JDBC驱动并构造正确的连接字符串来建立与数据库的连接。以下是对不同数据库的JDBC驱动和连接字符串的详解： 1. MySQL： - 驱动类：`com.mysql.jdbc.Driver` - 连接字符串的基本...
ODBC和OLEDB的连接字符串
HenryWang
01-08 1万+
ODBC连接适合数据库类型 连接方式access  "Driver={microsoft access driver(*.mdb)};dbq=*.mdb;uid=admin;pwd=pass;"dBase  "Driver={microsoft dbase driver(*.dbf)};driverid=277;dbq=------------;"oracle  "Driver={microsof
oracle配置odbc
最新发布
weixin_64723674的博客
10-14 577
64位操作系统点击，C盘windows下的SYSWOW64,查找“odbcad32”1.9.3选择Oracle in OraDb11g_home1，点击“完成”。32位操作系统点击“开始”“运行”输入“odbcad32”或者“yyyy-mm-dd hh24:mi:ss”回车，回车输入“YYYY-MM-DD HH24:MI:SS。1.8.4输入“NLS_DATE_FORMAT”，在右侧点击右键，“新建，字符串值”。1.9.5点击“确定”，完成配置。1.9.2选择系统DSN，添加。64位oracle目录如图。
odbc连接字符串
kuoquan6492的博客
10-18 3972
原文链接：http://www.cnblogs.com/mattins/archive/2011/06/07/2074029.html access  "Driver={microsoft access driver(*.mdb)};dbq=*.mdb;uid=admin;pwd=pass;" dBase  "Driver={microsoft dbase driver(*.dbf)};dri...
ODBC连接字符串
fifbro的博客
12-09 1795
转自：http://www.cnblogs.com/mattins/archive/2011/06/07/2074029.html access  "Driver={microsoft access driver(*.mdb)};dbq=*.mdb;uid=admin;pwd=pass;" dBase  "Driver={microsoft dbase driver(*.d
[转]ODBC连接字符串大全(SQL SERVER 2000)
comhaqs的专栏
02-28 3999
原帖地址：http://www.connectionstrings.com/sql-server    Connection strings for SQL Server 2000, 7.0 .NET Framework Data Provider for SQL Server Type .NET Framework Class Library Usage Sys
ODBC和OLEDB的连接字符串.docx
09-26
ODBC连接字符串是用于连接数据库的字符串，格式通常如下： Driver={Driver Name};attribute1=value1;attribute2=value2;... 其中，Driver Name是ODBC驱动程序的名称，attribute是连接参数，value是对应的值。 ...
数据库连接字符串整理文本
03-10
### 数据库连接字符串详解 #### 一、概述 在软件开发过程中，数据库连接字符串是连接应用程序与数据库管理系统之间的重要桥梁。本文将详细解读一个包含多种数据库类型（如 SQL Server、Oracle 和 MySQL）的连接...
sqlserver、mysql获取连接字符串步骤
12-15
本文将详细阐述如何在SQL Server和MySQL中获取数据库连接字符串，这是建立应用程序与数据库之间连接的基础。 **SQL Server 获取连接字符串** SQL Server连接字符串通常包含以下几个关键元素： 1. **服务器名称/...
ODBC、OLE连接各种数据库的连接字符串
小S资料屋
02-22 535
简介 我们在使用数据库的时候，首先需要打开这个数据库。 我们可以找到集中类型的数据库，每个都使用不同的连接方式。 下面列举了一下主要的数据库的连接字符串 A：使用ODBC方式 1:dBASE连接字符串 strConnection = _T("Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;" ...
odbc 连接字符串
weixin_38166726的博客
06-07 161
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 fo...
ODBC 各种数据库连接串
热门推荐
我的专栏
08-13 3万+
ODBC 各种数据库连接串
ODBC连接字符串怎么写
zjh608的专栏
06-23 2663
ODBC连接字符串怎么写： 1。先建立一个文件型的DSN（如：1.dsn）。 2。然后使用记事本打开该文件。 如：文件内容为： ----------------------------------------------------------- [ODBC] DRIVER=Driver   do   Microsoft   Access   (*.mdb)
ODBC的mysql连接字符串_ODBC连接数据库的字符串生成
weixin_35780426的博客
01-19 539
QTP要进行数据库检查点之前，需要先连接数据库：1.在控制面板-管理工具-数据源(ODBC)创建数据源。(windows要先安装相应的odbc驱动包)2.在qtp中创建连接。'定义一个变量Dim Cnn'创建一个ADODB对象，赋值给这个变量Set Cnn =CreateObject("ADODB.Connection")'连接指定的数据库，用户名密码和数据源名称(Data Source就是步骤一...
[转]ODBC连接字符串大全(MySQL)
comhaqs的专栏
02-28 5598
原帖地址：http://www.connectionstrings.com/mysql   MySQL Connector/Net Type .NET Framework Class Library Usage MySql.Data.MySqlClient.MySqlConnection Manufacturer MySQL More info and class libr
oracle连接串
Rare's Tech-Blog
06-07 2073
<br />from http://www.connectionstrings.com/oracle#p15<br /> <br />Connection strings for OracleProviders for Oracle» Oracle Data Provider for .NET / ODP.NET (OracleConnection)<br />» .NET Framework Data Provider for Oracle (OracleConnection)<br />» dotCon
SQLServer连接字符串详析与常用配置
本文档详尽介绍了SQL Server数据库连接的各种连接字符串格式和配置方法，针对不同的SQL Server版本如SQL Server 2000、SQL Server 2005以及SQL Server 2005 Express进行了详细的讲解。首先，对于较早版本的SQL ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值