asp connection problem

I am having a problem getting my asp pages to connect.

My database is MS SQL 2000 sp4
MDAC is 2.8
IIS is 6 - Authentication is Anonomous

MS SQL authentication is on Mixed

I get this error on the test page.

Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
/first-pass/test.asp, line 10

What am I missing?


testpage.asp

cst = "Provider=SQLOLEDB.1;Password=;Persist Security
Info=True;User ID=;Initial Catalog=First Pass;Data
Source="




set conn = server.createobject("adodb.connection")
conn.open cst

conn.Close
set conn = Nothing

Re: asp connection problem

First, using Query Analyzer or something like that, make sure you can
connect to the database server with this same login credentials in your
code. If you can, try using the IP address of the server in your code to
see if that works. If that was the problem, either keep using the IP, or
have your network admins ensure that DNS and/or WINS entries are properly on
the IIS server.

Ray at work

"Mike" wrote in message
news:ABC0440A-5425-4711-A1AE-55EE80F6028A@microsoft.com...
>I am having a problem getting my asp pages to connect.
>
> My database is MS SQL 2000 sp4
> MDAC is 2.8
> IIS is 6 - Authentication is Anonomous
>
> MS SQL authentication is on Mixed
>
> I get this error on the test page.
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
> denied.
> /first-pass/test.asp, line 10
>
> What am I missing?
>
>
> testpage.asp
>
> cst = "Provider=SQLOLEDB.1;Password=;Persist Security
> Info=True;User ID=;Initial Catalog=First Pass;Data
> Source="
>
>
>
>
> set conn = server.createobject("adodb.connection")
> conn.open cst
>
> conn.Close
> set conn = Nothing

RE: asp connection problem

I just found out the default port is set to 1439. How do I put that in my
connection string. TCP/Ip is enabled


"Mike" wrote:

> I am having a problem getting my asp pages to connect.
>
> My database is MS SQL 2000 sp4
> MDAC is 2.8
> IIS is 6 - Authentication is Anonomous
>
> MS SQL authentication is on Mixed
>
> I get this error on the test page.
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
> denied.
> /first-pass/test.asp, line 10
>
> What am I missing?
>
>
> testpage.asp
>
> cst = "Provider=SQLOLEDB.1;Password=;Persist Security
> Info=True;User ID=;Initial Catalog=First Pass;Data
> Source="
>
>
>
>
> set conn = server.createobject("adodb.connection")
> conn.open cst
>
> conn.Close
> set conn = Nothing

Re: asp connection problem

try the IP or server name, then a comma, then the port number

example 205.34.345.34,1439
example sql.someserver.com,1439

same when trying to connect to the sql server via something like query
manager


"Mike" wrote in message
news:F8A04380-0BAA-4B7A-AE77-DA612D8F78BB@microsoft.com...
>I just found out the default port is set to 1439. How do I put that in my
> connection string. TCP/Ip is enabled
>
>
> "Mike" wrote:
>
>> I am having a problem getting my asp pages to connect.
>>
>> My database is MS SQL 2000 sp4
>> MDAC is 2.8
>> IIS is 6 - Authentication is Anonomous
>>
>> MS SQL authentication is on Mixed
>>
>> I get this error on the test page.
>>
>> Microsoft OLE DB Provider for SQL Server error '80004005'
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> access
>> denied.
>> /first-pass/test.asp, line 10
>>
>> What am I missing?
>>
>>
>> testpage.asp
>>
>> cst = "Provider=SQLOLEDB.1;Password=;Persist Security
>> Info=True;User ID=;Initial Catalog=First Pass;Data
>> Source="
>>
>>
>>
>>
>> set conn = server.createobject("adodb.connection")
>> conn.open cst
>>
>> conn.Close
>> set conn = Nothing