ms sql 7

by Don Grove » Tue, 12 Jun 2001 11:44:59

What are the limitations of the evaluation version, what can't I do ?
Don

1. Connecting to Sql Server from asp after upgrade from ms sql 7 to ms sql 2000

I am using a distant webhoster to run a classic asp program (not .net) which
used to connect to an sql server database again which they hosted.

A dsnless connection string similair to the following worked fine:

strCon = "Provider=sqloledb;" & _ "Data Source=233.77.166.2;" & _ "Network
Library=dbnmpntw;" & _ "Initial Catalog=databaseexample;" & _ "User
ID=webmasterofsite;" & _ "Password=4444;"

The strings details have been changed for security purposes but are similair
in type to the real string.

Now on the webhoster upgrading to sql server 2000 this connection string
stopped working.

However I can still connect using the same ip address and login details
through sql 2000 enterprise manager and through the access adp front end.

The error message I now get through asp is:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.

Here is the full code for the connection routine:

strCon = "Provider=sqloledb;"
& _ "Data Source=233.77.166.2;"
& _ "Network Library=dbnmpntw;"
& _ "Initial Catalog=databaseexample;"
& _ "User ID=webmasterofsite;"
& _ "Password=4444;"
set Con = server.CreateObject("adodb.Connection")
con.open strCon

set rs = con.execute("update counter set HitCount = ((HitCount) + 1) where
ID = 1")

con.close
set rs = nothing
set con = nothing
if Request.Cookies("publicregistered")="True" then
Response.Redirect("startSql.asp")
end if

Thanks

Jonathan

2. DATE functions

3. OLEDB Returns HResult Error to VB When Using SQL Server 7

4. How to Link MS Sql 6.5 to MS Sql 7.0

5. HELP: Roll up hour data

6. MS SQL 2000 vs MS SQL 7

7. MS SQL 2000 to MS SQL 6.5

8. Documents about the changes from MS SQL 6.5 to MS SQL 2000

9. MS SQL 6.0 to MS SQL 7 Across Wire Migration