当前位置：网站首页>ASP connect MSSQL database statement

ASP connect MSSQL database statement

2022-04-22 22:53:00 【Glacier Technology】

ASP And MSSQL 2012  Enterprise connection string 

      
      

       
       ConnStr
       
       =
       
       "Provider=SQLOLEDB;Data Source=127.0.0.1;Initial Catalog=westrac;User Id=sa;Pwd=ssddddHzx;"
      
      

      
      
    
       
       
  • 1.
    •

ASP And MSSQL 2008 Enterprise connection string 

      
      

       
       ConnStr
       
       =
       
       "driver={SQL Server};Server=.;database=gas;uid=sa;pwd=123456"
      
      

      
      
    
       
       
  • 1.
    •

ASP And MSSQL 2005 Enterprise connection string 

      
      

       
       connstr
       
       =
       
       "driver={SQL Server};Server=.;database=site_fsb;uid=sa;pwd=123456"
      
      

      
      
    
       
       
  • 1.
    •

ASP And MSSQL 2000 Enterprise connection string 

      
      

       
       ConnStr
       
       =
       
       "Provider=SQLOLEDB;Data Source=127.0.0.1;Initial Catalog=westrac;User Id=sa;Password=ssddddHzx;"
      
      

      
      
    
       
       
  • 1.
    •

32 Bit operating system connection address 

      
      

       
       ConnStr
       
       =
       
       "Provider = Sqloledb; User ID = " 
       
       & datauser 
       
       & 
       
       "; Password = " 
       
       & databasepsw 
       
       & 
       
       "; Initial Catalog = " 
       
       & databasename 
       
       & 
       
       "; Data Source = " 
       
       & dataserver 
       
       & 
       
       ";"
      
      

      
      
    
       
       
  • 1.
    •

64 Bit operating system connection address 

      
      

       
       ConnStr
       
       =
       
       "PROVIDER=SQLOLEDB;DATA SOURCE=" 
       
       & dataserver 
       
       & 
       
       ";UID=" 
       
       & datauser 
       
       & 
       
       ";PWD=" 
       
       & databasepsw 
       
       & 
       
       ";DATABASE="
       
       & databasename 
       
       &
       
       ";"
      
      

      
      
    
       
       
  • 1.
    •


版权声明
本文为[Glacier Technology]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204222141069399.html

边栏推荐

猜你喜欢

随机推荐