SQL连接字符串

最新推荐文章于 2025-02-04 10:29:29 发布

wangyh76

最新推荐文章于 2025-02-04 10:29:29 发布

阅读量4.7k

点赞数

分类专栏： VC++ 文章标签： sql sql server null 数据库 database access

本文链接：https://blog.youkuaiyun.com/wangyh76/article/details/1777563

版权

VC++ 专栏收录该内容

36 篇文章

订阅专栏

//连接Sql server数据库
//            m_pConnection->Open("driver={SQL server};server=(local);UID=sa;PWD=sa;database=DAS","","",NULL);
//连接access数据库
    //    m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C://db1.mdb","","",adModeUnknown);
//    m_pConnection->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C://db1.mdb;Jet OLEDB:Database Password=123456","","",adModeUnknown);
//连接本机SQLEXPRESS
        //    m_pConnection->Open("Provider=SQLNCLI;server=localhost//SQLEXPRESS;UID=sa;PWD=xzgr;database=DAS","","",NULL);
//连接远程SQLEXPRESS
        m_pConnection->Open("Provider=SQLOLEDB;server=221.137.187.224//SQLEXPRESS,1433;UID=sa;PWD=;database=","","",NULL);