|
 |
asp_databases thread: IIS and SQLServer in different servers
Message #1 by andre.scaldaferri@c... on Mon, 7 Jan 2002 13:18:47
|
|
Hello
I have an application that is trying to acess an SQLServer database that
is hosted on other server, but every time i got an error message:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]Specified SQL server not found.
/subasta/db.asp, line 4
That's the code that I use to connect to the SQLServer database
set dbobj = server.CreateObject("ADODB.Connection")
l_dsource = "BZSAES02"
DBObj.Open "Provider=sqloledb;DataSource=" & l_dsource & ",1433;Initial
Catalog=ARGENTINA;User ID=web; Password=;"
Should I install the sqlserver drivers on the machine that IIS is
installed?
Does anybody have an ideia of what i am doing wrong??
TIA
Andre
Message #2 by "Matteo Lonardi" <mlonardi@h...> on Mon, 7 Jan 2002 14:27:24 +0100
|
|
Is there any firewall between IIS server and SQL server?
Bye
Matteo
----- Original Message -----
From: <andre.scaldaferri@c...>
To: "ASP Databases" <asp_databases@p...>
Sent: Monday, January 07, 2002 1:18 PM
Subject: [asp_databases] IIS and SQLServer in different servers
> Hello
>
> I have an application that is trying to acess an SQLServer database that
> is hosted on other server, but every time i got an error message:
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
> [DBNMPNTW]Specified SQL server not found.
> /subasta/db.asp, line 4
>
> That's the code that I use to connect to the SQLServer database
>
> set dbobj = server.CreateObject("ADODB.Connection")
> l_dsource = "BZSAES02"
> DBObj.Open "Provider=sqloledb;DataSource=" & l_dsource & ",1433;Initial
> Catalog=ARGENTINA;User ID=web; Password=;"
>
> Should I install the sqlserver drivers on the machine that IIS is
> installed?
> Does anybody have an ideia of what i am doing wrong??
>
> TIA
>
> Andre
$subst('Email.Unsub').
>
Message #3 by andre.scaldaferri@c... on Mon, 7 Jan 2002 13:37:15
|
|
No, no firewall, no proxy...nothing...Just two different machines..
> Is there any firewall between IIS server and SQL server?
> Bye
>
> Matteo
>
> ----- Original Message -----
> From: <andre.scaldaferri@c...>
> To: "ASP Databases" <asp_databases@p...>
> Sent: Monday, January 07, 2002 1:18 PM
> Subject: [asp_databases] IIS and SQLServer in different servers
>
>
> > Hello
> >
> > I have an application that is trying to acess an SQLServer database
that
> > is hosted on other server, but every time i got an error message:
> >
> > Microsoft OLE DB Provider for SQL Server error '80004005'
> > [DBNMPNTW]Specified SQL server not found.
> > /subasta/db.asp, line 4
> >
> > That's the code that I use to connect to the SQLServer database
> >
> > set dbobj = server.CreateObject("ADODB.Connection")
> > l_dsource = "BZSAES02"
> > DBObj.Open "Provider=sqloledb;DataSource=" & l_dsource & ",1433;Initial
> > Catalog=ARGENTINA;User ID=web; Password=;"
> >
> > Should I install the sqlserver drivers on the machine that IIS is
> > installed?
> > Does anybody have an ideia of what i am doing wrong??
> >
> > TIA
> >
> > Andre
> $subst('Email.Unsub').
> >
Message #4 by "Daniel O'Dorisio" <daniel@o...> on Mon, 7 Jan 2002 09:06:20 -0500
|
|
i think it has somethign to do with the network library. both systems are
not using the same or something like that.. you may wanna check into that.
also.. why are you putting the datasource and then a ,1433?? try without
that ,1433 and you may have luck. cause i think even if you wanna specify
the port you would use a :1433 from what i know.. but i could be wrong..
daniel
--
-----------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
-----------------------------
<andre.scaldaferri@c...> wrote in message news:133426@a..._databases...
:
: No, no firewall, no proxy...nothing...Just two different machines..
:
:
: > Is there any firewall between IIS server and SQL server?
: > Bye
: >
: > Matteo
: >
: > ----- Original Message -----
: > From: <andre.scaldaferri@c...>
: > To: "ASP Databases" <asp_databases@p...>
: > Sent: Monday, January 07, 2002 1:18 PM
: > Subject: [asp_databases] IIS and SQLServer in different servers
: >
: >
: > > Hello
: > >
: > > I have an application that is trying to acess an SQLServer database
: that
: > > is hosted on other server, but every time i got an error message:
: > >
: > > Microsoft OLE DB Provider for SQL Server error '80004005'
: > > [DBNMPNTW]Specified SQL server not found.
: > > /subasta/db.asp, line 4
: > >
: > > That's the code that I use to connect to the SQLServer database
: > >
: > > set dbobj = server.CreateObject("ADODB.Connection")
: > > l_dsource = "BZSAES02"
: > > DBObj.Open "Provider=sqloledb;DataSource=" & l_dsource &
",1433;Initial
: > > Catalog=ARGENTINA;User ID=web; Password=;"
: > >
: > > Should I install the sqlserver drivers on the machine that IIS is
: > > installed?
: > > Does anybody have an ideia of what i am doing wrong??
: > >
: > > TIA
: > >
: > > Andre
: > $subst('Email.Unsub').
: > >
:
:
Message #5 by "Craig Flannigan" <ckf@k...> on Mon, 7 Jan 2002 14:18:19 -0000
|
|
Hi,
There is no need to specify the port number if the SQL Server was left on
that Port number during installation.
Check that you can ping the SQL Server machine from your IIS machine. Also,
both machines need the same library as mentioned before.
TCP/IP works better than named_pipes, but that's on our network. We couldn't
get the two servers to see each other on anything but TCP_IP.
HTH.
Craig.
-----Original Message-----
From: Daniel O'Dorisio [mailto:daniel@o...]
Sent: Monday 7 January 2002 14:06
To: ASP Databases
Subject: [asp_databases] Re: IIS and SQLServer in different servers
i think it has somethign to do with the network library. both systems are
not using the same or something like that.. you may wanna check into that.
also.. why are you putting the datasource and then a ,1433?? try without
that ,1433 and you may have luck. cause i think even if you wanna specify
the port you would use a :1433 from what i know.. but i could be wrong..
daniel
--
-----------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
-----------------------------
<andre.scaldaferri@c...> wrote in message news:133426@a..._databases...
:
: No, no firewall, no proxy...nothing...Just two different machines..
:
:
: > Is there any firewall between IIS server and SQL server?
: > Bye
: >
: > Matteo
: >
: > ----- Original Message -----
: > From: <andre.scaldaferri@c...>
: > To: "ASP Databases" <asp_databases@p...>
: > Sent: Monday, January 07, 2002 1:18 PM
: > Subject: [asp_databases] IIS and SQLServer in different servers
: >
: >
: > > Hello
: > >
: > > I have an application that is trying to acess an SQLServer database
: that
: > > is hosted on other server, but every time i got an error message:
: > >
: > > Microsoft OLE DB Provider for SQL Server error '80004005'
: > > [DBNMPNTW]Specified SQL server not found.
: > > /subasta/db.asp, line 4
: > >
: > > That's the code that I use to connect to the SQLServer database
: > >
: > > set dbobj = server.CreateObject("ADODB.Connection")
: > > l_dsource = "BZSAES02"
: > > DBObj.Open "Provider=sqloledb;DataSource=" & l_dsource &
",1433;Initial
: > > Catalog=ARGENTINA;User ID=web; Password=;"
: > >
: > > Should I install the sqlserver drivers on the machine that IIS is
: > > installed?
: > > Does anybody have an ideia of what i am doing wrong??
: > >
: > > TIA
: > >
: > > Andre
: > $subst('Email.Unsub').
: > >
:
:
$subst('Email.Unsub').
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
Message #6 by "Daniel O'Dorisio" <daniel@o...> on Mon, 7 Jan 2002 09:29:57 -0500
|
|
yeah ok.. here is a lil more info.. i just went out and double checked my
last email and here is some stuff:
<quote
src="http://www.able-onsulting.com/ADO_Conn.htm#OLEDBProviderForSQLServer">
To connect to SQL Server running on a remote computer ( via an IP address):
oConn.Open "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=xxx.xxx.xxx.xxx,1433;" & _
"Initial Catalog=myDatabaseName;" & _
"User ID=myUsername;" & _
"Password=myPassword;"
Where:
- "Network Library=DBMSSOCN" tells OLE DB to use TCP/IP rather than Named
Pipes (Q238949)
- xxx.xxx.xxx.xxx is an IP address
- 1433 is the default port number for SQL Server.
- You can also add "Encrypt=yes" for encryption
</quote>
so you were right the ,1433 is correct for specifying a port number.. my
bad.. but anyway.. since it looks like you are trying to use tcp/ip you will
want to make sure you server is set approprately with the network library
and then use that Network Library section of the conn string..
hth
daniel
--
-----------------------------
Daniel O'Dorisio
daniel@o...
www.odorisio-networks.com
-----------------------------
"Daniel O'Dorisio" <daniel@o...> wrote in message
news:133454@a..._databases...
:
: i think it has somethign to do with the network library. both systems are
: not using the same or something like that.. you may wanna check into that.
:
: also.. why are you putting the datasource and then a ,1433?? try without
: that ,1433 and you may have luck. cause i think even if you wanna specify
: the port you would use a :1433 from what i know.. but i could be wrong..
:
: daniel
:
: --
: -----------------------------
: Daniel O'Dorisio
: daniel@o...
: www.odorisio-networks.com
: -----------------------------
: <andre.scaldaferri@c...> wrote in message news:133426@a..._databases...
: :
: : No, no firewall, no proxy...nothing...Just two different machines..
: :
: :
: : > Is there any firewall between IIS server and SQL server?
: : > Bye
: : >
: : > Matteo
: : >
: : > ----- Original Message -----
: : > From: <andre.scaldaferri@c...>
: : > To: "ASP Databases" <asp_databases@p...>
: : > Sent: Monday, January 07, 2002 1:18 PM
: : > Subject: [asp_databases] IIS and SQLServer in different servers
: : >
: : >
: : > > Hello
: : > >
: : > > I have an application that is trying to acess an SQLServer database
: : that
: : > > is hosted on other server, but every time i got an error message:
: : > >
: : > > Microsoft OLE DB Provider for SQL Server error '80004005'
: : > > [DBNMPNTW]Specified SQL server not found.
: : > > /subasta/db.asp, line 4
: : > >
: : > > That's the code that I use to connect to the SQLServer database
: : > >
: : > > set dbobj = server.CreateObject("ADODB.Connection")
: : > > l_dsource = "BZSAES02"
: : > > DBObj.Open "Provider=sqloledb;DataSource=" & l_dsource &
: ",1433;Initial
: : > > Catalog=ARGENTINA;User ID=web; Password=;"
: : > >
: : > > Should I install the sqlserver drivers on the machine that IIS is
: : > > installed?
: : > > Does anybody have an ideia of what i am doing wrong??
: : > >
: : > > TIA
: : > >
: : > > Andre
: : > $subst('Email.Unsub').
: : > >
: :
: :
:
:
:
:
|
|
|
View Cart
