ms sql 7

ms sql 7

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

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

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=;" & _ "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

Here is the full code for the connection routine:

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

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

 set rs = nothing
 set con = nothing
if Request.Cookies("publicregistered")="True" then
end if



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

10. Making a MS-SQL 6.5 compatible database with MS-SQL 7.0

11. Converting MS SQL to MS SQL CE