ADO中,如何获得连接字符串? 你可以先用ADODC控件,设置ADODC的连接字符串,然后再copy它即可. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 先用ado控键连接,而后报连接信息烤下来 在vb里新建一个新的工程,,选择新建窗体,选择vb数据向导生成一个数据窗体,其中就有,自己赵吧 你这个字符串是dns-less的ado连接字符串,这个不能通过什么build出来,只能自己write from scratch你把我下面贴的东西全部保存下来吧:)----------------------------------------------------------------ODBC DNS-Less Connections----------------------------------------------------------------ODBC Driver for AS/400 Conn.Open "Driver={Client Access ODBC Driver (32-bit)};" & _ "System=myAS400;Uid=myUsername;Pwd=myPassword;" ODBC Driver for dBASE Conn.Open "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=\somepath;"* ???????????????????? SQLrs.Open "SELECT * FROM USER.DBF", Conn ODBC Driver for MS Access Conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=\path\mydb.mdb;Uid=Admin;Pwd=;"Using a Workgroup (System database)Conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "Dbq=\path\mydb.mdb;SystemDB=\somepath\mydb.mdw;", "admin","" ODBC Driver for MS Excel Conn.Open "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;" & _ "Dbq=\somepath\Sheet1.xls;DefaultDir=\somepath;" ODBC Driver for MySQL (MyODBC) Conn.Open "Driver={mySQL};Server=MyServerName;Option=16834;Database=mydb;" ODBC Driver for Oracle Conn.Open "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;" & _ "Uid=myUsername;Pwd=myPassword;" ODBC Driver for Paradox Conn.Open "Driver={Microsoft Paradox Driver (*.db)};DriverID=538;Fil=Paradox 5.X;" & _ "DefaultDir=c:\dbpath\;Dbq=c:\dbpath\;CollatingSequence=ASCII;" ODBC Driver for SQL Server Conn.Open "Driver={SQL Server};Server=MyServerName;Database=myDatabaseName;" & _ "Uid=myUsername;Pwd=myPasswordFor trusted connectionConn.Open "Driver={SQL Server};Server=MyServerName;Database=myDatabaseName;" & _ "Trusted_Connection=yes;"To Prompt user for username and passwordConn.Properties("Prompt") = adPromptAlwaysConn.Open "Driver={SQL Server}; Server=ServerName; DataBase=DatabaseName;" ODBC Driver for Sybase Sybase System 11 ODBC DriverConn.Open "Driver={SYBASE SYSTEM 11}; Srvr=myServerName;" & _ "Uid=myUsername; Pwd=myPassword;"Intersolv 3.10 Sybase ODBC DriverConn.Open "Driver={INTERSOLV 3.10 32-BIT Sybase}; Srvr=myServerName;" & _ "Uid=myUsername; Pwd=myPassword;" ODBC Driver for Sybase SQL Anywhere Conn.Open "ODBC; Driver=Sybase SQL Anywhere 5.0;" & _ "DefaultDir=c:\dbpath\; Dbf=c:\sqlany50\mydb.db;" & _ "Uid=myUsername; Pwd=myPassword; Dsn="""";" ODBC Driver for Text Conn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _ "Dbq=\somepath\; Extensions=asc,csv,tab,txt; Persist Security Info=False"* .....SQLrs.Open "SELECT * FROM CUSTOMER.CSV", Conn ODBC Driver for Visual FoxPro With a database containerConn.Open "Driver={Microsoft Visual FoxPro Driver}; SourceType=DBC;" & _ "SourceDB=\somepath\mySourceDb.dbc; Exclusive=No;" Without a database container (Free Table Directory)Conn.Open "Driver={Microsoft Visual FoxPro Driver}; SourceType=DBF;" & _ "SourceDB=\somepath\mySourceDbFolder; Exclusive=No;" --------------------------------------------如果不是dns-less的connection string, 可以在桌面上生成test.txt文件,空的然后改名为test.udl然后双击test.udlconfig完了之后用ultraedit打开,拷贝里面的connection string 就可以了 想实现vc2010工具箱的控件 标题要长:网页加载一个带有界面的ActiveX,DoModal()窗口,无响应问题...在线等 对COM概念方面的一些问题 获取系统进程为什么返回的是16进制?谢谢 请教高手,在线等,关于VC获取word文档页眉时引起的一个现象 使用阻塞模式在socket上进行通讯的线程怎么会出现这样的情况??? 请问这是什么错误呀? 刚开始接触ADO编程,请教高手,关于ADO编程的几个问题? 如何设置一个对话框的颜色 我要禁止掉CToolBar中的一个按钮!!!!!!!!!!!!! 如何在一个方法中返回一个数组,怎样用asp访问这数组呢?? 救急!!!!
----------------------------------------------------------------
ODBC DNS-Less Connections
----------------------------------------------------------------
ODBC Driver for AS/400
Conn.Open "Driver={Client Access ODBC Driver (32-bit)};" & _
"System=myAS400;Uid=myUsername;Pwd=myPassword;"
ODBC Driver for dBASE
Conn.Open "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=\somepath;"
* ???????????????????? SQL
rs.Open "SELECT * FROM USER.DBF", Conn
ODBC Driver for MS Access
Conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=\path\mydb.mdb;Uid=Admin;Pwd=;"Using a Workgroup (System database)
Conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=\path\mydb.mdb;SystemDB=\somepath\mydb.mdw;", "admin",""
ODBC Driver for MS Excel
Conn.Open "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;" & _
"Dbq=\somepath\Sheet1.xls;DefaultDir=\somepath;"
ODBC Driver for MySQL (MyODBC)
Conn.Open "Driver={mySQL};Server=MyServerName;Option=16834;Database=mydb;"
ODBC Driver for Oracle
Conn.Open "Driver={Microsoft ODBC for Oracle};Server=OracleServer.world;" & _
"Uid=myUsername;Pwd=myPassword;"
ODBC Driver for Paradox
Conn.Open "Driver={Microsoft Paradox Driver (*.db)};DriverID=538;Fil=Paradox 5.X;" & _
"DefaultDir=c:\dbpath\;Dbq=c:\dbpath\;CollatingSequence=ASCII;"
ODBC Driver for SQL Server
Conn.Open "Driver={SQL Server};Server=MyServerName;Database=myDatabaseName;" & _
"Uid=myUsername;Pwd=myPasswordFor trusted connection
Conn.Open "Driver={SQL Server};Server=MyServerName;Database=myDatabaseName;" & _
"Trusted_Connection=yes;"To Prompt user for username and password
Conn.Properties("Prompt") = adPromptAlways
Conn.Open "Driver={SQL Server}; Server=ServerName; DataBase=DatabaseName;"
ODBC Driver for Sybase
Sybase System 11 ODBC Driver
Conn.Open "Driver={SYBASE SYSTEM 11}; Srvr=myServerName;" & _
"Uid=myUsername; Pwd=myPassword;"Intersolv 3.10 Sybase ODBC Driver
Conn.Open "Driver={INTERSOLV 3.10 32-BIT Sybase}; Srvr=myServerName;" & _
"Uid=myUsername; Pwd=myPassword;"
ODBC Driver for Sybase SQL Anywhere
Conn.Open "ODBC; Driver=Sybase SQL Anywhere 5.0;" & _
"DefaultDir=c:\dbpath\; Dbf=c:\sqlany50\mydb.db;" & _
"Uid=myUsername; Pwd=myPassword; Dsn="""";"
ODBC Driver for Text
Conn.Open "Driver={Microsoft Text Driver (*.txt; *.csv)};" & _
"Dbq=\somepath\; Extensions=asc,csv,tab,txt; Persist Security Info=False"
* .....SQL
rs.Open "SELECT * FROM CUSTOMER.CSV", Conn
ODBC Driver for Visual FoxPro
With a database container
Conn.Open "Driver={Microsoft Visual FoxPro Driver}; SourceType=DBC;" & _
"SourceDB=\somepath\mySourceDb.dbc; Exclusive=No;" Without a database container (Free Table Directory)
Conn.Open "Driver={Microsoft Visual FoxPro Driver}; SourceType=DBF;" & _
"SourceDB=\somepath\mySourceDbFolder; Exclusive=No;"
--------------------------------------------
如果不是dns-less的connection string, 可以在桌面上生成test.txt文件,空的
然后改名为test.udl
然后双击test.udl
config完了之后
用ultraedit打开,拷贝里面的connection string 就可以了