精华内容
下载资源
问答
  • 我把SQL数据库的表(Northwind/Customers)连接...我想问题肯定是在连接字符串上,但不知道如何修改.特此寻我把SQL数据库的表(Northwind/Customers)连接到网页的DataGrid上,想在上显示客户数据.但在调试/启动时出错,错...

    我把SQL数据库的表(Northwind/Customers)连接到网页的DataGrid上,想在上显示客户数据.但在调试/启动时出错,错误信息为:

    18456:用户'HARRY-K9/ASPNET'登陆失败.

    我想问题肯定是在连接字符串上,但不知道如何修改.特此寻

    我把SQL数据库的表(Northwind/Customers)连接到网页的DataGrid上,想在上显示客户数据.但在调试/启动时出错,错误信息为:

    18456:用户'HARRY-K9/ASPNET'登陆失败.

    我想问题肯定是在连接字符串上,但不知道如何修改.特此寻求帮助.我的SQL安装在自己的手提电脑(WindowsXP ?R蛋?上,不需要输入用户名和口令便可进入数据库.integrated security=SSPI 可能与此相冲突.

    Visual Studio.NET 产生的字符串如下:

    Me.SqlConnection1.ConnectionString =

    "workstation id=""HARRY-K9"";

    packet size=4096;

    integrated security=SSPI;

    data source=""HARRY-K9"";

    persist security info=False;

    initial catalog=Northwind"

    其中"HARRY-K9" 是我的计算机名.

    Me.SqlConnection1.ConnectionString = "workstation id=""HARRY-K9"";packet size=4096;integrated security=SSPI;data source=""" & _

    "HARRY-K9"";persist security info=False;initial catalog=Northwind"

    Me.SqlConnection1.ConnectionString = "workstation id=""HARRY-K9"";packet size=4096;integrated security=SSPI;data source=""" & _

    "HARRY-K9"";persist security info=False;initial catalog=Northwind"

    展开

    全部

    展开全文
  • 解决Access连接 accdb 不可识别的数据库格式异常在Access07之前的数据库后缀名均为*.mdb 而连接字符串写成Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myFolder\*.mdb;Persist Security Info=False;但是Access...

    解决Access连接 accdb 不可识别的数据库格式异常

    在Access07之前的数据库后缀名均为*.mdb 而连接字符串写成Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myFolder\*.mdb ;Persist Security Info=False;

    但是Access07和Access10将后缀...

    文章

    teacheryang

    2014-05-08

    690浏览量

    使用SQLite数据库和Access数据库的一些经验总结

    在我的《Winform开发框架》中,可使用多种数据库作为程序的数据源,除了常规的Oracle数据库、SqlServer、MySql数据库,其中还包括了SQLite数据库、Access数据库,后两个数据库都是在单机版程序中常用到的数据库,各自有着自己的特点,在我的《Winform开发框架》的提炼和多...

    文章

    walb呀

    2017-12-04

    1321浏览量

    C#测试SQL Server数据库连接程序

    参考文献:

    Sql Server的JDBC测试程序与远程连接

    前言:

    之前写过一篇博客:Sql Server的JDBC测试程序与远程连接,现在来讲讲在.net 平台下如何连接sql server数据库。有多种方式可以连接数据库,分别是ODBC,OLEDB,ADO,ADO.NET。每一种连接所使用的...

    文章

    嗯哼9925

    2017-12-27

    1168浏览量

    ff0c35e3aa0877a25f7873cca08f3438.png

    Quick BI 数据可视化分析平台

    2020年入选全球Gartner ABI魔力象限,为中国首个且唯一入选BI产品

    广告

    Access数据库连接

    Access数据库的连接,2000和2007版本有差别。Access2000的连接字符串为:

    1

    2

    3

    4

    str.Format(TEXT("Provider=Microsoft.Jet.OLEDB.4.0;

    Persist Security I...

    文章

    技术小甜

    2017-11-15

    710浏览量

    【转】ASP.NET数据库连接字符串总结

    来源:http://blog.csdn.net/lutinghuan/article/details/5973897

    ASP.NET数据库连接字符串总结

    一、使用OleDbConnection对象连接OLE DB数据源

    1.连接Access 数据库

    Access 2000: “p...

    文章

    华山青竹

    2014-04-26

    672浏览量

    解决Access连接 accdb 不可识别的数据库格式异常

    在Access07之前的数据库后缀名均为*.mdb 而连接字符串写成Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myFolder\*.mdb ;Persist Security Info=False;

    但是Access07和Access10...

    文章

    长空翱翔

    2016-02-18

    1362浏览量

    C#各种数据库连接字符串大全——SQLServer、Oracle、Access

    在这里统计了.NET项目下常用的数据库连接字符串:SQLServer、Oracle、Access三种数据库(MySql、SQLLite、Excel、HTML Table等等暂不列入)。

    1.常用连接字符串参数说明如需查看详细说明请参见:SqlConnection.ConnectionstringO...

    文章

    小新的蜡笔

    2013-01-04

    882浏览量

    [数据库连接字符串] Access 连接字符串(转)

    ODBC   标准安全策略

    Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;

    工作组

    Driver={Microsoft Access Driver (*.mdb)...

    文章

    技术小美

    2017-11-12

    668浏览量

    C#中数据库连接的几种方式

    [转载]原文出处http://blog.163.com/ny_lonely/blog/static/188924273201161112931892/

    1.配置文件链接。

    利用VS.NET开发平台进行开发的时候将会经常遇到要和数据库打交道,存取数据。这就涉及到和数据库的连接问题,.N...

    文章

    橘子红了呐

    2017-11-21

    1419浏览量

    未在本地计算机上注册“microsoft.ACE.oledb.12.0”提供程序

    今天界面的菜单初步确定。

    接下来,首要的是数据库的设计,到底要用什么数据库好呢?用SQL server?太大了,不想装;用MySql,没用过,没下载;用Oracl,太正式了,用不来。最后我想就用Access吧,本地已安装。但在连接时出现:"未在本地计算机上注册"microsoft.Jet.ole...

    文章

    gisweis

    2015-07-02

    1268浏览量

    使用c#访问Access数据库时,提示找不到可安装的 ISAM

    使用c#访问Access数据库时,提示找不到可安装的 ISAM,如下图:

    代码如下:

    connectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=db.mdb;Pwd=abcd;";

    conn...

    文章

    微wx笑

    2015-06-09

    880浏览量

    【求助】测试XCode v8.0的正向反向功能

    目的:测试XCode v8.0的正常反向功能。 正向工程:从数据库读取架构信息,生成实体类。 反向工程:根据实体类的特性构造架构信息,反向生成数据库或者修改数据库。 准备工作: 1,自备数据库实例,最好是自己的数据库,为了测试各种数据库的各种字段能否被识别为正确的.Net类型(正向工程),同时也测...

    文章

    智能大石头

    2011-09-08

    562浏览量

    【求助】测试XCode v8.0的正向反向功能

    目的:测试XCode v8.0的正常反向功能。

    正向工程:从数据库读取架构信息,生成实体类。

    反向工程:根据实体类的特性构造架构信息,反向生成数据库或者修改数据库。

    准备工作:

    1,自备数据库实例,最好是自己的数据库,为了测试各种数据库的各种字段能否被识别为正确的.Net类型(正向工程),同时也测...

    文章

    长征6号

    2016-11-28

    729浏览量

    几个常用的数据库连接字符串

    1. 使用SQl提供者的,使用SQL SERVER验证方式连接SQL SERVER northwind数据库

    @"server=localhost;database=northwind;UID=sa;PassWord=";

    2. 使用SQl提供者的,使用windows集成验证方式连接SQL ...

    文章

    范大脚脚

    2017-11-14

    753浏览量

    Sqlhelper.cs 备用

    .net数据访问类 SQL Helper 介绍摘要:Data Access Application Block 是一个 .NET 组件,包含优化的数据访问代码,可以帮助用户调用存储过程以及向 SQL Server 数据库发出 SQL 文本命令。它返回 SqlDataReader、DataSet 和...

    文章

    天伟

    2011-03-18

    754浏览量

    C#中使用晚绑定实现压缩Access数据库

    C#中使用晚绑定实现压缩Access数据库.

    VB对Com后期绑定支持得很好,在C#中可以使用反射来实现.

    函数实现代码如下:

    1 public static void CompactAccessDB(string strMdbName) 2 { 3     string TempMdbName...

    文章

    瑞克-rick

    2008-01-25

    713浏览量

    如何使用C++ Builder 6.0连接Access数据库

    本文假定所需连接的Access数据库为db_restaurant,如何连接db_restaurant,现在将拉开帷幕。

    首先,通过使用“File→New→Data Module”创建一个用于连接数据库的窗体。然后,在“ADO”选项卡下选择“ADOConnection”控件与“ADOQuery”控件...

    文章

    狂斩一条龙

    2011-04-14

    503浏览量

    Asp.Net通过ODBC连接Oracle数据库

    本来有个项目是通过安装Oracle client然后让asp.net引用System.Data.OracleClient来访问Oracle数据库的,但是不知道为什么老是报:ORA-12170:连接超时的错误,(客户的服务器配置是:Windows Server 2008 R2 64bit 我刚开始安...

    文章

    awbeci

    2015-11-19

    856浏览量

    在数据库访问项目中使用微软企业库Enterprise Library,实现多种数据库的支持

    在我们开发很多项目中,数据访问都是必不可少的,有的需要访问Oracle、SQLServer、Mysql这些常规的数据库,也有可能访问SQLite、Access,或者一些我们可能不常用的PostgreSQL、IBM DB2、或者国产达梦数据库等等,这些数据库的共同特点是关系型数据库,基本上开发的模型...

    文章

    walb呀

    2017-12-04

    1751浏览量

    Sqlserver与access数据库sql语法十大差异

    ACCESS结构简单容易处理,而且也能满足多数的网站程序要求,也是初学者的试牛刀。ACCESS是小型数据库,既然是小型就有他根本的局限性: 1)、数据库过大,一般ACCESS数据库达到50M左右的时候性能会急剧下降! 2)、网站访问频繁,经常超过100人的在线时,处理速度会有影响! 3)、记录数过...

    文章

    eclipse_xu

    2012-12-06

    593浏览量

    sqlhelper使用指南

    摘要:Data Access Application Block 是一个 .NET 组件,包含优化的数据访问代码,可以帮助用户调用存储过程以及向 SQL Server 数据库发出 SQL 文本命令。它返回 SqlDataReader、DataSet 和 XmlReader 对象。您可以在自己的 ....

    文章

    wenvi_wu

    2008-04-14

    1071浏览量

    从HelloWorld启航——数据库连接字符串的困惑

    程序员方阵

    数据库连接字符串的困惑

    数据库连接字符串的组成

    驱动程序

    ODBC

    OLE DB

    JDBC

    比较

    数据库链接字符串大全

    SQL Server 2005

    SQL Native Client ODBC Driver

    SQL Native Client OLE DB ...

    文章

    微wx笑

    2015-09-15

    655浏览量

    备份,还原,压缩数据库

    压缩Access数据库#region 压缩Access数据库

    /** 

    /// 压缩Access数据库

    /// 

    /// 

    ...

    文章

    灵动生活

    2008-07-14

    462浏览量

    C# winform 打开数据库连接对话框

    简单调用VS自带的数据源选择对话框实现数据库连接字符串配置

    我们经常在开发应用程序中提供择数据源和数据连接配置的接口,方便用户配置数据库连接字符串。典型的方法是将这些信息写在配置文件里,如Web.config或app.config文件里.

    但是客户并不是专业的编程人员,一不小心就会使连接串写错,导...

    文章

    技术小牛人

    2017-11-16

    1168浏览量

    各种数据库,文件连接字符串

    Where do you want to connect today?

    Database servers

    SQL Server

    SQL Server 2005

    SQL Server 2005 Compact Edition

    Oracle

    ...

    文章

    ikingsmart

    2007-11-25

    1123浏览量

    Access转换为 MS SQL 有什么要注意的地方

    常在一些bbs上面看见有人在问Access转换为 MS SQL 有什么要注意的地方,或是编写存储过程,现在小弟在此写一些要注意的或者常用的语法给大家参考(部分为asp常用的函数)

    -------------------

    Access : Now()

    MS SQL : GetDate()

    -----...

    文章

    springfe

    2005-05-10

    531浏览量

    在数据库中存取文件

    在数据库中存取文件

    http://www.51cto.com  2005-11-24 09:16  作者:  出处:pconline

    本文介绍如何利用ADO来操作数据库中的文件。'*************************************************

    '**

    '...

    文章

    jimbuster

    2006-01-09

    641浏览量

    “数据访问函数库”(DataAccessLibrary for .net2.0 )源代码下载 09.06.15更新

    最新下载地址:

    http://www.naturefw.com/nature/down.aspx

    DLL文件说明

    Controls.dll 控件集合,包含QuickPager分页控件等。

    DataAccess2.0.dll 数据访问函数库,分页控件需要使用这个d...

    文章

    金色海洋

    1970-01-01

    679浏览量

    SQLMAP参数中文解说

    #HiRoot's Blog

    Options(选项):

    --version 显示程序的版本号并退出

    -h, --help 显示此帮助消息并退出

    -v VERBOSE 详细级别:0-6(默认为1)

    Target(目标):

    以下至少需要设置其中一个选项,设置目标URL。

    -d DIRECT 直接连...

    文章

    y0umer

    2012-03-16

    754浏览量

    如何使用C++ Builder 6.0连接Access数据库

    本文假定所需连接的Access数据库为db_restaurant,如何连接db_restaurant,现在将拉开帷幕。

    首先,通过使用“File→New→Data Module”创建一个用于连接数据

    库的窗体。然后,在“ADO”选项卡下选择“ADOConnection”控件与

    “ADOQuery”...

    文章

    技术小阿哥

    2017-11-27

    1339浏览量

    展开全文
  • 很感谢creativepeter(头皮屑)提供的本连接地址(http://www.connectionstrings.com/)SQL ServerODBCStandard Security:"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"Trusted connection:...

    很感谢creativepeter(头皮屑)提供的本连接地址(http://www.connectionstrings.com/)

    SQL Server

    ODBC

    Standard Security:

    "Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"

    Trusted connection:

    "Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"

    Prompt for username and password:

    oConn.Properties("Prompt") = adPromptAlways

    oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"

    OLE DB, OleDbConnection (.NET)

    Standard Security:

    "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"

    Trusted Connection:

    "Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"

    (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)

    Prompt for username and password:

    oConn.Provider = "sqloledb"

    oConn.Properties("Prompt") = adPromptAlways

    oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"

    Connect via an IP address:

    "Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog= pubs;UserID=sa;Password=asdasd;"

    (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))

    SqlConnection (.NET)

    Standard Security:

    "Data Source=Aron1;Initial Catalog= pubs;UserId=sa;Password=asdasd;"

    - or -

    "Server=Aron1;Database=pubs;UserID=sa;Password=asdasd;Trusted_Connection=False"

    (booth connection strings produces the same result)

    Trusted Connection:

    "Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"

    - or -< BR>"Server=Aron1;Database=pubs;Trusted_Connection=True;"

    (booth connection strings produces the same result)

    (use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)

    Connect via an IP address:

    "Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog= pubs;UserID=sa;Password=asdasd;"

    (DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))

    Declare the SqlConnection:

    C#:

    using System.Data.SqlClient;

    SqlConnection oSQLConn = new SqlConnection();

    oSQLConn.ConnectionString="my connectionstring";

    oSQLConn.Open();

    VB.NET:

    Imports System.Data.SqlClient

    Dim oSQLConn As SqlConnection = New SqlConnection()

    oSQLConn.ConnectionString="my connectionstring"

    oSQLConn.Open()

    Data Shape

    MS Data Shape

    "Provider=MSDataShape;Data Provider=SQLOLEDB;Data Source=Aron1;Initial Catalog= pubs;UserID=sa;Password=asdasd;"

    Want to learn data shaping? Check out 4GuyfFromRolla's great article about Data Shaping >>

    Read more

    How to define wich network protocol to use

    Example:

    "Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog= pubs;UserID=sa;Password=asdasd;"

    Name

    Network library

    dbnmpntw

    Win32 Named Pipes

    dbmssocn

    Win32 Winsock TCP/IP

    dbmsspxn

    Win32 SPX/IPX

    dbmsvinn

    Win32 Banyan Vines

    dbmsrpcn

    Win32 Multi-Protocol (Windows RPC)

    Important note!

    When connecting through the SQLOLEDB provider use the syntax Network Library=dbmssocn

    and when connecting through MSDASQL provider use the syntax Network=dbmssocn

    All SqlConnection connectionstring properties

    This table shows all connectionstring properties for the ADO.NET SqlConnection object. Most of the properties are also used in ADO. All properties and descriptions is from msdn.

    NameDefaultDescription

    Application Name

    The name of the application, or '.Net SqlClient Data Provider' if no application name is provided.

    AttachDBFilename

    -or-

    extended properties

    -or-

    Initial File Name

    The name of the primary file, including the full path name, of an attachable database. The database name must be specified with the keyword 'database'.

    Connect Timeout

    -or-

    Connection Timeout

    15

    The length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error.

    Connection Lifetime

    0

    When a connection is returned to the pool, its creation time is compared with the current time, and the connection is destroyed if that time span (in seconds) exceeds the value specified by connection lifetime. Useful in clustered configurations to force load balancing between a running server and a server just brought on-line.

    Connection Reset

    'true'

    Determines whether the database connection is reset when being removed from the pool. Setting to 'false' avoids making an additional server round-trip when obtaining a connection, but the programmer must be aware that the connection state is not being reset.

    Current Language

    The SQL Server Language record name.

    Data Source

    -or-

    Server

    -or-

    Address

    -or-

    Addr

    -or-

    Network Address

    The name or network address of the instance of SQL Server to which to connect.

    Enlist

    'true'

    When true, the pooler automatically enlists the connection in the creation thread's current transaction context.

    Initial Catalog

    -or-

    Database

    The name of the database.

    Integrated Security

    -or-

    Trusted_Connection

    'false'

    Whether the connection is to be a secure connection or not. Recognized values are 'true', 'false', and 'sspi', which is equivalent to 'true'.

    Max Pool Size

    100

    The maximum number of connections allowed in the pool.

    Min Pool Size

    0

    The minimum number of connections allowed in the pool.

    Network Library

    -or-

    Net

    'dbmssocn'

    The network library used to establish a connection to an instance of SQL Server. Supported values include dbnmpntw (Named Pipes), dbmsrpcn (Multiprotocol), dbmsadsn (Apple Talk), dbmsgnet (VIA), dbmsipcn (Shared Memory) and dbmsspxn (IPX/SPX), and dbmssocn (TCP/IP).

    The corresponding network DLL must be installed on the system to which you connect. If you do not specify a network and you use a local server (for example, "." or "(local)"), shared memory is used.

    Packet Size

    8192

    Size in bytes of the network packets used to communicate with an instance of SQL Server.

    Password

    -or-

    Pwd

    The password for the SQL Server account logging on.

    Persist Security Info

    'false'

    When set to 'false', security-sensitive information, such as the password, is not returned as part of the connection if the connection is open or has ever been in an open state. Resetting the connection string resets all connection string values including the password.

    Pooling

    'true'

    When true, the SQLConnection object is drawn from the appropriate pool, or if necessary, is created and added to the appropriate pool.

    User ID

    The SQL Server login account.

    Workstation ID

    the local computer name

    The name of the workstation connecting to SQL Server.

    Note

    Use ; to separate each property.

    If a name occurs more than once, the value from the last one in the connectionstring will be used.

    If you are building your connectionstring in your app using values from user input fields, make sure the user can't change the connectionstring by inserting an additional property with another value within the user value.

    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:\mydatabase.mdw;"

    Exclusive:

    "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="

    OLE DB, OleDbConnection (.NET)

    Standard security:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;"

    Workgroup (system database):

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;"

    With password:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"

    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=myUsername;Pwd=myPassword;"

    OLE DB, OleDbConnection (.NET)

    Standard security:

    "Provider=msdaora;Data Source= MyOracleDB;UserId=UserName;Password=asdasd;"

    This one's from Microsoft, the following are from Oracle

    Standard Security:

    "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=Username;Password=asdasd;"

    Trusted Connection:

    "Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;OSAuthent=1;"

    OracleConnection (.NET)

    Standard:

    "Data Source=Oracle8i;Integrated Security=yes";

    This one works only with Oracle 8i release 3 or later

    Declare the OracleConnection:

    C#:

    using System.Data.OracleClient;

    OracleConnection oOracleConn = new OracleConnection();

    oOracleConn.ConnectionString = "my connectionstring";

    oOracleConn.Open();

    VB.NET:

    Imports System.Data.OracleClient

    Dim oOracleConn As OracleConnection = New OracleConnection()

    oOracleConn.ConnectionString = "my connectionstring"

    oOracleConn.Open()

    Core Labs OraDirect (.NET)

    Standard:

    "User ID=scott; Password=tiger; Host=ora; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0"

    Read more at

    Data Shape

    MS Data Shape:

    "Provider=MSDataShape.1;Persist Security Info=False;Data Provider=MSDAORA;Data Source= orac;userid=username;password=mypw"

    Want to learn data shaping? Check out 4GuyfFromRolla's great article about Data Shaping >>

    MySQL

    ODBC

    Local database:

    "Driver={mySQL};Server=mySrvName;Option=16834;Database=mydatabase;"

    Remote database:

    "Driver={mySQL};Server=data.domain.com;Port=3306;Option=131072;Stmt=;Database=my-database;Uid=username;Pwd=password;"

    OLE DB, OleDbConnection (.NET)

    Standard:

    "Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd;"

    MySqlConnection (.NET)

    eInfoDesigns.dbProvider:

    "DataSource=server;Database= mydb;UserID=username;Password=pwd;Command Logging=false"

    This one is used with eInfoDesigns dbProvider, an add-on to .NET

    Declare the MySqlConnection:

    C#:

    using eInfoDesigns.dbProvider.MySqlClient;

    MySqlConnection oMySqlConn = new MySqlConnection();

    oMySqlConn.ConnectionString = "my connectionstring";

    oMySqlConn.Open();

    VB.NET:

    Imports eInfoDesigns.dbProvider.MySqlClient

    Dim oMySqlConn As MySqlConnection = New MySqlConnection()

    oMySqlConn.ConnectionString = "my connectionstring"

    oMySqlConn.Open()

    SevenObjects MySqlClient (.NET)

    Standard:

    "Host=server; UserName= myusername;Password=mypassword;Database=mydb;"

    This is a freeware ADO.Net data provider from SevenObjects

    Core Labs MySQLDirect (.NET)

    Standard:

    "User ID=root; Password=pwd; Host=localhost; Port= 3306;Database=test;Direct=true; Protocol=TCP; Compress=false; Pooling=true; Min Pool Size=0;Max Pool Size=100; Connection Lifetime=0"

    Read more at

    Interbase

    ODBC, Easysoft

    Local computer:

    "Driver={Easysoft IB6 ODBC};Server=localhost;Database=localhost:C:\mydatabase.gdb;Uid=username;Pwd=password"

    Remote Computer:

    < DIV> "Driver={EasysoftIB6ODBC};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:\mydatabase.gdb;Uid=username;Pwd=password"

    Remote Computer:

    "Driver= {INTERSOLV InterBaseODBCDriver(*.gdb)};Server=ComputerName;Database=ComputerName:C:\mydatabase.gdb;Uid=username;Pwd=password"

    This driver are provided by DataDirect Technologies >> (formerly Intersolv)

    OLE DB, SIBPROvider

    Standard:

    "provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey"

    Specifying character set:

    "provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;user id=SYSDBA;password=masterkey;character set=ISO8859_1"

    Specifying role:

    "provider=sibprovider;location=localhost:;data source=c:\databases\gdbs\mygdb.gdb;userid=SYSDBA;password=masterkey;role=DIGITADORES"

    Read more about connecting to Interbase in this Borland Developer Network article http://community.borland.com/article/0,1410,27152,00.html

    IBM DB2

    OLE DB, OleDbConnection (.NET) from ms

    TCP/IP:

    "Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=XXX.XXX.XXX.XXX;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"

    APPC:

    "Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=MyUser;Password=MyPW"

    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= {SYBASESYSTEM11};Srvr=Aron1;Uid=username;Pwd=password;"

    Do you know a userguide for Sybase System 11, 12, 12.5? E-mail the URL to connectionstrings.com now!! >>

    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= SybaseSQLAnywhere5.0;DefaultDir=c:\dbfolder\;Dbf=c:\mydatabase.db;Uid=username;Pwd=password;Dsn="""""

    Note! The two double quota following the DSN parameter at the end are escaped quotas (VB syntax), you may have to change this to your language specific escape syntax. The empty DSN parameter is indeed critical as not including it will result in error 7778.

    Read more in the Sybase SQL Anywhere User Guide >>

    OLE DB

    Adaptive Server Anywhere (ASA):

    "Provider=ASAProv;Data source=myASA"

    Adaptive Server Enterprise (ASE) with Data Source .IDS file:

    "Provider=Sybase ASE OLE DB Provider; Data source=myASE"

    Note that you must create a Data Source .IDS file using the Sybase Data Administrator. These .IDS files resemble ODBC DSNs.

    Adaptive Server Enterprise (ASE):

    < DIV>"Provider=Sybase.ASEOLEDBProvider;Srvr=myASEserver,5000;Catalog= myDBname;UserId=username;Password=password"

    - some reports on problem using the above one, try the following as an alternative -

    "Provider=Sybase.ASEOLEDBProvider;Server Name=myASEserver,5000;Initial Catalog= myDBname;UserId=username;Password=password"

    This one works only from Open Client 12.5 where the server port number feature works,燼llowing fully qualified connection strings to be used without defining燼ny .IDS Data Source files.

    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;Pwd=myPwd"

    OLE DB

    IBM Informix OLE DB Provider:

    "Provider=Ifxoledbc.2;password=myPw;User ID=myUser;Data Source=dbName@serverName;Persist Security Info=true"

    Mimer SQL

    ODBC

    Standard Security:

    "Driver={MIMER};Database=mydb;Uid=myuser;Pwd=mypw;"

    Prompt for username and password:

    "Driver={MIMER};Database=mydb;"

    PostgreSQL

    Core Labs PostgreSQLDirect (.NET)

    Standard:

    "User ID=root; Password=pwd; Host=localhost; Port= 5432;Database=testdb;Pooling=true; Min Pool Size=0; Max Pool Size=100; Connection Lifetime=0"

    Read more at

    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;DefaultDir=c:\mypath;"

    OLE DB

    Standard:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""

    "HDR=Yes;" indicates that the first row contains columnnames, not data

    "IMEX=1;" tells the driver to always read "intermixed" data columns as text

    TIP! SQL syntax: "SELECT * FROM [sheet1$]" - i.e. worksheet name followed by a "$" and wrapped in "[" "]" brackets.

    Text

    ODBC

    Standard:

    "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\txtFilesFolder\;Extensions=asc,csv,tab,txt;"

    OLE DB

    Standard:

    < DIV> "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\txtFilesFolder\;ExtendedProperties=""text;HDR=Yes;FMT=Delimited"""

    "HDR=Yes;" indicates that the first row contains columnnames, not data

    DBF / FoxPro

    ODBC

    standard:

    "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;"

    OLE DB, OleDbConnection (.NET)

    standard:

    "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\folder;Extended Properties=dBASE IV;User ID=Admin;Password="

    Visual FoxPro

    OLE DB, OleDbConnection (.NET)

    Database container (.DBC):

    "Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Password=MyPassWord;Collating Sequence=machine"

    Free table directory:

    "Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Password=MyPassWord;Collating Sequence=general"

    ODBC

    Database container (.DBC):

    "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;Collate=Machine;"

    Free Table directory:

    "Driver= {MicrosoftVisualFoxProDriver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;Exclusive=No;Collate=Machine;"

    "Collate=Machine" is the default setting, for other settings check the list of supported collating sequences >>

    Pervasive

    ODBC

    Standard:

    "Driver= {Pervasive ODBC ClientInterface};ServerName=srvname;dbq=@dbname"

    OLE DB

    Standard:

    "Provider=PervasiveOLEDB;Data Source=C:\path"

    UDL

    UDL

    UDL:

    "File Name=c:\myDataLink.udl;"

    展开全文
  • K3 金蝶插件获取连接数据库字符串。二开独立插件获取金蝶连接
  • 一、.NET Framework Data Provider for SQL Server类型:.NET Framework类库使用:System.Data.SqlClient....标准安全连接Data Source = myServerAddress;Initial Catalog = myDataBase;User Id = myUsernam...

    一、.NET Framework Data Provider for SQL Server

    类型:.NET Framework类库

    使用:System.Data.SqlClient.SqlConnection

    厂商:Microsoft

    1.标准安全连接

    Data Source = myServerAddress;Initial Catalog = myDataBase;User Id = myUsername;Password = myPassword;

    使用服务器名\实例名作为连接指定SQL Server实例的数据源。如果你使用的是SQL Server 2008 Express版,实例名为SQLEXPRESS。

    2.可替代的标准安全连接

    Server = myServerAddress;Database = myDataBase;User ID = myUsername;Password = myPassword;Trusted_Connection = False;

    这条连接字符串跟上一条效果一样。把这条写出来只是想说,其实很多连接字符串的关键字有多种写法。

    3.信任连接

    Data Source = myServerAddress;Initial Catalog = myDataBase;Integrated Security = SSPI;

    可替代的信任连接

    Server = myServerAddress;Database = myDataBase;Trusted_Connection = True;

    4.连接Windows CE设备的信任连接

    通常一台Windows CE设备在一个域里是不能被认证和登录的。为了让一台CE设备使用SSPI或信任连接和认证,可以使用下面的连接字符串:

    Data Source = myServerAddress;Initial Catalog = myDataBase;Integrated Security = SSPI;User ID = myDomain

    \myUsername;Password = myPassword;

    说明一下,这条语句只能在CE设备上用。

    5.使用IP地址的连接

    Data Source = 190.168.1.100,1433;Network Library = DBMSSOCN;Initial Catalog = myDataBase;User

    ID = myUsername;Password = myPassword;

    这条语句用TCP/IP地址替代了命名管道。在Data Source字段最后的是使用的端口。SQL Server默认使用的端口是1433。

    6.开启MARS功能(multiple active result sets)

    Server = myServerAddress;Database = myDataBase;Trusted_Connection = True; MultipleActiveResultSets = true;

    MARS不支持ADO.NET 1.0和ADO.NET 1.1。

    7.在连接到SQL Server Express实例时附加一个数据库文件

    Server = .\SQLExpress;AttachDbFilename = c:\asd\qwe\mydbfile.mdf;Database = dbname; Trusted_Connection = Yes;

    这里为什么还需要Database字段呢?因为如果指定的数据库文件已经被附加,那么SQL Server不会再附加它,而使用已附加的数据库作为默认数据库。

    8.在连接到SQL Server Express实例时,从数据目录下附加一个数据库文件

    Server = .\SQLExpress;AttachDbFilename = |DataDirectory|mydbfile.mdf; Database = dbname;Trusted_Connection = Yes;

    9.在本地SQL Server Express实例上使用用户实例

    用户实例这个功能会在连接的过程中,新建一个SQL Server实例。该功能只有在本地SQL Server实例上,且连接时使用通过本地命名通道的Windows认证。这样做的好处是,可以给一个在本地计算机上只有相当有限的管理员权限的用户,新建一个拥有全部权限的SQL Server实例。

    Data Source = .\SQLExpress;Integrated Security = true; AttachDbFilename = |DataDirectory|\mydb.mdf;User Instance = true;

    若想使用用户实例这个功能,需要先在SQL Server将其开启。开启命令为:

    sp_configure 'user instances enabled', '1'

    取消命令为:

    sp_configure 'user instances enabled', '0'

    注:这两条命令只在SQL Server Express中有效。

    10.数据库镜像

    如果你用ADO.NET或者SQL Native Client去连接一个数据库镜像,当这个数据库镜像进行故障切换的时候,你的应用程序可以利用驱动器的特性去自动重定向连接。当然,你必须在连接字段里指定初始的主服务器和数据库,以及用于故障切换的镜像服务器。

    Data Source = myServerAddress;Failover Partner = myMirrorServerAddress;Initial Catalog = myDataBase;Integrated

    Security = True;

    上面的例子只是介绍了一下如何使用数据库镜像,你可以将Failover Partner字段跟其他连接字符串功能组合使用。

    11.异步处理

    Server = myServerAddress;Database = myDataBase;Integrated Security = True;Asynchronous Processing = True;

    二、SQL Server Native Client 10.0 OLE DB Provider

    类型:OLE DB Provider

    使用:Provider=SQLNCLI10

    厂商:Microsoft

    1.标准安全连接

    Provider = SQLNCLI10;Server = myServerAddress;Database = myDataBase;Uid = myUsername; Pwd = myPassword;

    2.信任连接

    Provider = SQLNCLI10;Server = myServerAddress;Database = myDataBase; Trusted_Connection = yes;

    "Integrated Security=SSPI" 和 "Trusted_Connection=yes"是等价的。

    3.连接一个SQL Server实例

    Provider = SQLNCLI10;Server = myServerName\theInstanceName;Database = myDataBase; Trusted_Connection = yes;

    4.用户名、密码提示

    oConn.Properties("Prompt") = adPromptAlways

    oConn.Open "Provider = SQLNCLI10;Server = myServerAddress;DataBase = myDataBase;

    5.开启MARS功能 (multiple active result sets)

    Provider = SQLNCLI10;Server = myServerAddress;Database = myDataBase; Trusted_Connection = yes;MARS Connection = True;

    6.加密模式

    Provider = SQLNCLI10;Server = myServerAddress;Database = myDataBase; Trusted_Connection = yes;Encrypt = yes;

    7.在连接到SQL Server Express实例时附加一个数据库文件

    Provider = SQLNCLI10;Server = .\SQLExpress;AttachDbFilename = c:\asd\qwe\mydbfile.mdf; Database = dbname;

    Trusted_Connection = Yes;

    8.在连接到SQL Server Express实例时,从数据目录下附加一个数据库文件

    Provider = SQLNCLI10;Server = .\SQLExpress;AttachDbFilename = |DataDirectory|mydbfile.mdf;

    Database = dbname;Trusted_Connection = Yes;

    9.数据库镜像

    Provider = SQLNCLI10;Data Source = myServerAddress;Failover Partner = myMirrorServerAddress;Initial

    Catalog = myDataBase;Integrated Security = True;

    三、.NET Framework Data Provider for OLE DB

    类型:.NET Framework Wrapper Class Library

    使用:System.Data.OleDb.OleDbConnection

    厂商:Microsoft

    1.桥接到SQL Native Client OLE DB

    Provider = SQLNCLI10;Server = myServerAddress;Database = myDataBase;Uid = myUsername; Pwd = myPassword;

    四、SQL Server Native Client 10.0 ODBC Driver

    类型:ODBC Driver

    使用:Driver={SQL Server Native Client 10.0}

    厂商:Microsoft

    1.标准安全连接

    Driver = {SQL Server Native Client 10.0};Server = myServerAddress;Database = myDataBase;Uid = myUsername;Pwd = myPassword;

    2.信任连接

    Driver = {SQL Server Native Client 10.0};Server = myServerAddress;Database = myDataBase;Trusted_Connection = yes;

    3.连接一个SQL Server实例

    Driver = {SQL Server Native Client 10.0};Server = myServerName\theInstanceName;

    Database = myDataBase;Trusted_Connection = yes;

    4.用户名、密码提示

    Conn.Properties("Prompt") = adPromptAlways

    Driver = {SQL Server Native Client 10.0};Server = myServerAddress;Database = myDataBase;

    5.开启MARS功能 (multiple active result sets)

    Driver = {SQL Server Native Client 10.0};Server = myServerAddress;Database = myDataBase;Trusted_Connection = yes;

    MARS_Connection = yes;

    6.加密模式

    Driver = {SQL Server Native Client 10.0};Server = myServerAddress;Database = myDataBase;

    Trusted_Connection = yes;Encrypt = yes;

    7.在连接到SQL Server Express实例时附加一个数据库文件

    Driver = {SQL Server Native Client 10.0};Server = .\SQLExpress; AttachDbFilename = c:\asd\qwe\mydbfile.mdf;

    Database = dbname;Trusted_Connection = Yes;

    8.在连接到SQL Server Express实例时,从数据目录下附加一个数据库文件

    Driver={SQL Server Native Client 10.0};Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;

    Database=dbname;Trusted_Connection=Yes;

    9.数据库镜像

    Driver = {SQL Server Native Client

    10.0};Server = myServerAddress;Failover_Partner = myMirrorServerAddress;Database = myDataBase; Trusted_Connection = yes;

    五、.NET Framework Data Provider for ODBC

    类型:.NET Framework Wrapper Class Library

    使用:System.Data.Odbc.OdbcConnection

    厂商:Microsoft

    桥接到SQL Native Client 10.0 ODBC Driver

    下面的语句只是一条例子,不同厂商的ODBC驱动不同。

    Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

    六、SQLXML 4.0 OLEDB Provider

    类型:OLE DB Provider

    使用:Provider=SQLXMLOLEDB.4.0;Data Provider=providername

    厂商:Microsoft

    Provider=SQLXMLOLEDB.4.0;Data Provider=SQLNCLI10;Data Source=myServerAddress;Initial Catalog=myDataBase;User

    Id=myUsername;Password=myPassword;

    七、Context Connection

    类型:.NET Framework Class Library

    使用:

    厂商:Microsoft

    通过当前CLR里的存储过程/函数来连接到“自身”。上下文连接可以让你,在你的代码第一次被调用的地方所在的上下文(连接)里,执行T-SQL语句。

    C#:

    using(SqlConnection connection = new SqlConnection("context connection=true"))

    {

    connection.Open();

    // Use the connection

    }

    VB.Net

    Using connection as new SqlConnection("context connection=true")

    connection.Open()

    ' Use the connection

    End Using

    展开全文
  • 数据库连接字符串的处理方法!加密解密连接字符串。 标签: 数据库加密解密dllvb.netstring 2006-03-04 09:37 6938人阅读 评论(1) 收藏 举报  分类: 数据访问层(8)  版权声明:本文为博...
  • 一、Microsoft Access数据库引擎——Jet、ACE 1、Microsoft.Jet.OLEDB.4.0提供程序 适用于Microsoft Access 2007以前的版本,如Microsoft Access 2000、Microsoft Access 2003等。 2、Microsoft.ACE.OLEDB.12.0...
  • 环境为VS2008 C#或VB ,SQL ,本人已测试通过,有人会说直接把连接串写程序里不就行了,可以不用那个连接串的,确实是这样的,不过只要你的项目中DataSet里有TableAdapter,那么App.config中的连接串就是必不可少的...
  • 工程 >>部件 >>Microsift ADO Data Control 6.0(SP6) (OLEDB) 从工具箱 拖一个 Adodc控件, 邮件 控件属性 ,单击 "使用连接字符串 " 右边的生成,
  • VB 数据库VB 数据库VB 数据库VB 数据库VB 数据库连接数据库连接数据库连接数据库连接数据库连接数据库连接
  • 数据库连接字符串的拼写规则的决定条件:连接的数据库的类型:SQL Server,Oracle,MySQL,Acess,MogoDB,Visual FoxPro(dBASE),Excel数据库驱动器:ODBC,OLE DB连接的模式:标准连接(Standard Security),信任连接...
  • odbc连接数据库字符串

    2021-01-18 23:19:05
    Java JDBC连接数据库桥连:sun.jdbc.odbc.JdbcOdbcDriver连接字符串:("jdbc:odbc:数据源名","sa","sa");纯Java驱动:com.microsoft.jdbc.sqlserver.SQLServerDriver连接字符串:("jdbc:microsoft:sqls...文章_莫非_...
  • sql server数据库连接字符串大全

    千次阅读 2017-03-20 13:27:00
    一、.NET Framework Data Provider for SQL Server 类型:.NET Framework类库 使用:System.Data.SqlClient....1.标准安全连接 复制代码代码如下: Data Source = myServerAddress;Initial Catalog = m
  • 数据库连接字符串大全(MySQL)MyODBCMyODBC 2.50 Local database:"Driver={mySQL};Server=localhost;Option=16834;Database=mydatabase;"MyODBC 2.50 Remote database:"Driver={mySQL};Server=data.domain.com;Port=...
  • 数据库连接字符串大全(解释版)

    千次阅读 2017-05-24 20:29:54
    数据库连接字符串的拼写规则的决定条件: 连接的数据库的类型:SQL Server,Oracle,MySQL,Acess,MogoDB,Visual FoxPro(dBASE),Excel 数据库驱动器:ODBC,OLE DB 连接的模式:标准连接(Standard ...
  • I've been workin on asp with a com+ componente made with VB6.The component is registered via th...
  • 一直都想对app.config下的数据库连接字符串进行加密,因为程序直接调用数据集的时候必需要调用app.config(程序编译后会自动更名为程序文件名.config),如果数据库连接字符串以明文方式放置在那里,将是意见危险的事情...
  • 解决Access连接 accdb 不可识别的数据库格式异常在Access07之前的数据库后缀名均为*.mdb 而连接字符串写成Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\myFolder\*.mdb;Persist Security Info=False;但是Access...
  • Note: You can also create the DSN via VB code. 2) Then use the following connection string - with your own DSN name of course. -) --------------------------------------------------------------------...
  • VB6.0连接MySQL数据库

    2015-08-20 20:20:26
    新手使用VB6.0连接MySQL数据库,资料出自原创,思路清晰,步骤详细!
  • 最近在做一个数据库的综合性实验,我之前用的都是Oracle的SQL developer来设计数据库,所以想...下载好并配置好一个数据库后,接下来就是用c#连接数据库了。下面是我的连接代码 class Dao { SqlConnection sc; pub
  • 一般来说,VB访问远程后台数据库有好多方法可以实现,目前使用的比较多的方法有:ODBC(开放数据库互联),OO4O(Oracle的OLE对象) 。由于ODBC技术有一个致命的缺点—速度慢。OO4O是一种进程中的OLE服务器,但是它不使用ODBC...
  • 我们在做VB数据库经典实例这本书上的五个小例子和做学生信息管理系统时,都需要通过Vb链接数据库,在众多的链接方式中connectionstring字符串应该是较为简单的一种方式,下面我来详细介绍它的一些属性。 1. 使用...
  • 一、存取数据库的原理在ASP中,用来存取数据库的对象统称ADO对象(Active Data Objects),主要含有三种对象:Connection、Recordset和Command,其中Connection负责打开或连接数据库,Recordset负责存取数据表,...
  • 一、.NET Framework Data Provider for SQL Server类型:.NET Framework类库使用:System.Data.SqlClient.SqlConnection厂商:Microsoft标准安全连接Data Source = myServerAddress;Initial Catalog = myDataBase;...
  • <% '定义一个变量,用于数据库连接  dim...其中,Open方法后面的参数即为我们通常所说的数据库连接字符串,这里主要设置了该字符串的两个参数,一个是Dbq,一个是Driver,这是使用的ODBC方式来连接数据

空空如也

空空如也

1 2 3 4 5 ... 20
收藏数 17,191
精华内容 6,876
关键字:

vb数据库连接字符串