List Info

Thread: ClassicASPConnectionToSQLServer2005
ClassicASPConnectionToSQLServer2005
country flaguser name
United States		 2007-09-06 13:03:27 

  


  

    
I have working on upgrading our database server from 2000 to 2005. There
are problems on the database connection from classic ASP to SQL Server
2005. All the database connections worked for SQL 2000 do not work for
SQL Server 2005. I used the following connection string: 


strConn="Provider=SQLOLEDB;Data Source=ServerName;Initial
Catalog=DatabaseName; User Id=XXX;Password=XXXXX"


At Database server end, I have configured SQL Server 2005 to allow remote
connections. I have turned on the SQL Server Browser Service.


I have made some changes on the connection string parameters. However, it
still does not work. Have you encountered this problem? Any suggestions
on this issue?


Thanks,


Xing






Career Center

career counseling
«
internships
«
jobs
«
graduate school services
«
serving freshmen through PhDs & alumni 



Xing Li

Applications Developer

University of California, Berkeley


2111 Bancroft Way #4350

Berkeley, CA 94720-4350


xingliberkeley.edu

Phone: 510-643-3872

Fax:    ;510-643-6120


http://career.berkeley.edu



  

  
  
   
     
    






 [1]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )