常用的字符串连接

最新推荐文章于 2024-09-21 00:32:42 发布

xiaofenglu0629

最新推荐文章于 2024-09-21 00:32:42 发布

阅读量284

点赞数 1

文章标签： microsoft sybase database server sql server access

本文链接：https://blog.csdn.net/xiaofenglu0629/article/details/5674965

版权

ODBC Driver for Text
lcConnectionString = "Driver={Microsoft Text Driver (*.txt;*.csv)};" & "DBQ=路径/文件;" & "Extensions=asc,csv,tab,txt;" & "Persist Security info=False"

ODBC Driver for Access
lcConnectionString = "Driver={Microsoft Access Driver (*.mdb)};" & "DBQ=路径/文件.mdb;" & "Uid=Admin;" & "Pdw=;"

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

ODBC Driver for SQL Server
lcConnectionString = "Driver={SQL Server};" & "Server=MyServerName;" & "Database=MyDarabaseName;" & "Uid=myUsername;" & "Pwd=myPassword;"

ODBC Driver for dBASE
lcConnectionString = "Driver={Microsoft dBASE Driver (*.dbf)};" & "Driverid=227;" & "DBQ=路径/文件;"

ODBC Driver for mySQL
lcConnectionString = "Driver={mySQL};" & "Server=MyServerName;" & "Option=16834;" & "Database=mydb;"

由tonyibm提供：
sevip = "localhost"
Db = "mydatabase"
user = "root"
pwd = "261210"
conn.Open "DRIVER={MySql ODBC 5.1 Driver};SERVER=" & sevip & ";Database=" & Db & ";Uid=" & user & ";Pwd=" & pwd & ";Stmt=set names GBK"

ODBC Driver for Sybase
lcConnectionString = "Driver={SYBASE SYSTEM 11};" & "Srvr=MyServerName;" & "Uid=myUsername;" & "Pwd=myPassword;"

ODBC Driver for Sybase SQL Anywhere
lcConnectionString = "Driver=Sybase SQL Anywhere 5.0;" & "DefaultDir=路径/;" & "Dbf=路径/文件名.db;" & "Uid=myUsername;" & "Pwd=myPassword;" & "Dns="""";"

ODBC Driver for VisualFoxPro
lcConnectionString = "Driver={Microsoft Visual Foxpro Driver};" & "SourceType=DBC;" & "SourceDBC=路径/文件.dbc;" & "Exclusive=No;"

ODBC Driver for AS/400
lcConnectionString = "Driver={Client Access ODBC Driver (32-bit)};" & "System=myAS400;" & "Uid=myUsername;" & "Pwd=myPassword;"

ODBC Driver for Paradox
lcConnectionString = "Driver={Microsoft Paradox Driver (*.db)};" & "Driverid=538;" & "Fil=Paradox 5.X;" & "DefaultDir=路径/; & "Dbq=路径/;" & "CollatingSequence=ASCII;"