Server Upgrade

Results 1 to 2 of 2

Thread: Server Upgrade

  1. #1
    Join Date
    Dec 1969

    Default Server Upgrade

    Hi<BR>I am having MSSQL 7.0 presently which i am using as a DATA BASE, but i had to collect some information from other DATA BASE which is running on MSSQL 2000. If i try to connect to that DATA BASE (MSSQL 2000)it shows me that you have to upgarde your MSSQL 7.0 to MSSQL 2000. Is there any possiblity of reteriving the data from MSSQL 2000

  2. #2
    Join Date
    Dec 1969

    Default RE: Server Upgrade

    So what your saying is that your trying to collect data from an MSSQL 7.0 and MSSQL 2000 database. That should not be a problem.<BR>You probably should use two connection objects.<BR>&#060;%<BR><BR>Dim objConn<BR>Dim objconn2<BR><BR>objConn = Server.CreateObject("ADODB.Connection")<BR>objConn 2 = Server.CreateObject("ADODB.Connection")<BR><BR>obj Conn.Open("Provider=SQLOLEDB; Data Source=(local); Initial Catalog=pubs; User ID=sa")<BR><BR>objConn2.Open("Provider=SQLOLEDB; Data Source=(local); Initial Catalog=pubs; User ID=sa")<BR><BR>%&#062;<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts