How can I connect to a named instance from a client. I believe the problem
is bcos of the port number.. When i connect to computername\instancename it
says SQL Server does not exist or access denied. However when i register an
alias in client network utility with the instance name and the actual port
number it works fine, but i have to use the alias.
Can i not register with the instance name directly without setting it up
thru the client network utility ? Please advice..
Your client system likely has an older version of MDAC. Install MDAC 2.6 or
higher to connect to a named instance without requiring an alias.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ud6L39KLEHA.2100@.TK2MSFTNGP10.phx.gbl...
> How can I connect to a named instance from a client. I believe the problem
> is bcos of the port number.. When i connect to computername\instancename
it
> says SQL Server does not exist or access denied. However when i register
an
> alias in client network utility with the instance name and the actual port
> number it works fine, but i have to use the alias.
> Can i not register with the instance name directly without setting it up
> thru the client network utility ? Please advice..
>
|||> Your client system likely has an older version of MDAC. Install MDAC 2.6
> or
> higher to connect to a named instance without requiring an alias.
Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
2.6 was released, but I know I was able to connect to named instances before
I ever worried about what version of MDAC was installed, and that was some
time ago.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
|||Does that mean that with the latest MDAC, the client would dynamically
determine the port of the named instance ?
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
2.6
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
|||From BOL "Each instance of Microsoft SQL ServerT 2000 listens on a unique
set of network address so that applications can connect to different
instances"
What does this mean ? What is this n/w address ? If i have 2 instances( one
default and the other named ) , what are the 2 network addresses ? It cant
be IP right ? So what is it ? Thanks
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
2.6
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
|||I am not sure it MDAC 2.6 is the breakover point, but it is around that
version. I will try and see if I can find it.
SQL listens on all IP addresses that exist at service startup. Each
instance has its own port. A clustered instance has its own IP address and
port number, since the IP address is unique to the virtual server. MDAC 2.6
and above does resolve names and port numbers automagically.
GNH
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> From BOL "Each instance of Microsoft SQL ServerT 2000 listens on a unique
> set of network address so that applications can connect to different
> instances"
> What does this mean ? What is this n/w address ? If i have 2 instances(
one[vbcol=seagreen]
> default and the other named ) , what are the 2 network addresses ? It cant
> be IP right ? So what is it ? Thanks
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> 2.6
MDAC[vbcol=seagreen]
> before
some
>
|||It is indirectly documented here:
INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
Version's Client Tools
http://support.microsoft.com/default...&Product=sql2k
The MORE INFORMATION section begins with a statement that MDAC 2.6 is
required to connect to a named instance in \\computer_name\instance_name
format. The article then goes on to describe a workaround.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
2.6
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
|||Ah, I see, this wasn't really specified, as I use computername\instance_name
(not \\computername\instance_name) over TCP/IP all the time, and
http://www.aspfaq.com/2126 has recommended the \instance_name syntax since
long before MDAC 2.6 (1999 or 2000 sometime). I'm talking about connecting
to SQL Server from, for example, ASP or VB, over TCP/IP, not named pipes.
Sorry about the confusion.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OJzZU3MLEHA.3808@.TK2MSFTNGP12.phx.gbl...
> It is indirectly documented here:
> INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
> Version's Client Tools
> http://support.microsoft.com/default...&Product=sql2k
> The MORE INFORMATION section begins with a statement that MDAC 2.6 is
> required to connect to a named instance in \\computer_name\instance_name
> format. The article then goes on to describe a workaround.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> 2.6
> before
>
|||Let me rephrase, 2000 sometime. I thought MDAC 2.6 was introduced much
later than SQL Server 2000, but I must be remembering incorrectly.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
|||2.6 was the release with RTM SQL 2000
--snip
Release Version Number
MDAC 2.6 RTM (2.60.6526.3), September 2000
Release Function
This release provides, directly to the public, the same version of MDAC
released with Microsoft SQL ServerT 2000.
--snip
Snipped from:
Release Manifest for MDAC 2.6 RTM (2.60.6526.3)
http://support.microsoft.com/default...tmmanifest.asp
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23TxVKBNLEHA.3012@.tk2msftngp13.phx.gbl...
> Let me rephrase, 2000 sometime. I thought MDAC 2.6 was introduced much
> later than SQL Server 2000, but I must be remembering incorrectly.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
sqlsql
Showing posts with label number. Show all posts
Showing posts with label number. Show all posts
Thursday, 22 March 2012
connect to named instances
How can I connect to a named instance from a client. I believe the problem
is bcos of the port number.. When i connect to computername\instancename it
says SQL Server does not exist or access denied. However when i register an
alias in client network utility with the instance name and the actual port
number it works fine, but i have to use the alias.
Can i not register with the instance name directly without setting it up
thru the client network utility ? Please advice..Your client system likely has an older version of MDAC. Install MDAC 2.6 or
higher to connect to a named instance without requiring an alias.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ud6L39KLEHA.2100@.TK2MSFTNGP10.phx.gbl...
> How can I connect to a named instance from a client. I believe the problem
> is bcos of the port number.. When i connect to computername\instancename
it
> says SQL Server does not exist or access denied. However when i register
an
> alias in client network utility with the instance name and the actual port
> number it works fine, but i have to use the alias.
> Can i not register with the instance name directly without setting it up
> thru the client network utility ? Please advice..
>|||> Your client system likely has an older version of MDAC. Install MDAC 2.6
> or
> higher to connect to a named instance without requiring an alias.
Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
2.6 was released, but I know I was able to connect to named instances before
I ever worried about what version of MDAC was installed, and that was some
time ago.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Does that mean that with the latest MDAC, the client would dynamically
determine the port of the named instance ?
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > Your client system likely has an older version of MDAC. Install MDAC
2.6
> > or
> > higher to connect to a named instance without requiring an alias.
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on a unique
set of network address so that applications can connect to different
instances"
What does this mean ? What is this n/w address ? If i have 2 instances( one
default and the other named ) , what are the 2 network addresses ? It cant
be IP right ? So what is it ? Thanks
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > Your client system likely has an older version of MDAC. Install MDAC
2.6
> > or
> > higher to connect to a named instance without requiring an alias.
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||I am not sure it MDAC 2.6 is the breakover point, but it is around that
version. I will try and see if I can find it.
SQL listens on all IP addresses that exist at service startup. Each
instance has its own port. A clustered instance has its own IP address and
port number, since the IP address is unique to the virtual server. MDAC 2.6
and above does resolve names and port numbers automagically.
GNH
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on a unique
> set of network address so that applications can connect to different
> instances"
> What does this mean ? What is this n/w address ? If i have 2 instances(
one
> default and the other named ) , what are the 2 network addresses ? It cant
> be IP right ? So what is it ? Thanks
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > Your client system likely has an older version of MDAC. Install MDAC
> 2.6
> > > or
> > > higher to connect to a named instance without requiring an alias.
> >
> > Is this documented somewhere Geoff? I don't remember *exactly* when
MDAC
> > 2.6 was released, but I know I was able to connect to named instances
> before
> > I ever worried about what version of MDAC was installed, and that was
some
> > time ago.
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
>|||It is indirectly documented here:
INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
Version's Client Tools
http://support.microsoft.com/default.aspx?scid=kb;en-us;265808&Product=sql2k
The MORE INFORMATION section begins with a statement that MDAC 2.6 is
required to connect to a named instance in \\computer_name\instance_name
format. The article then goes on to describe a workaround.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > Your client system likely has an older version of MDAC. Install MDAC
2.6
> > or
> > higher to connect to a named instance without requiring an alias.
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||Ah, I see, this wasn't really specified, as I use computername\instance_name
(not \\computername\instance_name) over TCP/IP all the time, and
http://www.aspfaq.com/2126 has recommended the \instance_name syntax since
long before MDAC 2.6 (1999 or 2000 sometime). I'm talking about connecting
to SQL Server from, for example, ASP or VB, over TCP/IP, not named pipes.
Sorry about the confusion.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OJzZU3MLEHA.3808@.TK2MSFTNGP12.phx.gbl...
> It is indirectly documented here:
> INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
> Version's Client Tools
> http://support.microsoft.com/default.aspx?scid=kb;en-us;265808&Product=sql2k
> The MORE INFORMATION section begins with a statement that MDAC 2.6 is
> required to connect to a named instance in \\computer_name\instance_name
> format. The article then goes on to describe a workaround.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
>> > Your client system likely has an older version of MDAC. Install MDAC
> 2.6
>> > or
>> > higher to connect to a named instance without requiring an alias.
>> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
>> 2.6 was released, but I know I was able to connect to named instances
> before
>> I ever worried about what version of MDAC was installed, and that was
>> some
>> time ago.
>> --
>> Aaron Bertrand
>> SQL Server MVP
>> http://www.aspfaq.com/
>>
>|||Let me rephrase, 2000 sometime. I thought MDAC 2.6 was introduced much
later than SQL Server 2000, but I must be remembering incorrectly.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||2.6 was the release with RTM SQL 2000
--snip
Release Version Number
MDAC 2.6 RTM (2.60.6526.3), September 2000
Release Function
This release provides, directly to the public, the same version of MDAC
released with Microsoft SQL ServerT 2000.
--snip
Snipped from:
Release Manifest for MDAC 2.6 RTM (2.60.6526.3)
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/mdac/2.6/rtmmanifest.asp
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23TxVKBNLEHA.3012@.tk2msftngp13.phx.gbl...
> Let me rephrase, 2000 sometime. I thought MDAC 2.6 was introduced much
> later than SQL Server 2000, but I must be remembering incorrectly.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>|||Thanks, at least it's just my memory that's messed up. Math and depth
perception are still functioning okay. ;-)
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
> 2.6 was the release with RTM SQL 2000|||Memory is fine here. Sanity is another question, but that has been an open
issue for a very long time.
GNH
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:urFfumNLEHA.2396@.TK2MSFTNGP12.phx.gbl...
> Thanks, at least it's just my memory that's messed up. Math and depth
> perception are still functioning okay. ;-)
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> > 2.6 was the release with RTM SQL 2000
>|||So i have to specify the port number then to connect thru EM from a client.
Am i right ? I tried this computername\instancename,port and it worked
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:u7SZgkMLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> I am not sure it MDAC 2.6 is the breakover point, but it is around that
> version. I will try and see if I can find it.
> SQL listens on all IP addresses that exist at service startup. Each
> instance has its own port. A clustered instance has its own IP address
and
> port number, since the IP address is unique to the virtual server. MDAC
2.6
> and above does resolve names and port numbers automagically.
> GNH
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> > From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on a
unique
> > set of network address so that applications can connect to different
> > instances"
> >
> > What does this mean ? What is this n/w address ? If i have 2 instances(
> one
> > default and the other named ) , what are the 2 network addresses ? It
cant
> > be IP right ? So what is it ? Thanks
> >
> > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > > Your client system likely has an older version of MDAC. Install
MDAC
> > 2.6
> > > > or
> > > > higher to connect to a named instance without requiring an alias.
> > >
> > > Is this documented somewhere Geoff? I don't remember *exactly* when
> MDAC
> > > 2.6 was released, but I know I was able to connect to named instances
> > before
> > > I ever worried about what version of MDAC was installed, and that was
> some
> > > time ago.
> > >
> > > --
> > > Aaron Bertrand
> > > SQL Server MVP
> > > http://www.aspfaq.com/
> > >
> > >
> >
> >
>|||MDAC 2.6 and higher can determine the port number from a
computername\instancename request. 2.5 and lower cannot. You can specify a
port number with any MDAC version if it makes you more comfortable. If you
turn on port hiding on the server, you must use the port number.
SQL uses port 1434 to handle name-port resolution. That is where the
Slammer worm hit.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23R5K20TLEHA.3216@.TK2MSFTNGP12.phx.gbl...
> So i have to specify the port number then to connect thru EM from a
client.
> Am i right ? I tried this computername\instancename,port and it worked
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:u7SZgkMLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> > I am not sure it MDAC 2.6 is the breakover point, but it is around that
> > version. I will try and see if I can find it.
> >
> > SQL listens on all IP addresses that exist at service startup. Each
> > instance has its own port. A clustered instance has its own IP address
> and
> > port number, since the IP address is unique to the virtual server. MDAC
> 2.6
> > and above does resolve names and port numbers automagically.
> >
> > GNH
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> > > From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on a
> unique
> > > set of network address so that applications can connect to different
> > > instances"
> > >
> > > What does this mean ? What is this n/w address ? If i have 2
instances(
> > one
> > > default and the other named ) , what are the 2 network addresses ? It
> cant
> > > be IP right ? So what is it ? Thanks
> > >
> > > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > > news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > Your client system likely has an older version of MDAC. Install
> MDAC
> > > 2.6
> > > > > or
> > > > > higher to connect to a named instance without requiring an alias.
> > > >
> > > > Is this documented somewhere Geoff? I don't remember *exactly* when
> > MDAC
> > > > 2.6 was released, but I know I was able to connect to named
instances
> > > before
> > > > I ever worried about what version of MDAC was installed, and that
was
> > some
> > > > time ago.
> > > >
> > > > --
> > > > Aaron Bertrand
> > > > SQL Server MVP
> > > > http://www.aspfaq.com/
> > > >
> > > >
> > >
> > >
> >
> >
>|||Any way to find out what version of MDAC I have ? Ive got SQL 2K Developer
Edition with SP3a installed
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uJEdE6ULEHA.1052@.TK2MSFTNGP12.phx.gbl...
> MDAC 2.6 and higher can determine the port number from a
> computername\instancename request. 2.5 and lower cannot. You can specify
a
> port number with any MDAC version if it makes you more comfortable. If
you
> turn on port hiding on the server, you must use the port number.
> SQL uses port 1434 to handle name-port resolution. That is where the
> Slammer worm hit.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:%23R5K20TLEHA.3216@.TK2MSFTNGP12.phx.gbl...
> > So i have to specify the port number then to connect thru EM from a
> client.
> > Am i right ? I tried this computername\instancename,port and it worked
> >
> >
> > "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> > news:u7SZgkMLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> > > I am not sure it MDAC 2.6 is the breakover point, but it is around
that
> > > version. I will try and see if I can find it.
> > >
> > > SQL listens on all IP addresses that exist at service startup. Each
> > > instance has its own port. A clustered instance has its own IP
address
> > and
> > > port number, since the IP address is unique to the virtual server.
MDAC
> > 2.6
> > > and above does resolve names and port numbers automagically.
> > >
> > > GNH
> > >
> > >
> > > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > > news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> > > > From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on a
> > unique
> > > > set of network address so that applications can connect to different
> > > > instances"
> > > >
> > > > What does this mean ? What is this n/w address ? If i have 2
> instances(
> > > one
> > > > default and the other named ) , what are the 2 network addresses ?
It
> > cant
> > > > be IP right ? So what is it ? Thanks
> > > >
> > > > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > > > news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > > Your client system likely has an older version of MDAC. Install
> > MDAC
> > > > 2.6
> > > > > > or
> > > > > > higher to connect to a named instance without requiring an
alias.
> > > > >
> > > > > Is this documented somewhere Geoff? I don't remember *exactly*
when
> > > MDAC
> > > > > 2.6 was released, but I know I was able to connect to named
> instances
> > > > before
> > > > > I ever worried about what version of MDAC was installed, and that
> was
> > > some
> > > > > time ago.
> > > > >
> > > > > --
> > > > > Aaron Bertrand
> > > > > SQL Server MVP
> > > > > http://www.aspfaq.com/
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||HOW TO: Check for MDAC Version
http://support.microsoft.com/default.aspx?scid=kb;en-us;301202&Product=mdac
I believe SP3a shipped with MDAC 2.7.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e5aRYEVLEHA.1156@.TK2MSFTNGP09.phx.gbl...
> Any way to find out what version of MDAC I have ? Ive got SQL 2K Developer
> Edition with SP3a installed
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uJEdE6ULEHA.1052@.TK2MSFTNGP12.phx.gbl...
> > MDAC 2.6 and higher can determine the port number from a
> > computername\instancename request. 2.5 and lower cannot. You can
specify
> a
> > port number with any MDAC version if it makes you more comfortable. If
> you
> > turn on port hiding on the server, you must use the port number.
> >
> > SQL uses port 1434 to handle name-port resolution. That is where the
> > Slammer worm hit.
> >
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:%23R5K20TLEHA.3216@.TK2MSFTNGP12.phx.gbl...
> > > So i have to specify the port number then to connect thru EM from a
> > client.
> > > Am i right ? I tried this computername\instancename,port and it worked
> > >
> > >
> > > "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> > > news:u7SZgkMLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> > > > I am not sure it MDAC 2.6 is the breakover point, but it is around
> that
> > > > version. I will try and see if I can find it.
> > > >
> > > > SQL listens on all IP addresses that exist at service startup. Each
> > > > instance has its own port. A clustered instance has its own IP
> address
> > > and
> > > > port number, since the IP address is unique to the virtual server.
> MDAC
> > > 2.6
> > > > and above does resolve names and port numbers automagically.
> > > >
> > > > GNH
> > > >
> > > >
> > > > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > > > news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> > > > > From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on
a
> > > unique
> > > > > set of network address so that applications can connect to
different
> > > > > instances"
> > > > >
> > > > > What does this mean ? What is this n/w address ? If i have 2
> > instances(
> > > > one
> > > > > default and the other named ) , what are the 2 network addresses ?
> It
> > > cant
> > > > > be IP right ? So what is it ? Thanks
> > > > >
> > > > > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > > > > news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > > > Your client system likely has an older version of MDAC.
Install
> > > MDAC
> > > > > 2.6
> > > > > > > or
> > > > > > > higher to connect to a named instance without requiring an
> alias.
> > > > > >
> > > > > > Is this documented somewhere Geoff? I don't remember *exactly*
> when
> > > > MDAC
> > > > > > 2.6 was released, but I know I was able to connect to named
> > instances
> > > > > before
> > > > > > I ever worried about what version of MDAC was installed, and
that
> > was
> > > > some
> > > > > > time ago.
> > > > > >
> > > > > > --
> > > > > > Aaron Bertrand
> > > > > > SQL Server MVP
> > > > > > http://www.aspfaq.com/
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hassan,
Try Component checker tool (url may wrap)
'MDAC Utility: Component Checker'
http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e5aRYEVLEHA.1156@.TK2MSFTNGP09.phx.gbl...
> Any way to find out what version of MDAC I have ? Ive got SQL 2K Developer
> Edition with SP3a installed
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uJEdE6ULEHA.1052@.TK2MSFTNGP12.phx.gbl...
> > MDAC 2.6 and higher can determine the port number from a
> > computername\instancename request. 2.5 and lower cannot. You can
specify
> a
> > port number with any MDAC version if it makes you more comfortable. If
> you
> > turn on port hiding on the server, you must use the port number.
> >
> > SQL uses port 1434 to handle name-port resolution. That is where the
> > Slammer worm hit.
> >
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:%23R5K20TLEHA.3216@.TK2MSFTNGP12.phx.gbl...
> > > So i have to specify the port number then to connect thru EM from a
> > client.
> > > Am i right ? I tried this computername\instancename,port and it worked
> > >
> > >
> > > "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> > > news:u7SZgkMLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> > > > I am not sure it MDAC 2.6 is the breakover point, but it is around
> that
> > > > version. I will try and see if I can find it.
> > > >
> > > > SQL listens on all IP addresses that exist at service startup. Each
> > > > instance has its own port. A clustered instance has its own IP
> address
> > > and
> > > > port number, since the IP address is unique to the virtual server.
> MDAC
> > > 2.6
> > > > and above does resolve names and port numbers automagically.
> > > >
> > > > GNH
> > > >
> > > >
> > > > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > > > news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> > > > > From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on
a
> > > unique
> > > > > set of network address so that applications can connect to
different
> > > > > instances"
> > > > >
> > > > > What does this mean ? What is this n/w address ? If i have 2
> > instances(
> > > > one
> > > > > default and the other named ) , what are the 2 network addresses ?
> It
> > > cant
> > > > > be IP right ? So what is it ? Thanks
> > > > >
> > > > > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > > > > news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > > > Your client system likely has an older version of MDAC.
Install
> > > MDAC
> > > > > 2.6
> > > > > > > or
> > > > > > > higher to connect to a named instance without requiring an
> alias.
> > > > > >
> > > > > > Is this documented somewhere Geoff? I don't remember *exactly*
> when
> > > > MDAC
> > > > > > 2.6 was released, but I know I was able to connect to named
> > instances
> > > > > before
> > > > > > I ever worried about what version of MDAC was installed, and
that
> > was
> > > > some
> > > > > > time ago.
> > > > > >
> > > > > > --
> > > > > > Aaron Bertrand
> > > > > > SQL Server MVP
> > > > > > http://www.aspfaq.com/
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||> Any way to find out what version of MDAC I have ?
Many ways.
http://www.aspfaq.com/2057
is bcos of the port number.. When i connect to computername\instancename it
says SQL Server does not exist or access denied. However when i register an
alias in client network utility with the instance name and the actual port
number it works fine, but i have to use the alias.
Can i not register with the instance name directly without setting it up
thru the client network utility ? Please advice..Your client system likely has an older version of MDAC. Install MDAC 2.6 or
higher to connect to a named instance without requiring an alias.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ud6L39KLEHA.2100@.TK2MSFTNGP10.phx.gbl...
> How can I connect to a named instance from a client. I believe the problem
> is bcos of the port number.. When i connect to computername\instancename
it
> says SQL Server does not exist or access denied. However when i register
an
> alias in client network utility with the instance name and the actual port
> number it works fine, but i have to use the alias.
> Can i not register with the instance name directly without setting it up
> thru the client network utility ? Please advice..
>|||> Your client system likely has an older version of MDAC. Install MDAC 2.6
> or
> higher to connect to a named instance without requiring an alias.
Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
2.6 was released, but I know I was able to connect to named instances before
I ever worried about what version of MDAC was installed, and that was some
time ago.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Does that mean that with the latest MDAC, the client would dynamically
determine the port of the named instance ?
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > Your client system likely has an older version of MDAC. Install MDAC
2.6
> > or
> > higher to connect to a named instance without requiring an alias.
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on a unique
set of network address so that applications can connect to different
instances"
What does this mean ? What is this n/w address ? If i have 2 instances( one
default and the other named ) , what are the 2 network addresses ? It cant
be IP right ? So what is it ? Thanks
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > Your client system likely has an older version of MDAC. Install MDAC
2.6
> > or
> > higher to connect to a named instance without requiring an alias.
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||I am not sure it MDAC 2.6 is the breakover point, but it is around that
version. I will try and see if I can find it.
SQL listens on all IP addresses that exist at service startup. Each
instance has its own port. A clustered instance has its own IP address and
port number, since the IP address is unique to the virtual server. MDAC 2.6
and above does resolve names and port numbers automagically.
GNH
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on a unique
> set of network address so that applications can connect to different
> instances"
> What does this mean ? What is this n/w address ? If i have 2 instances(
one
> default and the other named ) , what are the 2 network addresses ? It cant
> be IP right ? So what is it ? Thanks
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > Your client system likely has an older version of MDAC. Install MDAC
> 2.6
> > > or
> > > higher to connect to a named instance without requiring an alias.
> >
> > Is this documented somewhere Geoff? I don't remember *exactly* when
MDAC
> > 2.6 was released, but I know I was able to connect to named instances
> before
> > I ever worried about what version of MDAC was installed, and that was
some
> > time ago.
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > http://www.aspfaq.com/
> >
> >
>|||It is indirectly documented here:
INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
Version's Client Tools
http://support.microsoft.com/default.aspx?scid=kb;en-us;265808&Product=sql2k
The MORE INFORMATION section begins with a statement that MDAC 2.6 is
required to connect to a named instance in \\computer_name\instance_name
format. The article then goes on to describe a workaround.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > Your client system likely has an older version of MDAC. Install MDAC
2.6
> > or
> > higher to connect to a named instance without requiring an alias.
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||Ah, I see, this wasn't really specified, as I use computername\instance_name
(not \\computername\instance_name) over TCP/IP all the time, and
http://www.aspfaq.com/2126 has recommended the \instance_name syntax since
long before MDAC 2.6 (1999 or 2000 sometime). I'm talking about connecting
to SQL Server from, for example, ASP or VB, over TCP/IP, not named pipes.
Sorry about the confusion.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OJzZU3MLEHA.3808@.TK2MSFTNGP12.phx.gbl...
> It is indirectly documented here:
> INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
> Version's Client Tools
> http://support.microsoft.com/default.aspx?scid=kb;en-us;265808&Product=sql2k
> The MORE INFORMATION section begins with a statement that MDAC 2.6 is
> required to connect to a named instance in \\computer_name\instance_name
> format. The article then goes on to describe a workaround.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
>> > Your client system likely has an older version of MDAC. Install MDAC
> 2.6
>> > or
>> > higher to connect to a named instance without requiring an alias.
>> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
>> 2.6 was released, but I know I was able to connect to named instances
> before
>> I ever worried about what version of MDAC was installed, and that was
>> some
>> time ago.
>> --
>> Aaron Bertrand
>> SQL Server MVP
>> http://www.aspfaq.com/
>>
>|||Let me rephrase, 2000 sometime. I thought MDAC 2.6 was introduced much
later than SQL Server 2000, but I must be remembering incorrectly.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||2.6 was the release with RTM SQL 2000
--snip
Release Version Number
MDAC 2.6 RTM (2.60.6526.3), September 2000
Release Function
This release provides, directly to the public, the same version of MDAC
released with Microsoft SQL ServerT 2000.
--snip
Snipped from:
Release Manifest for MDAC 2.6 RTM (2.60.6526.3)
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/mdac/2.6/rtmmanifest.asp
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23TxVKBNLEHA.3012@.tk2msftngp13.phx.gbl...
> Let me rephrase, 2000 sometime. I thought MDAC 2.6 was introduced much
> later than SQL Server 2000, but I must be remembering incorrectly.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>|||Thanks, at least it's just my memory that's messed up. Math and depth
perception are still functioning okay. ;-)
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
> 2.6 was the release with RTM SQL 2000|||Memory is fine here. Sanity is another question, but that has been an open
issue for a very long time.
GNH
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:urFfumNLEHA.2396@.TK2MSFTNGP12.phx.gbl...
> Thanks, at least it's just my memory that's messed up. Math and depth
> perception are still functioning okay. ;-)
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> > 2.6 was the release with RTM SQL 2000
>|||So i have to specify the port number then to connect thru EM from a client.
Am i right ? I tried this computername\instancename,port and it worked
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:u7SZgkMLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> I am not sure it MDAC 2.6 is the breakover point, but it is around that
> version. I will try and see if I can find it.
> SQL listens on all IP addresses that exist at service startup. Each
> instance has its own port. A clustered instance has its own IP address
and
> port number, since the IP address is unique to the virtual server. MDAC
2.6
> and above does resolve names and port numbers automagically.
> GNH
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> > From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on a
unique
> > set of network address so that applications can connect to different
> > instances"
> >
> > What does this mean ? What is this n/w address ? If i have 2 instances(
> one
> > default and the other named ) , what are the 2 network addresses ? It
cant
> > be IP right ? So what is it ? Thanks
> >
> > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > > Your client system likely has an older version of MDAC. Install
MDAC
> > 2.6
> > > > or
> > > > higher to connect to a named instance without requiring an alias.
> > >
> > > Is this documented somewhere Geoff? I don't remember *exactly* when
> MDAC
> > > 2.6 was released, but I know I was able to connect to named instances
> > before
> > > I ever worried about what version of MDAC was installed, and that was
> some
> > > time ago.
> > >
> > > --
> > > Aaron Bertrand
> > > SQL Server MVP
> > > http://www.aspfaq.com/
> > >
> > >
> >
> >
>|||MDAC 2.6 and higher can determine the port number from a
computername\instancename request. 2.5 and lower cannot. You can specify a
port number with any MDAC version if it makes you more comfortable. If you
turn on port hiding on the server, you must use the port number.
SQL uses port 1434 to handle name-port resolution. That is where the
Slammer worm hit.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:%23R5K20TLEHA.3216@.TK2MSFTNGP12.phx.gbl...
> So i have to specify the port number then to connect thru EM from a
client.
> Am i right ? I tried this computername\instancename,port and it worked
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:u7SZgkMLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> > I am not sure it MDAC 2.6 is the breakover point, but it is around that
> > version. I will try and see if I can find it.
> >
> > SQL listens on all IP addresses that exist at service startup. Each
> > instance has its own port. A clustered instance has its own IP address
> and
> > port number, since the IP address is unique to the virtual server. MDAC
> 2.6
> > and above does resolve names and port numbers automagically.
> >
> > GNH
> >
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> > > From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on a
> unique
> > > set of network address so that applications can connect to different
> > > instances"
> > >
> > > What does this mean ? What is this n/w address ? If i have 2
instances(
> > one
> > > default and the other named ) , what are the 2 network addresses ? It
> cant
> > > be IP right ? So what is it ? Thanks
> > >
> > > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > > news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > Your client system likely has an older version of MDAC. Install
> MDAC
> > > 2.6
> > > > > or
> > > > > higher to connect to a named instance without requiring an alias.
> > > >
> > > > Is this documented somewhere Geoff? I don't remember *exactly* when
> > MDAC
> > > > 2.6 was released, but I know I was able to connect to named
instances
> > > before
> > > > I ever worried about what version of MDAC was installed, and that
was
> > some
> > > > time ago.
> > > >
> > > > --
> > > > Aaron Bertrand
> > > > SQL Server MVP
> > > > http://www.aspfaq.com/
> > > >
> > > >
> > >
> > >
> >
> >
>|||Any way to find out what version of MDAC I have ? Ive got SQL 2K Developer
Edition with SP3a installed
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uJEdE6ULEHA.1052@.TK2MSFTNGP12.phx.gbl...
> MDAC 2.6 and higher can determine the port number from a
> computername\instancename request. 2.5 and lower cannot. You can specify
a
> port number with any MDAC version if it makes you more comfortable. If
you
> turn on port hiding on the server, you must use the port number.
> SQL uses port 1434 to handle name-port resolution. That is where the
> Slammer worm hit.
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:%23R5K20TLEHA.3216@.TK2MSFTNGP12.phx.gbl...
> > So i have to specify the port number then to connect thru EM from a
> client.
> > Am i right ? I tried this computername\instancename,port and it worked
> >
> >
> > "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> > news:u7SZgkMLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> > > I am not sure it MDAC 2.6 is the breakover point, but it is around
that
> > > version. I will try and see if I can find it.
> > >
> > > SQL listens on all IP addresses that exist at service startup. Each
> > > instance has its own port. A clustered instance has its own IP
address
> > and
> > > port number, since the IP address is unique to the virtual server.
MDAC
> > 2.6
> > > and above does resolve names and port numbers automagically.
> > >
> > > GNH
> > >
> > >
> > > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > > news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> > > > From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on a
> > unique
> > > > set of network address so that applications can connect to different
> > > > instances"
> > > >
> > > > What does this mean ? What is this n/w address ? If i have 2
> instances(
> > > one
> > > > default and the other named ) , what are the 2 network addresses ?
It
> > cant
> > > > be IP right ? So what is it ? Thanks
> > > >
> > > > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > > > news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > > Your client system likely has an older version of MDAC. Install
> > MDAC
> > > > 2.6
> > > > > > or
> > > > > > higher to connect to a named instance without requiring an
alias.
> > > > >
> > > > > Is this documented somewhere Geoff? I don't remember *exactly*
when
> > > MDAC
> > > > > 2.6 was released, but I know I was able to connect to named
> instances
> > > > before
> > > > > I ever worried about what version of MDAC was installed, and that
> was
> > > some
> > > > > time ago.
> > > > >
> > > > > --
> > > > > Aaron Bertrand
> > > > > SQL Server MVP
> > > > > http://www.aspfaq.com/
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||HOW TO: Check for MDAC Version
http://support.microsoft.com/default.aspx?scid=kb;en-us;301202&Product=mdac
I believe SP3a shipped with MDAC 2.7.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e5aRYEVLEHA.1156@.TK2MSFTNGP09.phx.gbl...
> Any way to find out what version of MDAC I have ? Ive got SQL 2K Developer
> Edition with SP3a installed
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uJEdE6ULEHA.1052@.TK2MSFTNGP12.phx.gbl...
> > MDAC 2.6 and higher can determine the port number from a
> > computername\instancename request. 2.5 and lower cannot. You can
specify
> a
> > port number with any MDAC version if it makes you more comfortable. If
> you
> > turn on port hiding on the server, you must use the port number.
> >
> > SQL uses port 1434 to handle name-port resolution. That is where the
> > Slammer worm hit.
> >
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:%23R5K20TLEHA.3216@.TK2MSFTNGP12.phx.gbl...
> > > So i have to specify the port number then to connect thru EM from a
> > client.
> > > Am i right ? I tried this computername\instancename,port and it worked
> > >
> > >
> > > "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> > > news:u7SZgkMLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> > > > I am not sure it MDAC 2.6 is the breakover point, but it is around
> that
> > > > version. I will try and see if I can find it.
> > > >
> > > > SQL listens on all IP addresses that exist at service startup. Each
> > > > instance has its own port. A clustered instance has its own IP
> address
> > > and
> > > > port number, since the IP address is unique to the virtual server.
> MDAC
> > > 2.6
> > > > and above does resolve names and port numbers automagically.
> > > >
> > > > GNH
> > > >
> > > >
> > > > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > > > news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> > > > > From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on
a
> > > unique
> > > > > set of network address so that applications can connect to
different
> > > > > instances"
> > > > >
> > > > > What does this mean ? What is this n/w address ? If i have 2
> > instances(
> > > > one
> > > > > default and the other named ) , what are the 2 network addresses ?
> It
> > > cant
> > > > > be IP right ? So what is it ? Thanks
> > > > >
> > > > > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > > > > news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > > > Your client system likely has an older version of MDAC.
Install
> > > MDAC
> > > > > 2.6
> > > > > > > or
> > > > > > > higher to connect to a named instance without requiring an
> alias.
> > > > > >
> > > > > > Is this documented somewhere Geoff? I don't remember *exactly*
> when
> > > > MDAC
> > > > > > 2.6 was released, but I know I was able to connect to named
> > instances
> > > > > before
> > > > > > I ever worried about what version of MDAC was installed, and
that
> > was
> > > > some
> > > > > > time ago.
> > > > > >
> > > > > > --
> > > > > > Aaron Bertrand
> > > > > > SQL Server MVP
> > > > > > http://www.aspfaq.com/
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||Hassan,
Try Component checker tool (url may wrap)
'MDAC Utility: Component Checker'
http://www.microsoft.com/downloads/details.aspx?familyid=8f0a8df6-4a21-4b43-bf53-14332ef092c9&displaylang=en
Dinesh
SQL Server MVP
--
--
SQL Server FAQ at
http://www.tkdinesh.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e5aRYEVLEHA.1156@.TK2MSFTNGP09.phx.gbl...
> Any way to find out what version of MDAC I have ? Ive got SQL 2K Developer
> Edition with SP3a installed
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uJEdE6ULEHA.1052@.TK2MSFTNGP12.phx.gbl...
> > MDAC 2.6 and higher can determine the port number from a
> > computername\instancename request. 2.5 and lower cannot. You can
specify
> a
> > port number with any MDAC version if it makes you more comfortable. If
> you
> > turn on port hiding on the server, you must use the port number.
> >
> > SQL uses port 1434 to handle name-port resolution. That is where the
> > Slammer worm hit.
> >
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > news:%23R5K20TLEHA.3216@.TK2MSFTNGP12.phx.gbl...
> > > So i have to specify the port number then to connect thru EM from a
> > client.
> > > Am i right ? I tried this computername\instancename,port and it worked
> > >
> > >
> > > "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> > > news:u7SZgkMLEHA.2660@.TK2MSFTNGP09.phx.gbl...
> > > > I am not sure it MDAC 2.6 is the breakover point, but it is around
> that
> > > > version. I will try and see if I can find it.
> > > >
> > > > SQL listens on all IP addresses that exist at service startup. Each
> > > > instance has its own port. A clustered instance has its own IP
> address
> > > and
> > > > port number, since the IP address is unique to the virtual server.
> MDAC
> > > 2.6
> > > > and above does resolve names and port numbers automagically.
> > > >
> > > > GNH
> > > >
> > > >
> > > > "Hassan" <fatima_ja@.hotmail.com> wrote in message
> > > > news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> > > > > From BOL "Each instance of Microsoft® SQL ServerT 2000 listens on
a
> > > unique
> > > > > set of network address so that applications can connect to
different
> > > > > instances"
> > > > >
> > > > > What does this mean ? What is this n/w address ? If i have 2
> > instances(
> > > > one
> > > > > default and the other named ) , what are the 2 network addresses ?
> It
> > > cant
> > > > > be IP right ? So what is it ? Thanks
> > > > >
> > > > > "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> > > > > news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> > > > > > > Your client system likely has an older version of MDAC.
Install
> > > MDAC
> > > > > 2.6
> > > > > > > or
> > > > > > > higher to connect to a named instance without requiring an
> alias.
> > > > > >
> > > > > > Is this documented somewhere Geoff? I don't remember *exactly*
> when
> > > > MDAC
> > > > > > 2.6 was released, but I know I was able to connect to named
> > instances
> > > > > before
> > > > > > I ever worried about what version of MDAC was installed, and
that
> > was
> > > > some
> > > > > > time ago.
> > > > > >
> > > > > > --
> > > > > > Aaron Bertrand
> > > > > > SQL Server MVP
> > > > > > http://www.aspfaq.com/
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||> Any way to find out what version of MDAC I have ?
Many ways.
http://www.aspfaq.com/2057
connect to named instances
How can I connect to a named instance from a client. I believe the problem
is bcos of the port number.. When i connect to computername\instancename it
says SQL Server does not exist or access denied. However when i register an
alias in client network utility with the instance name and the actual port
number it works fine, but i have to use the alias.
Can i not register with the instance name directly without setting it up
thru the client network utility ? Please advice..Your client system likely has an older version of MDAC. Install MDAC 2.6 or
higher to connect to a named instance without requiring an alias.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ud6L39KLEHA.2100@.TK2MSFTNGP10.phx.gbl...
> How can I connect to a named instance from a client. I believe the problem
> is bcos of the port number.. When i connect to computername\instancename
it
> says SQL Server does not exist or access denied. However when i register
an
> alias in client network utility with the instance name and the actual port
> number it works fine, but i have to use the alias.
> Can i not register with the instance name directly without setting it up
> thru the client network utility ? Please advice..
>|||> Your client system likely has an older version of MDAC. Install MDAC 2.6
> or
> higher to connect to a named instance without requiring an alias.
Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
2.6 was released, but I know I was able to connect to named instances before
I ever worried about what version of MDAC was installed, and that was some
time ago.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Does that mean that with the latest MDAC, the client would dynamically
determine the port of the named instance ?
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
2.6[vbcol=seagreen]
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||From BOL "Each instance of Microsoft SQL ServerT 2000 listens on a unique
set of network address so that applications can connect to different
instances"
What does this mean ? What is this n/w address ? If i have 2 instances( one
default and the other named ) , what are the 2 network addresses ? It cant
be IP right ? So what is it ? Thanks
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
2.6[vbcol=seagreen]
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||I am not sure it MDAC 2.6 is the breakover point, but it is around that
version. I will try and see if I can find it.
SQL listens on all IP addresses that exist at service startup. Each
instance has its own port. A clustered instance has its own IP address and
port number, since the IP address is unique to the virtual server. MDAC 2.6
and above does resolve names and port numbers automagically.
GNH
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> From BOL "Each instance of Microsoft SQL ServerT 2000 listens on a unique
> set of network address so that applications can connect to different
> instances"
> What does this mean ? What is this n/w address ? If i have 2 instances(
one
> default and the other named ) , what are the 2 network addresses ? It cant
> be IP right ? So what is it ? Thanks
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> 2.6
MDAC[vbcol=seagreen]
> before
some[vbcol=seagreen]
>|||It is indirectly documented here:
INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
Version's Client Tools
http://support.microsoft.com/defaul...8&Product=sql2k
The MORE INFORMATION section begins with a statement that MDAC 2.6 is
required to connect to a named instance in \\computer_name\instance_name
format. The article then goes on to describe a workaround.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
2.6[vbcol=seagreen]
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||Ah, I see, this wasn't really specified, as I use computername\instance_name
(not \\computername\instance_name) over TCP/IP all the time, and
http://www.aspfaq.com/2126 has recommended the \instance_name syntax since
long before MDAC 2.6 (1999 or 2000 sometime). I'm talking about connecting
to SQL Server from, for example, ASP or VB, over TCP/IP, not named pipes.
Sorry about the confusion.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OJzZU3MLEHA.3808@.TK2MSFTNGP12.phx.gbl...
> It is indirectly documented here:
> INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
> Version's Client Tools
> [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;265808&Product=sql2k[/ur
l]
> The MORE INFORMATION section begins with a statement that MDAC 2.6 is
> required to connect to a named instance in \\computer_name\instance_name
> format. The article then goes on to describe a workaround.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> 2.6
> before
>|||Let me rephrase, 2000 sometime. I thought MDAC 2.6 was introduced much
later than SQL Server 2000, but I must be remembering incorrectly.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Memory is fine here. Sanity is another question, but that has been an open
issue for a very long time.
GNH
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:urFfumNLEHA.2396@.TK2MSFTNGP12.phx.gbl...
> Thanks, at least it's just my memory that's messed up. Math and depth
> perception are still functioning okay. ;-)
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
>
is bcos of the port number.. When i connect to computername\instancename it
says SQL Server does not exist or access denied. However when i register an
alias in client network utility with the instance name and the actual port
number it works fine, but i have to use the alias.
Can i not register with the instance name directly without setting it up
thru the client network utility ? Please advice..Your client system likely has an older version of MDAC. Install MDAC 2.6 or
higher to connect to a named instance without requiring an alias.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ud6L39KLEHA.2100@.TK2MSFTNGP10.phx.gbl...
> How can I connect to a named instance from a client. I believe the problem
> is bcos of the port number.. When i connect to computername\instancename
it
> says SQL Server does not exist or access denied. However when i register
an
> alias in client network utility with the instance name and the actual port
> number it works fine, but i have to use the alias.
> Can i not register with the instance name directly without setting it up
> thru the client network utility ? Please advice..
>|||> Your client system likely has an older version of MDAC. Install MDAC 2.6
> or
> higher to connect to a named instance without requiring an alias.
Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
2.6 was released, but I know I was able to connect to named instances before
I ever worried about what version of MDAC was installed, and that was some
time ago.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Does that mean that with the latest MDAC, the client would dynamically
determine the port of the named instance ?
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
2.6[vbcol=seagreen]
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||From BOL "Each instance of Microsoft SQL ServerT 2000 listens on a unique
set of network address so that applications can connect to different
instances"
What does this mean ? What is this n/w address ? If i have 2 instances( one
default and the other named ) , what are the 2 network addresses ? It cant
be IP right ? So what is it ? Thanks
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
2.6[vbcol=seagreen]
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||I am not sure it MDAC 2.6 is the breakover point, but it is around that
version. I will try and see if I can find it.
SQL listens on all IP addresses that exist at service startup. Each
instance has its own port. A clustered instance has its own IP address and
port number, since the IP address is unique to the virtual server. MDAC 2.6
and above does resolve names and port numbers automagically.
GNH
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:ejJR8QMLEHA.2692@.tk2msftngp13.phx.gbl...
> From BOL "Each instance of Microsoft SQL ServerT 2000 listens on a unique
> set of network address so that applications can connect to different
> instances"
> What does this mean ? What is this n/w address ? If i have 2 instances(
one
> default and the other named ) , what are the 2 network addresses ? It cant
> be IP right ? So what is it ? Thanks
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> 2.6
MDAC[vbcol=seagreen]
> before
some[vbcol=seagreen]
>|||It is indirectly documented here:
INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
Version's Client Tools
http://support.microsoft.com/defaul...8&Product=sql2k
The MORE INFORMATION section begins with a statement that MDAC 2.6 is
required to connect to a named instance in \\computer_name\instance_name
format. The article then goes on to describe a workaround.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
2.6[vbcol=seagreen]
> Is this documented somewhere Geoff? I don't remember *exactly* when MDAC
> 2.6 was released, but I know I was able to connect to named instances
before
> I ever worried about what version of MDAC was installed, and that was some
> time ago.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||Ah, I see, this wasn't really specified, as I use computername\instance_name
(not \\computername\instance_name) over TCP/IP all the time, and
http://www.aspfaq.com/2126 has recommended the \instance_name syntax since
long before MDAC 2.6 (1999 or 2000 sometime). I'm talking about connecting
to SQL Server from, for example, ASP or VB, over TCP/IP, not named pipes.
Sorry about the confusion.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OJzZU3MLEHA.3808@.TK2MSFTNGP12.phx.gbl...
> It is indirectly documented here:
> INF: How to Connect to an SQL Server 2000 Named Instance with the Previous
> Version's Client Tools
> [url]http://support.microsoft.com/default.aspx?scid=kb;en-us;265808&Product=sql2k[/ur
l]
> The MORE INFORMATION section begins with a statement that MDAC 2.6 is
> required to connect to a named instance in \\computer_name\instance_name
> format. The article then goes on to describe a workaround.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:%23GGZf4LLEHA.3944@.tk2msftngp13.phx.gbl...
> 2.6
> before
>|||Let me rephrase, 2000 sometime. I thought MDAC 2.6 was introduced much
later than SQL Server 2000, but I must be remembering incorrectly.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Memory is fine here. Sanity is another question, but that has been an open
issue for a very long time.
GNH
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:urFfumNLEHA.2396@.TK2MSFTNGP12.phx.gbl...
> Thanks, at least it's just my memory that's messed up. Math and depth
> perception are still functioning okay. ;-)
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
>
Tuesday, 20 March 2012
Connect to DB using another TCP port from SQL management Studio
Hi,
The DBA set database on server to a high TCP port number.
How can I connect to it from Microsoft SQL2005 management Studio.
I can't find the option to set TCP port number in there.
Thanks!You can use tcp:servername,port in the connection dialog although if the SQL
Browser is running you should still be able to use the instance name. As an
alternative you can set up a client alias using SQL Server Configuration
Manager>SQL Native Client Configuration>Aliases
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<walanta> wrote in message
news:loure2pjt4o6rvq7t5r3rvh4mln76i3pan@.
4ax.com...
> Hi,
> The DBA set database on server to a high TCP port number.
> How can I connect to it from Microsoft SQL2005 management Studio.
> I can't find the option to set TCP port number in there.
> Thanks!|||Where is "connection dialog" ?
I'm using SQL server management studio-> object explore-> connect->
database engine -> ...
I see "servername:", "authentication:", "connect to database:",
"network protocol"...
No place I can put "tcp:192.168.1.1,8800" or somthing like that.
On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
<jasper_smith9@.hotmail.com> wrote:
>You can use tcp:servername,port in the connection dialog although if the SQ
L
>Browser is running you should still be able to use the instance name. As an
>alternative you can set up a client alias using SQL Server Configuration
>Manager>SQL Native Client Configuration>Aliases|||Hi,
Go to SQL Server program groups nad select "SQL Server Configuration
Manager"
Thanks
Hari
SQL Server MVP
<walanta> wrote in message
news:ndcse2lg3v26uv0s31sh8sob6rl84l9tq4@.
4ax.com...[vbcol=seagreen]
> Where is "connection dialog" ?
> I'm using SQL server management studio-> object explore-> connect->
> database engine -> ...
> I see "servername:", "authentication:", "connect to database:",
> "network protocol"...
> No place I can put "tcp:192.168.1.1,8800" or somthing like that.
>
>
> On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
> <jasper_smith9@.hotmail.com> wrote:
>|||It's in the Server name box i.e. if your server was called FOO and on port
55551 you would use
tcp:FOO,55551
in the Server name box
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<walanta> wrote in message
news:ndcse2lg3v26uv0s31sh8sob6rl84l9tq4@.
4ax.com...[vbcol=seagreen]
> Where is "connection dialog" ?
> I'm using SQL server management studio-> object explore-> connect->
> database engine -> ...
> I see "servername:", "authentication:", "connect to database:",
> "network protocol"...
> No place I can put "tcp:192.168.1.1,8800" or somthing like that.
>
>
> On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
> <jasper_smith9@.hotmail.com> wrote:
>|||If SQL Browser is started you should be redirected automatically. For
security reasons (and the fact that this is not enabled in the setup
process by default) the SQL Browser service can not be running. The
port can be specified manually by putting it after the instancename you
want to connect to:
For default instances: Servername\InstanceName,Portnumber
For named instances: Servername,Portnumber
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
The DBA set database on server to a high TCP port number.
How can I connect to it from Microsoft SQL2005 management Studio.
I can't find the option to set TCP port number in there.
Thanks!You can use tcp:servername,port in the connection dialog although if the SQL
Browser is running you should still be able to use the instance name. As an
alternative you can set up a client alias using SQL Server Configuration
Manager>SQL Native Client Configuration>Aliases
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<walanta> wrote in message
news:loure2pjt4o6rvq7t5r3rvh4mln76i3pan@.
4ax.com...
> Hi,
> The DBA set database on server to a high TCP port number.
> How can I connect to it from Microsoft SQL2005 management Studio.
> I can't find the option to set TCP port number in there.
> Thanks!|||Where is "connection dialog" ?
I'm using SQL server management studio-> object explore-> connect->
database engine -> ...
I see "servername:", "authentication:", "connect to database:",
"network protocol"...
No place I can put "tcp:192.168.1.1,8800" or somthing like that.
On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
<jasper_smith9@.hotmail.com> wrote:
>You can use tcp:servername,port in the connection dialog although if the SQ
L
>Browser is running you should still be able to use the instance name. As an
>alternative you can set up a client alias using SQL Server Configuration
>Manager>SQL Native Client Configuration>Aliases|||Hi,
Go to SQL Server program groups nad select "SQL Server Configuration
Manager"
Thanks
Hari
SQL Server MVP
<walanta> wrote in message
news:ndcse2lg3v26uv0s31sh8sob6rl84l9tq4@.
4ax.com...[vbcol=seagreen]
> Where is "connection dialog" ?
> I'm using SQL server management studio-> object explore-> connect->
> database engine -> ...
> I see "servername:", "authentication:", "connect to database:",
> "network protocol"...
> No place I can put "tcp:192.168.1.1,8800" or somthing like that.
>
>
> On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
> <jasper_smith9@.hotmail.com> wrote:
>|||It's in the Server name box i.e. if your server was called FOO and on port
55551 you would use
tcp:FOO,55551
in the Server name box
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
<walanta> wrote in message
news:ndcse2lg3v26uv0s31sh8sob6rl84l9tq4@.
4ax.com...[vbcol=seagreen]
> Where is "connection dialog" ?
> I'm using SQL server management studio-> object explore-> connect->
> database engine -> ...
> I see "servername:", "authentication:", "connect to database:",
> "network protocol"...
> No place I can put "tcp:192.168.1.1,8800" or somthing like that.
>
>
> On Thu, 24 Aug 2006 22:08:36 +0100, "Jasper Smith"
> <jasper_smith9@.hotmail.com> wrote:
>|||If SQL Browser is started you should be redirected automatically. For
security reasons (and the fact that this is not enabled in the setup
process by default) the SQL Browser service can not be running. The
port can be specified manually by putting it after the instancename you
want to connect to:
For default instances: Servername\InstanceName,Portnumber
For named instances: Servername,Portnumber
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
Sunday, 19 February 2012
configuring the number of worker threads
We have a SQL 2000 server with max worker threads configured to be
3232767275275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. Is
it better to lower the value or increase it to help performance?
Thanks
MG
Hi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
|||See http://support.microsoft.com/default...b;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
|||MGeles,
This is a very small part of a much wider area of performance tuning. Have a
look through the articles at www.sql-server-performance.com for some
excellent methods on tuning your server.
You need to ascertain in a nutshell:
1) Is there any blocking happening > 1 sec
2) Is the disk IO bound
3) Is the server CPU bound
4) Which queries slow down the server
5) How much paging is happening in windows
6) How's the sql server buffer cache hit ratio - indicates RAM starvation
Also check your query plans and make sure your indexing is optimal. A
technique I use is to trace a typical workload into a SQL server table and
then query the trace table for the most cpu, io intensive and longest running
queries. I then check the query plans for these queries, and also the code.
You may even want to look at the database design itself - the biggest
performance bangs for your buck can often be obtained through tuning your
database design.
Regards,
Mark.
"MGeles" wrote:
> We have a SQL 2000 server with max worker threads configured to be
> 3232767275275
> The server sees some pretty high usage and we've been seeing some slow down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help. Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
3232767275275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. Is
it better to lower the value or increase it to help performance?
Thanks
MG
Hi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
|||See http://support.microsoft.com/default...b;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
|||MGeles,
This is a very small part of a much wider area of performance tuning. Have a
look through the articles at www.sql-server-performance.com for some
excellent methods on tuning your server.
You need to ascertain in a nutshell:
1) Is there any blocking happening > 1 sec
2) Is the disk IO bound
3) Is the server CPU bound
4) Which queries slow down the server
5) How much paging is happening in windows
6) How's the sql server buffer cache hit ratio - indicates RAM starvation
Also check your query plans and make sure your indexing is optimal. A
technique I use is to trace a typical workload into a SQL server table and
then query the trace table for the most cpu, io intensive and longest running
queries. I then check the query plans for these queries, and also the code.
You may even want to look at the database design itself - the biggest
performance bangs for your buck can often be obtained through tuning your
database design.
Regards,
Mark.
"MGeles" wrote:
> We have a SQL 2000 server with max worker threads configured to be
> 3232767275275
> The server sees some pretty high usage and we've been seeing some slow down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help. Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
configuring the number of worker threads
We have a SQL 2000 server with max worker threads configured to be
32 32767 275 275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. I
s
it better to lower the value or increase it to help performance?
Thanks
--
MGHi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||See http://support.microsoft.com/defaul...kb;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||MGeles,
This is a very small part of a much wider area of performance tuning. Have a
look through the articles at www.sql-server-performance.com for some
excellent methods on tuning your server.
You need to ascertain in a nutshell:
1) Is there any blocking happening > 1 sec
2) Is the disk IO bound
3) Is the server CPU bound
4) Which queries slow down the server
5) How much paging is happening in windows
6) How's the sql server buffer cache hit ratio - indicates RAM starvation
Also check your query plans and make sure your indexing is optimal. A
technique I use is to trace a typical workload into a SQL server table and
then query the trace table for the most cpu, io intensive and longest runnin
g
queries. I then check the query plans for these queries, and also the code.
You may even want to look at the database design itself - the biggest
performance bangs for your buck can often be obtained through tuning your
database design.
Regards,
Mark.
"MGeles" wrote:
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow dow
n
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
32 32767 275 275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. I
s
it better to lower the value or increase it to help performance?
Thanks
--
MGHi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||See http://support.microsoft.com/defaul...kb;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||MGeles,
This is a very small part of a much wider area of performance tuning. Have a
look through the articles at www.sql-server-performance.com for some
excellent methods on tuning your server.
You need to ascertain in a nutshell:
1) Is there any blocking happening > 1 sec
2) Is the disk IO bound
3) Is the server CPU bound
4) Which queries slow down the server
5) How much paging is happening in windows
6) How's the sql server buffer cache hit ratio - indicates RAM starvation
Also check your query plans and make sure your indexing is optimal. A
technique I use is to trace a typical workload into a SQL server table and
then query the trace table for the most cpu, io intensive and longest runnin
g
queries. I then check the query plans for these queries, and also the code.
You may even want to look at the database design itself - the biggest
performance bangs for your buck can often be obtained through tuning your
database design.
Regards,
Mark.
"MGeles" wrote:
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow dow
n
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
configuring the number of worker threads
We have a SQL 2000 server with max worker threads configured to be
32 32767 275 275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. Is
it better to lower the value or increase it to help performance?
Thanks
--
MGHi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||See http://support.microsoft.com/default.aspx?scid=kb;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
32 32767 275 275
The server sees some pretty high usage and we've been seeing some slow down
in the server. I've read that most systems run well with a value of 255.
I've also read something that suggests that lowering this value may help. Is
it better to lower the value or increase it to help performance?
Thanks
--
MGHi,
The default value set is 255 and is more than enough.
Most cases it is not required to increase the value; if the actual number
of connections exceeds the amount set in threads, SQL Server does a pooling
for worker threads so that the next available worker thread can handle the
request.
From Query anayzer run the command to get the correct value
SP_CONFIGURE 'max worker threads'
From the output see the running value. If the value is higher than 255 try
to change and monitor the threads using performance montor, Process, Thread
counter. This will give a clear picture of thread usage.
Thanks
Hari
SQL Server MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG|||See http://support.microsoft.com/default.aspx?scid=kb;en-us;319942 for
additional information.
Adrian
"MGeles" <michael.geles@.thomson.com> wrote in message
news:608FFF4F-87C3-4011-AB16-6C4412A23870@.microsoft.com...
> We have a SQL 2000 server with max worker threads configured to be
> 32 32767 275 275
> The server sees some pretty high usage and we've been seeing some slow
> down
> in the server. I've read that most systems run well with a value of 255.
> I've also read something that suggests that lowering this value may help.
> Is
> it better to lower the value or increase it to help performance?
> Thanks
> --
> MG
Configuring the code page of a OLEDB source.
hi,
i have a number of interfaces in which i have used oledb source.
the problem i am facing is oledb source components code page is not configurable now if i want to deploy the interface in a different environment which has a database with a different collation it gives a error that oledb source needs new metadata.
has anybody faced this problem earlier.please give me a solution to this problem ..
thanks in advance.
srikanth
Could you change the query to use cast around any varchar columns to force them the same or do you want to keep the collation for accents etc?Try changing the AlwaysUseDefaultCodePage property to true?
Tuesday, 14 February 2012
COnfiguring Number of records per page?
Is there a way I can specify how many records per page should be displayed?> This is a very basic functionality that needs to go in the deployment at any cost for us?...any ideas.
thanksAssuming you display your data in a list or a table, you could add a grouping expression like this: =Ceiling(RowNumber(Nothing)/20)
This will cause the list/table to group on every 20 rows. On the grouping dialog, select to add a page break on every group and you should get the desired result.
-- Robert|||Thanks Robert. This is what happened:
If there were 60 records returned, I got 3 pages (which i want) but on every page you could only see the top record?
I clicked
List --> Properties >Edit Details Group
In the Group On dialog box, I inserted :
=Ceiling(RowNumber(Nothing)/20)
Any ideas on that?
Thanks.|||
Instead of a list, use a table and add a grouping the same way. The table detail rows should then show 20 records each.
-- Robert
|||How about in a Matrix?|||hi there. i encountered the same problem, and i tired doing what you said, applying it to a table.however, it does the same thing. it only displays the first record out of 20|||
Here's a working example. The attached report has a self contained dataset and the same table twice, once using a list control with groupping applied. Hope this helps.
|||<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="master">
<ConnectionProperties>
<IntegratedSecurity>true</IntegratedSecurity>
<ConnectString>Data Source=.;Initial Catalog=master</ConnectString>
<DataProvider>SQL</DataProvider>
</ConnectionProperties>
<rd:DataSourceID>2dd60f19-bf57-4e66-80c3-288d239d3f80</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Table Name="table2">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<ZIndex>5</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Total</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<ZIndex>4</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!balance.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<ZIndex>3</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!prior_balance.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox14">
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>exc accts</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox15">
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox16">
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox17">
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Final</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox18">
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox19">
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!prior_balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Footer>
<Left>10cm</Left>
<DataSetName>DataSet1</DataSetName>
<Top>1.25cm</Top>
<ZIndex>1</ZIndex>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox20">
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!account.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox21">
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!balance.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox22">
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!prior_balance.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox23">
<ZIndex>14</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>account</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox24">
<ZIndex>13</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>balance</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox25">
<ZIndex>12</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>prior balance</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Header>
<TableColumns>
<TableColumn>
<Width>2cm</Width>
</TableColumn>
<TableColumn>
<Width>1.75cm</Width>
</TableColumn>
<TableColumn>
<Width>2.75cm</Width>
</TableColumn>
</TableColumns>
<Height>3.1746cm</Height>
</Table>
<List Name="list1">
<Left>2.25cm</Left>
<ReportItems>
<Table Name="table1">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<rd:DefaultName>textbox7</rd:DefaultName>
<ZIndex>5</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Total</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="balance_1">
<rd:DefaultName>balance_1</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!balance.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="prior_balance_1">
<rd:DefaultName>prior_balance_1</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!prior_balance.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>exc accts</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<rd:DefaultName>textbox5</rd:DefaultName>
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<rd:DefaultName>textbox6</rd:DefaultName>
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<rd:DefaultName>textbox8</rd:DefaultName>
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Final</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<rd:DefaultName>textbox9</rd:DefaultName>
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!prior_balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Footer>
<DataSetName>DataSet1</DataSetName>
<Top>0.75cm</Top>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="account">
<rd:DefaultName>account</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!account.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="balance">
<rd:DefaultName>balance</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!balance.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="prior_balance">
<rd:DefaultName>prior_balance</rd:DefaultName>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!prior_balance.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<ZIndex>14</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>account</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>13</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>balance</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<rd:DefaultName>textbox3</rd:DefaultName>
<ZIndex>12</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>prior balance</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Header>
<TableColumns>
<TableColumn>
<Width>2cm</Width>
</TableColumn>
<TableColumn>
<Width>1.75cm</Width>
</TableColumn>
<TableColumn>
<Width>2.75cm</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Top>0.5cm</Top>
<Width>6.5cm</Width>
<Grouping Name="list1_Details_Group">
<GroupExpressions>
<GroupExpression>=Ceiling(RowNumber(Nothing)/2)</GroupExpression>
</GroupExpressions>
</Grouping>
<Height>3.9246cm</Height>
</List>
</ReportItems>
<Height>5.4246cm</Height>
</Body>
<rd:ReportID>2e9a4c57-83bc-4a17-9dcd-287d47e72e3d</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select 'A' as account, 1 as type, 10 as balance, 5 as prior_balance
union
select 'B', 2, 4, 8
union
select 'C', 1, 7, 6
union
select 'D', 2, 9, 12</CommandText>
<DataSourceName>master</DataSourceName>
</Query>
<Fields>
<Field Name="account">
<rd:TypeName>System.String</rd:TypeName>
<DataField>account</DataField>
</Field>
<Field Name="type">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>type</DataField>
</Field>
<Field Name="balance">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>balance</DataField>
</Field>
<Field Name="prior_balance">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>prior_balance</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>16.5cm</Width>
<InteractiveHeight>29.7cm</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>
Hi.
I have a report containing a table and a subreport following the table. If there is enough space (if the table has less records at that page), I want the table and the subreport to be on the same page.But if there is not enough space , I want the following subreport to be on the next page.
How can I do this?
Note: The subreport may only be on the last page.
Any help would be appreciated.
COnfiguring Number of records per page?
Is there a way I can specify how many records per page should be displayed?> This is a very basic functionality that needs to go in the deployment at any cost for us?...any ideas.
thanksAssuming you display your data in a list or a table, you could add a grouping expression like this: =Ceiling(RowNumber(Nothing)/20)
This will cause the list/table to group on every 20 rows. On the grouping dialog, select to add a page break on every group and you should get the desired result.
-- Robert|||Thanks Robert. This is what happened:
If there were 60 records returned, I got 3 pages (which i want) but on every page you could only see the top record?
I clicked
List --> Properties >Edit Details Group
In the Group On dialog box, I inserted :
=Ceiling(RowNumber(Nothing)/20)
Any ideas on that?
Thanks.|||
Instead of a list, use a table and add a grouping the same way. The table detail rows should then show 20 records each.
-- Robert
|||How about in a Matrix?|||hi there. i encountered the same problem, and i tired doing what you said, applying it to a table.however, it does the same thing. it only displays the first record out of 20|||
Here's a working example. The attached report has a self contained dataset and the same table twice, once using a list control with groupping applied. Hope this helps.
|||<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="master">
<ConnectionProperties>
<IntegratedSecurity>true</IntegratedSecurity>
<ConnectString>Data Source=.;Initial Catalog=master</ConnectString>
<DataProvider>SQL</DataProvider>
</ConnectionProperties>
<rd:DataSourceID>2dd60f19-bf57-4e66-80c3-288d239d3f80</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>2.5cm</BottomMargin>
<RightMargin>2.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>21cm</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Table Name="table2">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<ZIndex>5</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Total</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox12">
<ZIndex>4</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!balance.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox13">
<ZIndex>3</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!prior_balance.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox14">
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>exc accts</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox15">
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox16">
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox17">
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Final</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox18">
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox19">
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!prior_balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Footer>
<Left>10cm</Left>
<DataSetName>DataSet1</DataSetName>
<Top>1.25cm</Top>
<ZIndex>1</ZIndex>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox20">
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!account.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox21">
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!balance.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox22">
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!prior_balance.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox23">
<ZIndex>14</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>account</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox24">
<ZIndex>13</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>balance</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox25">
<ZIndex>12</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>prior balance</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Header>
<TableColumns>
<TableColumn>
<Width>2cm</Width>
</TableColumn>
<TableColumn>
<Width>1.75cm</Width>
</TableColumn>
<TableColumn>
<Width>2.75cm</Width>
</TableColumn>
</TableColumns>
<Height>3.1746cm</Height>
</Table>
<List Name="list1">
<Left>2.25cm</Left>
<ReportItems>
<Table Name="table1">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<rd:DefaultName>textbox7</rd:DefaultName>
<ZIndex>5</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Total</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="balance_1">
<rd:DefaultName>balance_1</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!balance.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="prior_balance_1">
<rd:DefaultName>prior_balance_1</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!prior_balance.Value)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>exc accts</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<rd:DefaultName>textbox5</rd:DefaultName>
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox6">
<rd:DefaultName>textbox6</rd:DefaultName>
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox8">
<rd:DefaultName>textbox8</rd:DefaultName>
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Final</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox9">
<rd:DefaultName>textbox9</rd:DefaultName>
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!prior_balance.Value) - sum(Iif(Fields!type.Value = 1, Fields!prior_balance.Value, 0))</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Footer>
<DataSetName>DataSet1</DataSetName>
<Top>0.75cm</Top>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="account">
<rd:DefaultName>account</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!account.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="balance">
<rd:DefaultName>balance</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!balance.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="prior_balance">
<rd:DefaultName>prior_balance</rd:DefaultName>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!prior_balance.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Details>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<ZIndex>14</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>account</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>13</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>balance</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<rd:DefaultName>textbox3</rd:DefaultName>
<ZIndex>12</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>prior balance</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.63492cm</Height>
</TableRow>
</TableRows>
</Header>
<TableColumns>
<TableColumn>
<Width>2cm</Width>
</TableColumn>
<TableColumn>
<Width>1.75cm</Width>
</TableColumn>
<TableColumn>
<Width>2.75cm</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Top>0.5cm</Top>
<Width>6.5cm</Width>
<Grouping Name="list1_Details_Group">
<GroupExpressions>
<GroupExpression>=Ceiling(RowNumber(Nothing)/2)</GroupExpression>
</GroupExpressions>
</Grouping>
<Height>3.9246cm</Height>
</List>
</ReportItems>
<Height>5.4246cm</Height>
</Body>
<rd:ReportID>2e9a4c57-83bc-4a17-9dcd-287d47e72e3d</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
<DataSets>
<DataSet Name="DataSet1">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>select 'A' as account, 1 as type, 10 as balance, 5 as prior_balance
union
select 'B', 2, 4, 8
union
select 'C', 1, 7, 6
union
select 'D', 2, 9, 12</CommandText>
<DataSourceName>master</DataSourceName>
</Query>
<Fields>
<Field Name="account">
<rd:TypeName>System.String</rd:TypeName>
<DataField>account</DataField>
</Field>
<Field Name="type">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>type</DataField>
</Field>
<Field Name="balance">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>balance</DataField>
</Field>
<Field Name="prior_balance">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>prior_balance</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Width>16.5cm</Width>
<InteractiveHeight>29.7cm</InteractiveHeight>
<Language>en-US</Language>
<TopMargin>2.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>
Hi.
I have a report containing a table and a subreport following the table. If there is enough space (if the table has less records at that page), I want the table and the subreport to be on the same page.But if there is not enough space , I want the following subreport to be on the next page.
How can I do this?
Note: The subreport may only be on the last page.
Any help would be appreciated.
Subscribe to:
Posts (Atom)