Very Computer

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

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
..Offering free scripts & code snippits for everyone...
---------------------------------------------------------

Quote:> 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

Quote:> 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;"

Also, since the remote SQL Server is behind a firewall, then make your
ISP opens port 1433.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269882

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com

I forced named pipes because that was the only way I got the string to work
on sql 7 for some reason.

If I use Network=DBMSSOCN, then I get the following error page:

Provider error '80040e21'

Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done.

/Default.asp, line 33

Jonathan

Quote:> strCon =

Quote:> mple;UID=webmasterOfSite;PWD=4444"

> Follow-ups trimmed.

If they switched to Windows Authentification then how come I can log in with
the same passwords and user names in Enterprise Manager or an MS Access adp
project?

It is only from the ado string in Asp I get the problem.
Doesn't this disprove your theory?

Thanks

Jonathan
...

Quote:> If I use Network=DBMSSOCN, then I get the following error page:

> Provider error '80040e21'

> Multiple-step OLE DB operation generated errors. Check each OLE DB status
> value, if available. No work was done.

Also see http://www.aspfaq.com/2288

Hi Carl,

1) adding ,1433 did not help
2) port  1433 is open on the webhoster

Anyone have any other ideas?

Thanks

Jonathan

Quote:> Assuming the remote SQL Server database is using "Mixed" security,
> then make sure to specify the port number after the DataSource IP.
> e.g.  "Data Source=xxx.xxx.xxx.xxx,1433;"
> http://www.able-consulting.com/ADO_Conn.htm#OLEDBProviderForSQLServerIP

> Also, since the remote SQL Server is behind a firewall, then make your
> ISP opens port 1433.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q269882

> --

> Thanks,
> Carl Prothman
> Microsoft ASP.NET MVP
> http://www.able-consulting.com

Jeff

Quote:> Hi Aron,

> I forced named pipes because that was the only way I got the string to
work
> on sql 7 for some reason.

> If I use Network=DBMSSOCN, then I get the following error page:

> Provider error '80040e21'

> Multiple-step OLE DB operation generated errors. Check each OLE DB status
> value, if available. No work was done.

> /Default.asp, line 33

> Jonathan

> > strCon =

Quote:> > mple;UID=webmasterOfSite;PWD=4444"

> > Follow-ups trimmed.

--
----------------------------------------------------------
Curt Christianson (Software_AT_Darkfalz.Com)
Owner/Lead Designer, DF-Software
http://www.Darkfalz.com
---------------------------------------------------------
..Offering free scripts & code snippits for everyone...
---------------------------------------------------------

Quote:> 1) adding ,1433 did not help
> 2) port  1433 is open on the webhoster

> Anyone have any other ideas?

While you're in there you can always setup an Alias for your IP data source.
Again, make sure TCP/IP is selected and the port number is correct.

--

Thanks,
Carl Prothman
Microsoft ASP.NET MVP
http://www.able-consulting.com