Saturday, February 25, 2012

compact

No one answered in another group, please help.

Using access 2000 /msde
I know how to compact the access project file (.adp), there's a menu choice
for that.
How do I compact the tables and stored procedures on the server? ( The .MDF
file)
I only have the DOS promp OSQL utility to work with.
thanksHi

There is not a compact command as such in SQL Server. If you want to shrink
the log file check out

Log file filling up
http://www.support.microsoft.com/?id=110139

Considerations for Autogrow and AutoShrink
http://www.support.microsoft.com/?id=315512

http://www.mssqlserver.com/faq/logs-shrinklog.asp

Log File Grows too big
http://www.support.microsoft.com/?id=317375

For log file shrinking etc.. check out :

http://msdn.microsoft.com/library/d...ar_da2_1uzr.asp

and the following KB articles:

INF: How to Shrink the SQL Server 7.0 Transaction Log
http://support.microsoft.com/defaul...kb;en-us;256650

INF: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE
http://support.microsoft.com/defaul...kb;en-us;272318

Books online will give you all the T-SQL commands

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

or online: such as for DBCC
http://msdn.microsoft.com/library/d...asp?frame=true

You should also look at defragmenting the indexes using either DBCC
DBREINDEX or DBCC INDEXDEFRAG

If you want to read more about SQL Server internals then check out
"Inside SQL Server 2000" by Kalen Delany ISBN 0-7356-0998-5

John

"JIMMIE WHITAKER" <kpsklab@.worldnet.att.net> wrote in message
news:mZsTc.208334$OB3.24877@.bgtnsc05-news.ops.worldnet.att.net...
> No one answered in another group, please help.
> Using access 2000 /msde
> I know how to compact the access project file (.adp), there's a menu
choice
> for that.
> How do I compact the tables and stored procedures on the server? ( The
..MDF
> file)
> I only have the DOS promp OSQL utility to work with.
> thanks

compability of visual studio express vs visual studio

Can anyone tell me if Visual Studio Express and Visual Studio Report Designer
are compatible when designing reports? We tried to import .RDL files between
the two and were unsuccessful.
Our intent is to give our user something like Visual Studio Express to
develop reports , but yet be flexiable enough to maintain them or enhance
them using the full Visual Studio version. Or, take a report done in the full
version and allow he user to modify it in the Visual Studio Express version.
I highly doubt this is possible but I need some outside opinions on this.
Thanks for your time,
Dave SundellNone of this is necessary if you are using RS 2005. It comes with its own
version of VS. It will integrate with it if you have it, otherwise it will
install its own. If you are not writing your own assemblies then no need for
buying VS. This is a change from RS 2000.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> Can anyone tell me if Visual Studio Express and Visual Studio Report
> Designer
> are compatible when designing reports? We tried to import .RDL files
> between
> the two and were unsuccessful.
> Our intent is to give our user something like Visual Studio Express to
> develop reports , but yet be flexiable enough to maintain them or enhance
> them using the full Visual Studio version. Or, take a report done in the
> full
> version and allow he user to modify it in the Visual Studio Express
> version.
> I highly doubt this is possible but I need some outside opinions on this.
> Thanks for your time,
> Dave Sundell|||Are you talking about Report Builder in RS 2005?
I need users to beable to modify reports that were designed/developed using
Report Designer. And visa versa, beable to modify reports that were done with
Vistual Studio Express and edit them in full Visual Stduio.
I suppose we can buy them a full version of Visual Studio but some asked me
to look into Visual Studio Express. I am installing it now in a Virtual PC
mode as to not mess my normal Visual Studio environment.
Back to Report Builder. I am sorry but it is not the same as Report Designer
and we have had user experienced in Crystal reports and we need to give them
something a little closer, like Report Designer. But we were pointed towards
Visual Studio Express as a solution.
"Bruce L-C [MVP]" wrote:
> None of this is necessary if you are using RS 2005. It comes with its own
> version of VS. It will integrate with it if you have it, otherwise it will
> install its own. If you are not writing your own assemblies then no need for
> buying VS. This is a change from RS 2000.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> > Can anyone tell me if Visual Studio Express and Visual Studio Report
> > Designer
> > are compatible when designing reports? We tried to import .RDL files
> > between
> > the two and were unsuccessful.
> >
> > Our intent is to give our user something like Visual Studio Express to
> > develop reports , but yet be flexiable enough to maintain them or enhance
> > them using the full Visual Studio version. Or, take a report done in the
> > full
> > version and allow he user to modify it in the Visual Studio Express
> > version.
> >
> > I highly doubt this is possible but I need some outside opinions on this.
> >
> > Thanks for your time,
> >
> > Dave Sundell
>
>|||No, I am talking about Report Designer not Report Builder. RS 2005 when it
installed BI (or whatever it calls it, when you install Report Designer) it
will integrate with VS 2005 if you have it, otherwise it installs a special
version just for RS 2005 Report Designer.
This was not the case with RS 2000 report designer. For that you first had
to have VS 2003. Again, that is not the case for RS 2005 report designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> Are you talking about Report Builder in RS 2005?
> I need users to beable to modify reports that were designed/developed
> using
> Report Designer. And visa versa, beable to modify reports that were done
> with
> Vistual Studio Express and edit them in full Visual Stduio.
> I suppose we can buy them a full version of Visual Studio but some asked
> me
> to look into Visual Studio Express. I am installing it now in a Virtual PC
> mode as to not mess my normal Visual Studio environment.
> Back to Report Builder. I am sorry but it is not the same as Report
> Designer
> and we have had user experienced in Crystal reports and we need to give
> them
> something a little closer, like Report Designer. But we were pointed
> towards
> Visual Studio Express as a solution.
>
> "Bruce L-C [MVP]" wrote:
>> None of this is necessary if you are using RS 2005. It comes with its own
>> version of VS. It will integrate with it if you have it, otherwise it
>> will
>> install its own. If you are not writing your own assemblies then no need
>> for
>> buying VS. This is a change from RS 2000.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
>> > Can anyone tell me if Visual Studio Express and Visual Studio Report
>> > Designer
>> > are compatible when designing reports? We tried to import .RDL files
>> > between
>> > the two and were unsuccessful.
>> >
>> > Our intent is to give our user something like Visual Studio Express to
>> > develop reports , but yet be flexiable enough to maintain them or
>> > enhance
>> > them using the full Visual Studio version. Or, take a report done in
>> > the
>> > full
>> > version and allow he user to modify it in the Visual Studio Express
>> > version.
>> >
>> > I highly doubt this is possible but I need some outside opinions on
>> > this.
>> >
>> > Thanks for your time,
>> >
>> > Dave Sundell
>>|||Ist it free to anyone or if do you need a license. Is it a download or can
we allow any person to install from a SQL Server 2005 cd?
By the way, thanks for your response/time.
dave
"Bruce L-C [MVP]" wrote:
> No, I am talking about Report Designer not Report Builder. RS 2005 when it
> installed BI (or whatever it calls it, when you install Report Designer) it
> will integrate with VS 2005 if you have it, otherwise it installs a special
> version just for RS 2005 Report Designer.
> This was not the case with RS 2000 report designer. For that you first had
> to have VS 2003. Again, that is not the case for RS 2005 report designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> > Are you talking about Report Builder in RS 2005?
> >
> > I need users to beable to modify reports that were designed/developed
> > using
> > Report Designer. And visa versa, beable to modify reports that were done
> > with
> > Vistual Studio Express and edit them in full Visual Stduio.
> >
> > I suppose we can buy them a full version of Visual Studio but some asked
> > me
> > to look into Visual Studio Express. I am installing it now in a Virtual PC
> > mode as to not mess my normal Visual Studio environment.
> >
> > Back to Report Builder. I am sorry but it is not the same as Report
> > Designer
> > and we have had user experienced in Crystal reports and we need to give
> > them
> > something a little closer, like Report Designer. But we were pointed
> > towards
> > Visual Studio Express as a solution.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> None of this is necessary if you are using RS 2005. It comes with its own
> >> version of VS. It will integrate with it if you have it, otherwise it
> >> will
> >> install its own. If you are not writing your own assemblies then no need
> >> for
> >> buying VS. This is a change from RS 2000.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> >> > Can anyone tell me if Visual Studio Express and Visual Studio Report
> >> > Designer
> >> > are compatible when designing reports? We tried to import .RDL files
> >> > between
> >> > the two and were unsuccessful.
> >> >
> >> > Our intent is to give our user something like Visual Studio Express to
> >> > develop reports , but yet be flexiable enough to maintain them or
> >> > enhance
> >> > them using the full Visual Studio version. Or, take a report done in
> >> > the
> >> > full
> >> > version and allow he user to modify it in the Visual Studio Express
> >> > version.
> >> >
> >> > I highly doubt this is possible but I need some outside opinions on
> >> > this.
> >> >
> >> > Thanks for your time,
> >> >
> >> > Dave Sundell
> >>
> >>
> >>
>
>|||It is free. RS 2005 is licensed by the server. There is no cost/licensing
for the report designer. Just use the SQL 2005 CD and install Report
Designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
> Ist it free to anyone or if do you need a license. Is it a download or
> can
> we allow any person to install from a SQL Server 2005 cd?
> By the way, thanks for your response/time.
> dave
> "Bruce L-C [MVP]" wrote:
>> No, I am talking about Report Designer not Report Builder. RS 2005 when
>> it
>> installed BI (or whatever it calls it, when you install Report Designer)
>> it
>> will integrate with VS 2005 if you have it, otherwise it installs a
>> special
>> version just for RS 2005 Report Designer.
>> This was not the case with RS 2000 report designer. For that you first
>> had
>> to have VS 2003. Again, that is not the case for RS 2005 report designer.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
>> > Are you talking about Report Builder in RS 2005?
>> >
>> > I need users to beable to modify reports that were designed/developed
>> > using
>> > Report Designer. And visa versa, beable to modify reports that were
>> > done
>> > with
>> > Vistual Studio Express and edit them in full Visual Stduio.
>> >
>> > I suppose we can buy them a full version of Visual Studio but some
>> > asked
>> > me
>> > to look into Visual Studio Express. I am installing it now in a Virtual
>> > PC
>> > mode as to not mess my normal Visual Studio environment.
>> >
>> > Back to Report Builder. I am sorry but it is not the same as Report
>> > Designer
>> > and we have had user experienced in Crystal reports and we need to give
>> > them
>> > something a little closer, like Report Designer. But we were pointed
>> > towards
>> > Visual Studio Express as a solution.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> None of this is necessary if you are using RS 2005. It comes with its
>> >> own
>> >> version of VS. It will integrate with it if you have it, otherwise it
>> >> will
>> >> install its own. If you are not writing your own assemblies then no
>> >> need
>> >> for
>> >> buying VS. This is a change from RS 2000.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
>> >> > Can anyone tell me if Visual Studio Express and Visual Studio Report
>> >> > Designer
>> >> > are compatible when designing reports? We tried to import .RDL files
>> >> > between
>> >> > the two and were unsuccessful.
>> >> >
>> >> > Our intent is to give our user something like Visual Studio Express
>> >> > to
>> >> > develop reports , but yet be flexiable enough to maintain them or
>> >> > enhance
>> >> > them using the full Visual Studio version. Or, take a report done in
>> >> > the
>> >> > full
>> >> > version and allow he user to modify it in the Visual Studio Express
>> >> > version.
>> >> >
>> >> > I highly doubt this is possible but I need some outside opinions on
>> >> > this.
>> >> >
>> >> > Thanks for your time,
>> >> >
>> >> > Dave Sundell
>> >>
>> >>
>> >>
>>|||I discovered my problem. I forgot that I was sharing a report from Visual
Studio 2003 with Visual Studio Express and visa versa. Once I shared between
Visual Studio 2005 and Visual Studio Express then it worked fine. Dah.
I will look at Report Designer. Is that a simlar environment as Visual
Studio Express?
Dave
"Bruce L-C [MVP]" wrote:
> It is free. RS 2005 is licensed by the server. There is no cost/licensing
> for the report designer. Just use the SQL 2005 CD and install Report
> Designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
> > Ist it free to anyone or if do you need a license. Is it a download or
> > can
> > we allow any person to install from a SQL Server 2005 cd?
> >
> > By the way, thanks for your response/time.
> >
> > dave
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> No, I am talking about Report Designer not Report Builder. RS 2005 when
> >> it
> >> installed BI (or whatever it calls it, when you install Report Designer)
> >> it
> >> will integrate with VS 2005 if you have it, otherwise it installs a
> >> special
> >> version just for RS 2005 Report Designer.
> >>
> >> This was not the case with RS 2000 report designer. For that you first
> >> had
> >> to have VS 2003. Again, that is not the case for RS 2005 report designer.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> >> > Are you talking about Report Builder in RS 2005?
> >> >
> >> > I need users to beable to modify reports that were designed/developed
> >> > using
> >> > Report Designer. And visa versa, beable to modify reports that were
> >> > done
> >> > with
> >> > Vistual Studio Express and edit them in full Visual Stduio.
> >> >
> >> > I suppose we can buy them a full version of Visual Studio but some
> >> > asked
> >> > me
> >> > to look into Visual Studio Express. I am installing it now in a Virtual
> >> > PC
> >> > mode as to not mess my normal Visual Studio environment.
> >> >
> >> > Back to Report Builder. I am sorry but it is not the same as Report
> >> > Designer
> >> > and we have had user experienced in Crystal reports and we need to give
> >> > them
> >> > something a little closer, like Report Designer. But we were pointed
> >> > towards
> >> > Visual Studio Express as a solution.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> None of this is necessary if you are using RS 2005. It comes with its
> >> >> own
> >> >> version of VS. It will integrate with it if you have it, otherwise it
> >> >> will
> >> >> install its own. If you are not writing your own assemblies then no
> >> >> need
> >> >> for
> >> >> buying VS. This is a change from RS 2000.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> >> >> > Can anyone tell me if Visual Studio Express and Visual Studio Report
> >> >> > Designer
> >> >> > are compatible when designing reports? We tried to import .RDL files
> >> >> > between
> >> >> > the two and were unsuccessful.
> >> >> >
> >> >> > Our intent is to give our user something like Visual Studio Express
> >> >> > to
> >> >> > develop reports , but yet be flexiable enough to maintain them or
> >> >> > enhance
> >> >> > them using the full Visual Studio version. Or, take a report done in
> >> >> > the
> >> >> > full
> >> >> > version and allow he user to modify it in the Visual Studio Express
> >> >> > version.
> >> >> >
> >> >> > I highly doubt this is possible but I need some outside opinions on
> >> >> > this.
> >> >> >
> >> >> > Thanks for your time,
> >> >> >
> >> >> > Dave Sundell
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||It is a version of VS just for hosting the Report Designer. Functionally no
difference. However, it only installs if you do not have VS 2005 installed.
If VS 2005 is there then it integrates with it. Also, I found out that if
you have installed Report Designer first and then VS 2005 that you will not
see Report Designer in it. If you want Report Designer integrated with VS
(for instance you have VB.Net 2005 installed) then install VB.Net 2005
first, then report designer.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
news:760A572F-7A63-45F5-87B1-21AD05436FF2@.microsoft.com...
>I discovered my problem. I forgot that I was sharing a report from Visual
> Studio 2003 with Visual Studio Express and visa versa. Once I shared
> between
> Visual Studio 2005 and Visual Studio Express then it worked fine. Dah.
> I will look at Report Designer. Is that a simlar environment as Visual
> Studio Express?
> Dave
> "Bruce L-C [MVP]" wrote:
>> It is free. RS 2005 is licensed by the server. There is no cost/licensing
>> for the report designer. Just use the SQL 2005 CD and install Report
>> Designer.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
>> news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
>> > Ist it free to anyone or if do you need a license. Is it a download or
>> > can
>> > we allow any person to install from a SQL Server 2005 cd?
>> >
>> > By the way, thanks for your response/time.
>> >
>> > dave
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> No, I am talking about Report Designer not Report Builder. RS 2005
>> >> when
>> >> it
>> >> installed BI (or whatever it calls it, when you install Report
>> >> Designer)
>> >> it
>> >> will integrate with VS 2005 if you have it, otherwise it installs a
>> >> special
>> >> version just for RS 2005 Report Designer.
>> >>
>> >> This was not the case with RS 2000 report designer. For that you first
>> >> had
>> >> to have VS 2003. Again, that is not the case for RS 2005 report
>> >> designer.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
>> >> > Are you talking about Report Builder in RS 2005?
>> >> >
>> >> > I need users to beable to modify reports that were
>> >> > designed/developed
>> >> > using
>> >> > Report Designer. And visa versa, beable to modify reports that were
>> >> > done
>> >> > with
>> >> > Vistual Studio Express and edit them in full Visual Stduio.
>> >> >
>> >> > I suppose we can buy them a full version of Visual Studio but some
>> >> > asked
>> >> > me
>> >> > to look into Visual Studio Express. I am installing it now in a
>> >> > Virtual
>> >> > PC
>> >> > mode as to not mess my normal Visual Studio environment.
>> >> >
>> >> > Back to Report Builder. I am sorry but it is not the same as Report
>> >> > Designer
>> >> > and we have had user experienced in Crystal reports and we need to
>> >> > give
>> >> > them
>> >> > something a little closer, like Report Designer. But we were pointed
>> >> > towards
>> >> > Visual Studio Express as a solution.
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> None of this is necessary if you are using RS 2005. It comes with
>> >> >> its
>> >> >> own
>> >> >> version of VS. It will integrate with it if you have it, otherwise
>> >> >> it
>> >> >> will
>> >> >> install its own. If you are not writing your own assemblies then no
>> >> >> need
>> >> >> for
>> >> >> buying VS. This is a change from RS 2000.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
>> >> >> > Can anyone tell me if Visual Studio Express and Visual Studio
>> >> >> > Report
>> >> >> > Designer
>> >> >> > are compatible when designing reports? We tried to import .RDL
>> >> >> > files
>> >> >> > between
>> >> >> > the two and were unsuccessful.
>> >> >> >
>> >> >> > Our intent is to give our user something like Visual Studio
>> >> >> > Express
>> >> >> > to
>> >> >> > develop reports , but yet be flexiable enough to maintain them or
>> >> >> > enhance
>> >> >> > them using the full Visual Studio version. Or, take a report done
>> >> >> > in
>> >> >> > the
>> >> >> > full
>> >> >> > version and allow he user to modify it in the Visual Studio
>> >> >> > Express
>> >> >> > version.
>> >> >> >
>> >> >> > I highly doubt this is possible but I need some outside opinions
>> >> >> > on
>> >> >> > this.
>> >> >> >
>> >> >> > Thanks for your time,
>> >> >> >
>> >> >> > Dave Sundell
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Bruce,
Thank you for your time and response to this matter.
In conclusion, I did install Report Designer and it seems to be a better
route then installing SQL Express since the user really doesn't need SQL
installed but simply the environment to design a report.
Thanks again.
"Bruce L-C [MVP]" wrote:
> It is a version of VS just for hosting the Report Designer. Functionally no
> difference. However, it only installs if you do not have VS 2005 installed.
> If VS 2005 is there then it integrates with it. Also, I found out that if
> you have installed Report Designer first and then VS 2005 that you will not
> see Report Designer in it. If you want Report Designer integrated with VS
> (for instance you have VB.Net 2005 installed) then install VB.Net 2005
> first, then report designer.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> news:760A572F-7A63-45F5-87B1-21AD05436FF2@.microsoft.com...
> >I discovered my problem. I forgot that I was sharing a report from Visual
> > Studio 2003 with Visual Studio Express and visa versa. Once I shared
> > between
> > Visual Studio 2005 and Visual Studio Express then it worked fine. Dah.
> >
> > I will look at Report Designer. Is that a simlar environment as Visual
> > Studio Express?
> >
> > Dave
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> It is free. RS 2005 is licensed by the server. There is no cost/licensing
> >> for the report designer. Just use the SQL 2005 CD and install Report
> >> Designer.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in message
> >> news:D3462064-E935-48E1-8AE4-A57492F17FE7@.microsoft.com...
> >> > Ist it free to anyone or if do you need a license. Is it a download or
> >> > can
> >> > we allow any person to install from a SQL Server 2005 cd?
> >> >
> >> > By the way, thanks for your response/time.
> >> >
> >> > dave
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> No, I am talking about Report Designer not Report Builder. RS 2005
> >> >> when
> >> >> it
> >> >> installed BI (or whatever it calls it, when you install Report
> >> >> Designer)
> >> >> it
> >> >> will integrate with VS 2005 if you have it, otherwise it installs a
> >> >> special
> >> >> version just for RS 2005 Report Designer.
> >> >>
> >> >> This was not the case with RS 2000 report designer. For that you first
> >> >> had
> >> >> to have VS 2003. Again, that is not the case for RS 2005 report
> >> >> designer.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
> >> >> message
> >> >> news:4252933C-EE43-4031-A81E-212B29174391@.microsoft.com...
> >> >> > Are you talking about Report Builder in RS 2005?
> >> >> >
> >> >> > I need users to beable to modify reports that were
> >> >> > designed/developed
> >> >> > using
> >> >> > Report Designer. And visa versa, beable to modify reports that were
> >> >> > done
> >> >> > with
> >> >> > Vistual Studio Express and edit them in full Visual Stduio.
> >> >> >
> >> >> > I suppose we can buy them a full version of Visual Studio but some
> >> >> > asked
> >> >> > me
> >> >> > to look into Visual Studio Express. I am installing it now in a
> >> >> > Virtual
> >> >> > PC
> >> >> > mode as to not mess my normal Visual Studio environment.
> >> >> >
> >> >> > Back to Report Builder. I am sorry but it is not the same as Report
> >> >> > Designer
> >> >> > and we have had user experienced in Crystal reports and we need to
> >> >> > give
> >> >> > them
> >> >> > something a little closer, like Report Designer. But we were pointed
> >> >> > towards
> >> >> > Visual Studio Express as a solution.
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> None of this is necessary if you are using RS 2005. It comes with
> >> >> >> its
> >> >> >> own
> >> >> >> version of VS. It will integrate with it if you have it, otherwise
> >> >> >> it
> >> >> >> will
> >> >> >> install its own. If you are not writing your own assemblies then no
> >> >> >> need
> >> >> >> for
> >> >> >> buying VS. This is a change from RS 2000.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >> "Dave Sundell" <DaveSundell@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:8A6273A3-DFB6-4F5A-B197-26F5755485C4@.microsoft.com...
> >> >> >> > Can anyone tell me if Visual Studio Express and Visual Studio
> >> >> >> > Report
> >> >> >> > Designer
> >> >> >> > are compatible when designing reports? We tried to import .RDL
> >> >> >> > files
> >> >> >> > between
> >> >> >> > the two and were unsuccessful.
> >> >> >> >
> >> >> >> > Our intent is to give our user something like Visual Studio
> >> >> >> > Express
> >> >> >> > to
> >> >> >> > develop reports , but yet be flexiable enough to maintain them or
> >> >> >> > enhance
> >> >> >> > them using the full Visual Studio version. Or, take a report done
> >> >> >> > in
> >> >> >> > the
> >> >> >> > full
> >> >> >> > version and allow he user to modify it in the Visual Studio
> >> >> >> > Express
> >> >> >> > version.
> >> >> >> >
> >> >> >> > I highly doubt this is possible but I need some outside opinions
> >> >> >> > on
> >> >> >> > this.
> >> >> >> >
> >> >> >> > Thanks for your time,
> >> >> >> >
> >> >> >> > Dave Sundell
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

COMP.DATABASES.MS-SQLSERVER - Outlook Express

Hi,
Can the comp.databases.ms-sqlserver newsgroup be added to Outlook Express?
If so what is the connection information?
Thanks
JerryHi
Yes. Use your ISP's news server to connect. Contact your ISP for that
information.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%232mRV36vFHA.720@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Can the comp.databases.ms-sqlserver newsgroup be added to Outlook Express?
> If so what is the connection information?
> Thanks
> Jerry
>|||Yes, but the comp. hierarchy isn't carried on the msnews server. You need to
subscribe to another NNTP service if you don't already have one.
http://www.newsreaders.com/newsfeeds/index.html
Alternatively, use a web-based newsreader such as: http://groups.google.com
--
David Portas
SQL Server MVP
--|||Thanks guys.
Jerry
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:UK2dnWJd-84gka7eRVn-tA@.giganews.com...
> Yes, but the comp. hierarchy isn't carried on the msnews server. You need
> to subscribe to another NNTP service if you don't already have one.
> http://www.newsreaders.com/newsfeeds/index.html
> Alternatively, use a web-based newsreader such as:
> http://groups.google.com
> --
> David Portas
> SQL Server MVP
> --
>

COMP.DATABASES.MS-SQLSERVER - Outlook Express

Hi,
Can the comp.databases.ms-sqlserver newsgroup be added to Outlook Express?
If so what is the connection information?
Thanks
Jerry
Hi
Yes. Use your ISP's news server to connect. Contact your ISP for that
information.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%232mRV36vFHA.720@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Can the comp.databases.ms-sqlserver newsgroup be added to Outlook Express?
> If so what is the connection information?
> Thanks
> Jerry
>
|||Yes, but the comp. hierarchy isn't carried on the msnews server. You need to
subscribe to another NNTP service if you don't already have one.
http://www.newsreaders.com/newsfeeds/index.html
Alternatively, use a web-based newsreader such as: http://groups.google.com
David Portas
SQL Server MVP
|||Thanks guys.
Jerry
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:UK2dnWJd-84gka7eRVn-tA@.giganews.com...
> Yes, but the comp. hierarchy isn't carried on the msnews server. You need
> to subscribe to another NNTP service if you don't already have one.
> http://www.newsreaders.com/newsfeeds/index.html
> Alternatively, use a web-based newsreader such as:
> http://groups.google.com
> --
> David Portas
> SQL Server MVP
> --
>

COMP.DATABASES.MS-SQLSERVER - Outlook Express

Hi,
Can the comp.databases.ms-sqlserver newsgroup be added to Outlook Express?
If so what is the connection information?
Thanks
JerryHi
Yes. Use your ISP's news server to connect. Contact your ISP for that
information.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jerry Spivey" <jspivey@.vestas-awt.com> wrote in message
news:%232mRV36vFHA.720@.TK2MSFTNGP15.phx.gbl...
> Hi,
> Can the comp.databases.ms-sqlserver newsgroup be added to Outlook Express?
> If so what is the connection information?
> Thanks
> Jerry
>|||Yes, but the comp. hierarchy isn't carried on the msnews server. You need to
subscribe to another NNTP service if you don't already have one.
http://www.newsreaders.com/newsfeeds/index.html
Alternatively, use a web-based newsreader such as: http://groups.google.com
David Portas
SQL Server MVP
--|||Thanks guys.
Jerry
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:UK2dnWJd-84gka7eRVn-tA@.giganews.com...
> Yes, but the comp. hierarchy isn't carried on the msnews server. You need
> to subscribe to another NNTP service if you don't already have one.
> http://www.newsreaders.com/newsfeeds/index.html
> Alternatively, use a web-based newsreader such as:
> http://groups.google.com
> --
> David Portas
> SQL Server MVP
> --
>

Community Question: Fastest update path for experienced SQL Server 2000 developers.

Hi,
I have several years of experience working on SQL server versions 7-2000.
Now I would like to update my knowledge to SQL Server 2005. The problem is
that most of books I saw try to explain old SQL 2000 features mixed with new
SQL 2005 features.
Could you refer me to books or resources that update my SQL Server knowledge
without bothering with explaining old SQL 2000 related features?
Any help would be appreciated,
MaxHello Maxwell2006,
If you like books, go with http://www.aw-bc.com/catalog/academ...1382188,00.html
(when it comes out)
If you like class room training, come spend a w with me... ;)
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||Hi Kent,
Thank you for reply.
I am looking for online type of resources and ready to buy books. Do you
know any?
Regards,
Max
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad74171d48c8144990ba2865@.news.microsoft.com...
> Hello Maxwell2006,
> If you like books, go with
> http://www.aw-bc.com/catalog/academ...1382188,00.html
> (when it comes out)
> If you like class room training, come spend a w with me... ;)
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>|||On Sun, 12 Mar 2006 23:57:03 -0500, Maxwell2006 wrote:
(snip)
>Could you refer me to books or resources that update my SQL Server knowledg
e
>without bothering with explaining old SQL 2000 related features?
Hi Max,
I'm in the exact same situation. I've recently (last w) picked up a
copy of "Pro SQL Server 2005" (by Thomas Rizzo et. al.) It does exactly
what you and I want: skip past everything that was already present in
SQL Server 2005 and plunge right into the new features.
First impressions are good, though I should hasten to add that I'm only
halfway chapter 2 yet.
Hugo Kornelis, SQL Server MVP|||Thank you very much Hugo. I was thinking about that book last night and I
wasn't sure I should go ahead or not. Now I am going to order it with
confident.
Thanks again,
Max
"Hugo Kornelis" <hugo@.perFact.REMOVETHIS.info.INVALID> wrote in message
news:fk2c1252kk2b3o28qf2lu5me1dfuemsrs3@.
4ax.com...
> On Sun, 12 Mar 2006 23:57:03 -0500, Maxwell2006 wrote:
> (snip)
> Hi Max,
> I'm in the exact same situation. I've recently (last w) picked up a
> copy of "Pro SQL Server 2005" (by Thomas Rizzo et. al.) It does exactly
> what you and I want: skip past everything that was already present in
> SQL Server 2005 and plunge right into the new features.
> First impressions are good, though I should hasten to add that I'm only
> halfway chapter 2 yet.
> --
> Hugo Kornelis, SQL Server MVP

Communications link failure #0

We are intermittently getting this error on our SQL server. The front end is
access and this happens every so often causing the users to have to exit out
of access and reconnect. I'm by no means a SQL expert, and our programmer
who manages this database isn't sure what it is either, he says it's like
the server is just "forgetting his password" and dumping the ODBC
connection...
Any ideas/help would be appreciated.
Thanks!
Scott
Hi
You don't give what version of MDAC or SQL Server that you are using!
http://www.aspfaq.com/show.asp?id=2160
http://msdn.microsoft.com/data/mdac/default.aspx
Searching Google for "Communications link failure" turns up quite a few
things, it seemed to be quite common with SQL Server 6.5!
You may want to check that you don't have connection pooling.
Try logging the ODBC commands (on the client) and using Profiler on the
server to pin point if there is one particular set of circumstances when it
occurs.
Check your SQL Server logs and Event logs (on client and server) to see if
there in any information or event that corresponds to the timing of your
disconnections.
Use the MDAC component check to show the version and if you have a
consistent installation.
HTH
John
"Scott McDonald" wrote:

> We are intermittently getting this error on our SQL server. The front end is
> access and this happens every so often causing the users to have to exit out
> of access and reconnect. I'm by no means a SQL expert, and our programmer
> who manages this database isn't sure what it is either, he says it's like
> the server is just "forgetting his password" and dumping the ODBC
> connection...
> Any ideas/help would be appreciated.
> Thanks!
> Scott
>
>
|||it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
newest, which I think is x.7 or something...
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...[vbcol=seagreen]
> Hi
> You don't give what version of MDAC or SQL Server that you are using!
> http://www.aspfaq.com/show.asp?id=2160
> http://msdn.microsoft.com/data/mdac/default.aspx
> Searching Google for "Communications link failure" turns up quite a few
> things, it seemed to be quite common with SQL Server 6.5!
> You may want to check that you don't have connection pooling.
> Try logging the ODBC commands (on the client) and using Profiler on the
> server to pin point if there is one particular set of circumstances when
> it
> occurs.
> Check your SQL Server logs and Event logs (on client and server) to see if
> there in any information or event that corresponds to the timing of your
> disconnections.
> Use the MDAC component check to show the version and if you have a
> consistent installation.
> HTH
> John
>
> "Scott McDonald" wrote:
|||Hi
You may also want to switch protocols and check out the network in
general for possible problems.
John
Scott McDonald wrote:
> it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
[vbcol=seagreen]
> newest, which I think is x.7 or something...
>
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...
using![vbcol=seagreen]
few[vbcol=seagreen]
the[vbcol=seagreen]
when[vbcol=seagreen]
see if[vbcol=seagreen]
your[vbcol=seagreen]
front end[vbcol=seagreen]
to exit[vbcol=seagreen]
programmer[vbcol=seagreen]
it's like[vbcol=seagreen]

Communications link failure #0

We are intermittently getting this error on our SQL server. The front end is
access and this happens every so often causing the users to have to exit out
of access and reconnect. I'm by no means a SQL expert, and our programmer
who manages this database isn't sure what it is either, he says it's like
the server is just "forgetting his password" and dumping the ODBC
connection...
Any ideas/help would be appreciated.
Thanks!
Scott
Hi
You don't give what version of MDAC or SQL Server that you are using!
http://www.aspfaq.com/show.asp?id=2160
http://msdn.microsoft.com/data/mdac/default.aspx
Searching Google for "Communications link failure" turns up quite a few
things, it seemed to be quite common with SQL Server 6.5!
You may want to check that you don't have connection pooling.
Try logging the ODBC commands (on the client) and using Profiler on the
server to pin point if there is one particular set of circumstances when it
occurs.
Check your SQL Server logs and Event logs (on client and server) to see if
there in any information or event that corresponds to the timing of your
disconnections.
Use the MDAC component check to show the version and if you have a
consistent installation.
HTH
John
"Scott McDonald" wrote:

> We are intermittently getting this error on our SQL server. The front end is
> access and this happens every so often causing the users to have to exit out
> of access and reconnect. I'm by no means a SQL expert, and our programmer
> who manages this database isn't sure what it is either, he says it's like
> the server is just "forgetting his password" and dumping the ODBC
> connection...
> Any ideas/help would be appreciated.
> Thanks!
> Scott
>
>
|||it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
newest, which I think is x.7 or something...
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...[vbcol=seagreen]
> Hi
> You don't give what version of MDAC or SQL Server that you are using!
> http://www.aspfaq.com/show.asp?id=2160
> http://msdn.microsoft.com/data/mdac/default.aspx
> Searching Google for "Communications link failure" turns up quite a few
> things, it seemed to be quite common with SQL Server 6.5!
> You may want to check that you don't have connection pooling.
> Try logging the ODBC commands (on the client) and using Profiler on the
> server to pin point if there is one particular set of circumstances when
> it
> occurs.
> Check your SQL Server logs and Event logs (on client and server) to see if
> there in any information or event that corresponds to the timing of your
> disconnections.
> Use the MDAC component check to show the version and if you have a
> consistent installation.
> HTH
> John
>
> "Scott McDonald" wrote:
|||Hi
You may also want to switch protocols and check out the network in
general for possible problems.
John
Scott McDonald wrote:
> it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
[vbcol=seagreen]
> newest, which I think is x.7 or something...
>
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...
using![vbcol=seagreen]
few[vbcol=seagreen]
the[vbcol=seagreen]
when[vbcol=seagreen]
see if[vbcol=seagreen]
your[vbcol=seagreen]
front end[vbcol=seagreen]
to exit[vbcol=seagreen]
programmer[vbcol=seagreen]
it's like[vbcol=seagreen]

Communications link failure #0

We are intermittently getting this error on our SQL server. The front end is
access and this happens every so often causing the users to have to exit out
of access and reconnect. I'm by no means a SQL expert, and our programmer
who manages this database isn't sure what it is either, he says it's like
the server is just "forgetting his password" and dumping the ODBC
connection...
Any ideas/help would be appreciated.
Thanks!
ScottHi
You don't give what version of MDAC or SQL Server that you are using!
http://www.aspfaq.com/show.asp?id=2160
http://msdn.microsoft.com/data/mdac/default.aspx
Searching Google for "Communications link failure" turns up quite a few
things, it seemed to be quite common with SQL Server 6.5!
You may want to check that you don't have connection pooling.
Try logging the ODBC commands (on the client) and using Profiler on the
server to pin point if there is one particular set of circumstances when it
occurs.
Check your SQL Server logs and Event logs (on client and server) to see if
there in any information or event that corresponds to the timing of your
disconnections.
Use the MDAC component check to show the version and if you have a
consistent installation.
HTH
John
"Scott McDonald" wrote:

> We are intermittently getting this error on our SQL server. The front end
is
> access and this happens every so often causing the users to have to exit o
ut
> of access and reconnect. I'm by no means a SQL expert, and our programmer
> who manages this database isn't sure what it is either, he says it's like
> the server is just "forgetting his password" and dumping the ODBC
> connection...
> Any ideas/help would be appreciated.
> Thanks!
> Scott
>
>|||it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
newest, which I think is x.7 or something...
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...[vbcol=seagreen]
> Hi
> You don't give what version of MDAC or SQL Server that you are using!
> http://www.aspfaq.com/show.asp?id=2160
> http://msdn.microsoft.com/data/mdac/default.aspx
> Searching Google for "Communications link failure" turns up quite a few
> things, it seemed to be quite common with SQL Server 6.5!
> You may want to check that you don't have connection pooling.
> Try logging the ODBC commands (on the client) and using Profiler on the
> server to pin point if there is one particular set of circumstances when
> it
> occurs.
> Check your SQL Server logs and Event logs (on client and server) to see if
> there in any information or event that corresponds to the timing of your
> disconnections.
> Use the MDAC component check to show the version and if you have a
> consistent installation.
> HTH
> John
>
> "Scott McDonald" wrote:
>|||Hi
You may also want to switch protocols and check out the network in
general for possible problems.
John
Scott McDonald wrote:
> it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
[vbcol=seagreen]
> newest, which I think is x.7 or something...
>
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...
using![vbcol=seagreen]
few[vbcol=seagreen]
the[vbcol=seagreen]
when[vbcol=seagreen]
see if[vbcol=seagreen]
your[vbcol=seagreen]
front end[vbcol=seagreen]
to exit[vbcol=seagreen]
programmer[vbcol=seagreen]
it's like[vbcol=seagreen]

Communications link failure #0

We are intermittently getting this error on our SQL server. The front end is
access and this happens every so often causing the users to have to exit out
of access and reconnect. I'm by no means a SQL expert, and our programmer
who manages this database isn't sure what it is either, he says it's like
the server is just "forgetting his password" and dumping the ODBC
connection...
Any ideas/help would be appreciated.
Thanks!
Scott
Hi
You don't give what version of MDAC or SQL Server that you are using!
http://www.aspfaq.com/show.asp?id=2160
http://msdn.microsoft.com/data/mdac/default.aspx
Searching Google for "Communications link failure" turns up quite a few
things, it seemed to be quite common with SQL Server 6.5!
You may want to check that you don't have connection pooling.
Try logging the ODBC commands (on the client) and using Profiler on the
server to pin point if there is one particular set of circumstances when it
occurs.
Check your SQL Server logs and Event logs (on client and server) to see if
there in any information or event that corresponds to the timing of your
disconnections.
Use the MDAC component check to show the version and if you have a
consistent installation.
HTH
John
"Scott McDonald" wrote:

> We are intermittently getting this error on our SQL server. The front end is
> access and this happens every so often causing the users to have to exit out
> of access and reconnect. I'm by no means a SQL expert, and our programmer
> who manages this database isn't sure what it is either, he says it's like
> the server is just "forgetting his password" and dumping the ODBC
> connection...
> Any ideas/help would be appreciated.
> Thanks!
> Scott
>
>
|||it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
newest, which I think is x.7 or something...
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...[vbcol=seagreen]
> Hi
> You don't give what version of MDAC or SQL Server that you are using!
> http://www.aspfaq.com/show.asp?id=2160
> http://msdn.microsoft.com/data/mdac/default.aspx
> Searching Google for "Communications link failure" turns up quite a few
> things, it seemed to be quite common with SQL Server 6.5!
> You may want to check that you don't have connection pooling.
> Try logging the ODBC commands (on the client) and using Profiler on the
> server to pin point if there is one particular set of circumstances when
> it
> occurs.
> Check your SQL Server logs and Event logs (on client and server) to see if
> there in any information or event that corresponds to the timing of your
> disconnections.
> Use the MDAC component check to show the version and if you have a
> consistent installation.
> HTH
> John
>
> "Scott McDonald" wrote:
|||Hi
You may also want to switch protocols and check out the network in
general for possible problems.
John
Scott McDonald wrote:
> it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
[vbcol=seagreen]
> newest, which I think is x.7 or something...
>
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...
using![vbcol=seagreen]
few[vbcol=seagreen]
the[vbcol=seagreen]
when[vbcol=seagreen]
see if[vbcol=seagreen]
your[vbcol=seagreen]
front end[vbcol=seagreen]
to exit[vbcol=seagreen]
programmer[vbcol=seagreen]
it's like[vbcol=seagreen]

Communications link failure #0

We are intermittently getting this error on our SQL server. The front end is
access and this happens every so often causing the users to have to exit out
of access and reconnect. I'm by no means a SQL expert, and our programmer
who manages this database isn't sure what it is either, he says it's like
the server is just "forgetting his password" and dumping the ODBC
connection...
Any ideas/help would be appreciated.
Thanks!
Scott
Hi
You don't give what version of MDAC or SQL Server that you are using!
http://www.aspfaq.com/show.asp?id=2160
http://msdn.microsoft.com/data/mdac/default.aspx
Searching Google for "Communications link failure" turns up quite a few
things, it seemed to be quite common with SQL Server 6.5!
You may want to check that you don't have connection pooling.
Try logging the ODBC commands (on the client) and using Profiler on the
server to pin point if there is one particular set of circumstances when it
occurs.
Check your SQL Server logs and Event logs (on client and server) to see if
there in any information or event that corresponds to the timing of your
disconnections.
Use the MDAC component check to show the version and if you have a
consistent installation.
HTH
John
"Scott McDonald" wrote:

> We are intermittently getting this error on our SQL server. The front end is
> access and this happens every so often causing the users to have to exit out
> of access and reconnect. I'm by no means a SQL expert, and our programmer
> who manages this database isn't sure what it is either, he says it's like
> the server is just "forgetting his password" and dumping the ODBC
> connection...
> Any ideas/help would be appreciated.
> Thanks!
> Scott
>
>
|||it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
newest, which I think is x.7 or something...
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...[vbcol=seagreen]
> Hi
> You don't give what version of MDAC or SQL Server that you are using!
> http://www.aspfaq.com/show.asp?id=2160
> http://msdn.microsoft.com/data/mdac/default.aspx
> Searching Google for "Communications link failure" turns up quite a few
> things, it seemed to be quite common with SQL Server 6.5!
> You may want to check that you don't have connection pooling.
> Try logging the ODBC commands (on the client) and using Profiler on the
> server to pin point if there is one particular set of circumstances when
> it
> occurs.
> Check your SQL Server logs and Event logs (on client and server) to see if
> there in any information or event that corresponds to the timing of your
> disconnections.
> Use the MDAC component check to show the version and if you have a
> consistent installation.
> HTH
> John
>
> "Scott McDonald" wrote:
|||Hi
You may also want to switch protocols and check out the network in
general for possible problems.
John
Scott McDonald wrote:
> it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
[vbcol=seagreen]
> newest, which I think is x.7 or something...
>
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...
using![vbcol=seagreen]
few[vbcol=seagreen]
the[vbcol=seagreen]
when[vbcol=seagreen]
see if[vbcol=seagreen]
your[vbcol=seagreen]
front end[vbcol=seagreen]
to exit[vbcol=seagreen]
programmer[vbcol=seagreen]
it's like[vbcol=seagreen]

Communications link failure #0

We are intermittently getting this error on our SQL server. The front end is
access and this happens every so often causing the users to have to exit out
of access and reconnect. I'm by no means a SQL expert, and our programmer
who manages this database isn't sure what it is either, he says it's like
the server is just "forgetting his password" and dumping the ODBC
connection...
Any ideas/help would be appreciated.
Thanks!
ScottHi
You don't give what version of MDAC or SQL Server that you are using!
http://www.aspfaq.com/show.asp?id=2160
http://msdn.microsoft.com/data/mdac/default.aspx
Searching Google for "Communications link failure" turns up quite a few
things, it seemed to be quite common with SQL Server 6.5!
You may want to check that you don't have connection pooling.
Try logging the ODBC commands (on the client) and using Profiler on the
server to pin point if there is one particular set of circumstances when it
occurs.
Check your SQL Server logs and Event logs (on client and server) to see if
there in any information or event that corresponds to the timing of your
disconnections.
Use the MDAC component check to show the version and if you have a
consistent installation.
HTH
John
"Scott McDonald" wrote:
> We are intermittently getting this error on our SQL server. The front end is
> access and this happens every so often causing the users to have to exit out
> of access and reconnect. I'm by no means a SQL expert, and our programmer
> who manages this database isn't sure what it is either, he says it's like
> the server is just "forgetting his password" and dumping the ODBC
> connection...
> Any ideas/help would be appreciated.
> Thanks!
> Scott
>
>|||it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
newest, which I think is x.7 or something...
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...
> Hi
> You don't give what version of MDAC or SQL Server that you are using!
> http://www.aspfaq.com/show.asp?id=2160
> http://msdn.microsoft.com/data/mdac/default.aspx
> Searching Google for "Communications link failure" turns up quite a few
> things, it seemed to be quite common with SQL Server 6.5!
> You may want to check that you don't have connection pooling.
> Try logging the ODBC commands (on the client) and using Profiler on the
> server to pin point if there is one particular set of circumstances when
> it
> occurs.
> Check your SQL Server logs and Event logs (on client and server) to see if
> there in any information or event that corresponds to the timing of your
> disconnections.
> Use the MDAC component check to show the version and if you have a
> consistent installation.
> HTH
> John
>
> "Scott McDonald" wrote:
>> We are intermittently getting this error on our SQL server. The front end
>> is
>> access and this happens every so often causing the users to have to exit
>> out
>> of access and reconnect. I'm by no means a SQL expert, and our programmer
>> who manages this database isn't sure what it is either, he says it's like
>> the server is just "forgetting his password" and dumping the ODBC
>> connection...
>> Any ideas/help would be appreciated.
>> Thanks!
>> Scott
>>|||Hi
You may also want to switch protocols and check out the network in
general for possible problems.
John
Scott McDonald wrote:
> it's SQL 2000 on Windows 2003 and using Access 2003 - sorry . MDAC is
> newest, which I think is x.7 or something...
>
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:2B4BF663-A19B-4E40-B44A-D9684B757E4B@.microsoft.com...
> > Hi
> >
> > You don't give what version of MDAC or SQL Server that you are
using!
> > http://www.aspfaq.com/show.asp?id=2160
> > http://msdn.microsoft.com/data/mdac/default.aspx
> >
> > Searching Google for "Communications link failure" turns up quite a
few
> > things, it seemed to be quite common with SQL Server 6.5!
> >
> > You may want to check that you don't have connection pooling.
> >
> > Try logging the ODBC commands (on the client) and using Profiler on
the
> > server to pin point if there is one particular set of circumstances
when
> > it
> > occurs.
> >
> > Check your SQL Server logs and Event logs (on client and server) to
see if
> > there in any information or event that corresponds to the timing of
your
> > disconnections.
> >
> > Use the MDAC component check to show the version and if you have a
> > consistent installation.
> >
> > HTH
> >
> > John
> >
> >
> > "Scott McDonald" wrote:
> >
> >> We are intermittently getting this error on our SQL server. The
front end
> >> is
> >> access and this happens every so often causing the users to have
to exit
> >> out
> >> of access and reconnect. I'm by no means a SQL expert, and our
programmer
> >> who manages this database isn't sure what it is either, he says
it's like
> >> the server is just "forgetting his password" and dumping the ODBC
> >> connection...
> >>
> >> Any ideas/help would be appreciated.
> >>
> >> Thanks!
> >>
> >> Scott
> >>
> >>
> >>

Communications between Datasets

Is there any way to put together data from multiple datasets into one in
order to generate a single report?
ThanksHi,
You can define multiple datasets into the same report definition in order to
put their data in the same report.
In the other hand, if you want to put data from different datasets in the
same table or list, you need to use subreports (See post tittled "Fields
from Multiple Datasets" into this news group.
Hope this helps,
Mónica
"markgoldin" <markgoldin_2000@.yahoo.com> escribió en el mensaje
news:364A7754-9D67-4F8A-8528-CEEE5A924C46@.microsoft.com...
> Is there any way to put together data from multiple datasets into one in
> order to generate a single report?
> Thanks|||On Dec 12, 6:23 am, "markgoldin" <markgoldin_2...@.yahoo.com> wrote:
> Is there any way to put together data from multiple datasets into one in
> order to generate a single report?
> Thanks
You may put all your data into text boxes from several datasets. You
can also use tables, but one dataset per table. So if you don't mind
having separate datasets on separate tables then go for it.

Communication Link Failure?

Hai,

Iam using VC++ application to connect remote database(MSSQL) through network.

Everything works fine, if the network connection is active. If the network breaks and resumes, the application throws "Communication Link Failure" and do not get connected even after the network is resumed.

Client :

* Windows 2000 Professional

* MDAC 2.5

* VC++, using framework- CRecordset to access database

* PEER to PEER network configuration

* DSN through ODBC

Server :

* Windows 2000 Professional

* MDAC 2.8

* MSSQL Server

how to resume the database connection ?

Any one help me?

Thanks in advance,

If an existing connection fails due to broken network connectivity the client application must open a new connection to the server.

Does the new connection fail as well? If so, what is the full error message text?

|||

No..if the application is restarted the connection resumes..

Do i have to make a new connection after the broken network connectivity? Is there any other solution without reconnecting?

|||

Yes, you have to make a new connection after the broken network connectivity.

|||Thank you..

Communication link failure...

Hello,
We are the authors of an application written in PowerBuilder (type
Client-Server, database MSSQLServer2000).
After some time (1 hour) of client inactivity happens disconnect from server
and aplication reports error 'Communication link failure ...'

Please, would you help me, if exists some way how to set up an interval of
the connectivity between Client and Server. I wasnt able to find it out in
any help or manual.

Thank you very much in advance!
PavelOn Fri, 02 Apr 2004 16:31:41 +0200, Pavel Vetesnik wrote:

> Hello,
> We are the authors of an application written in PowerBuilder (type
> Client-Server, database MSSQLServer2000). After some time (1 hour) of
> client inactivity happens disconnect from server and aplication reports
> error 'Communication link failure ...'
> Please, would you help me, if exists some way how to set up an interval of
> the connectivity between Client and Server. I wasnt able to find it out
> in any help or manual.
> Thank you very much in advance!
> Pavel

You should add code to your application to capture the login dialogue
and log back on to the server in the event the server has dropped the
session and the SAME client session wishes to communicate with the server.

I suggest this because the timeout value used by the server could change
from release to release or be changed by the network/system administrators
if resource usage gets too high.

Communication link failure.

What could cause the Microsoft error listed below?
[Microsoft][ODBC SQL Server Driver]Communication link failure.
Thanks,Hi
Loosing connectivity to the server.
In what scenario does this occur?
Normally, network connectivity problems between a server and a client are
caused by faulty network cards, cables and switches. Also check that your
network drivers are up to date.
Regards
Mike
"Joe K." wrote:
> What could cause the Microsoft error listed below?
> [Microsoft][ODBC SQL Server Driver]Communication link failure.
> Thanks,

Communication link failure.

What could cause the Microsoft error listed below?
[Microsoft][ODBC SQL Server Driver]Communication link failure.
Thanks,
Hi
Loosing connectivity to the server.
In what scenario does this occur?
Normally, network connectivity problems between a server and a client are
caused by faulty network cards, cables and switches. Also check that your
network drivers are up to date.
Regards
Mike
"Joe K." wrote:

> What could cause the Microsoft error listed below?
> [Microsoft][ODBC SQL Server Driver]Communication link failure.
> Thanks,

Communication link failure.

What could cause the Microsoft error listed below?
[Microsoft][ODBC SQL Server Driver]Communication link failure.
Thanks,Hi
Loosing connectivity to the server.
In what scenario does this occur?
Normally, network connectivity problems between a server and a client are
caused by faulty network cards, cables and switches. Also check that your
network drivers are up to date.
Regards
Mike
"Joe K." wrote:

> What could cause the Microsoft error listed below?
> [Microsoft][ODBC SQL Server Driver]Communication link failure.
> Thanks,

Communication Link Failure Error

Hi,

I am using ADO in my application to connect and retrieve data from Microsoft SQL Server 2000 SP4. When I start my application, it establishes connection to the server successfully and I am able to retrieve data from the server. here is my test scenario:

1. unplug the network cable from the client machine and put the cable back in after some time. I disconnect from the database in my code when the client machine disconnects from the network

2. Once the client machine comes back on the network, I try to reconnect and retrieve data from the sql server but I get the following error message when I try to execute a sql command:

[Microsoft][ODBC SQL Server Driver]Communication Link failure

This problem occurs only with Window XP SP2. With XP SP1 it works fine. It seems to be problem on the client side as with Windows XP SP1 I do not get this error message at all.

Here are the various details:

1. The firewall is off on the client workstation.

2. the connection string is:

driver={SQL Server};server=AA;uid=BB;pwd=CC;database=DD

where AA = DNS name of server machine where sql server is running.

BB = user name

CC = password

DD= database name

3. The client is remote to the server.

4. I can ping the server machine when the client machine reconnects to the network.

5. I can still telnet the server when the client machine reconnects to the network.

6. client database provider is MDAC odbc.

7. the client and server machines are in the same domain.

8. Shared memory and TCPIP protocols are enabled and TCP is at the top of the list.

9. No alias is being used.

10. Viris scan is not installed.

11. force encriptioned is NOT checked.

Please reply.

It appears a connection pooling issue. The closed connections by the client app are returned to the pool and become invalid after you unplug the cable. Next time you try to connect, odbc reuse the invalid connectin and throw the error. Retry your connection or disable pooling should resolve your issue.|||

I am already doing this:

1. When the machine disconnects from the network, I close the database connection. when the machine reconnects to the network, I try to establish a new connection to the database.

2. The connection pooling is also disabled for SQL server odbc driver under Connection Pooling tab of ODBC Data Source Administrator.

Please reply.

|||

Good day,

Tahir posted this request in Oct this year, has there been any response yet?

We are experiencing exactely the same problem in completely different ODBC client and are desperately looking for a way around this.

regards

|||

I eventually managed to find a way around it. Here are the changes which I made to my code:

1. Changed the connection steing to use native OLE DB as follows:

Provider=sqloledb;Data Source=AAA;Initial Catalog=BBB;User Id=CCC;Password=DDD

where AAA = SQL Server name

BBB = database name

CCC = login user name

DDD= password

2. I declare a list which holds pending SQL request.

3. hook up ADO connection object's Connectioncomplete and Disconnection events.

4. when execution of a SQL query failes, an exception is raisedcatch this exception. check the list of pending requests. if it is empty then add this failed request into the list and disconnect from the database. (this will force to disconnect from an invalid connection if there is any). Do not attempt to disconnect from the database if there is already a pending request in the list.

5. I have a separate thread which attempts to connect to the database. once I have got connection to the database, i suspend that thread.

6. in disconnection event handler, I check if there is an error while I tried to disconnect from the database. If there is NO error then I resume the thread which attempts to connect to the database.

7. in connection event handler, I check if there is an error while I tried to connect to the database. If there is NO error then I start a timer which checks pending request list and if there is any pending request, send it to the SQL server and then empty the list.

Regards,

Tahir Sultan

|||

Tahir thanks for the response.

We still have a problem because we can only use ODBC?

regards

Amanda

|||

Can catch the error and retry the connection be one of your option?

Otherwise, please post your code here and we can try to repro it.

HTH

|||

At the moment we are diconneting and then re-connecting, but even this is not solving the problem. We need to stop the application to get rid of the error. This is only the case for the communication link failure error with all other errors diconnecting and re-connecting works fine.

regards

|||

I had the same problem when I was using ODBC. Even disconnecting and reconnecting did not work at all. I tried all possible ODBC driver configuration but none of them seemed to make any difference. But moving to native OLE DB driver solved the problem.

Tahir Sultan

|||We have a situation common to laptops. I'm convinced that it is the result of some power management setting (hibernate, hard drive shutdown, or standby), but can never log it to pinpoint it exactly. Any suggestions?

Communication Link Failure Error

Hi,

I am using ADO in my application to connect and retrieve data from Microsoft SQL Server 2000 SP4. When I start my application, it establishes connection to the server successfully and I am able to retrieve data from the server. here is my test scenario:

1. unplug the network cable from the client machine and put the cable back in after some time. I disconnect from the database in my code when the client machine disconnects from the network

2. Once the client machine comes back on the network, I try to reconnect and retrieve data from the sql server but I get the following error message when I try to execute a sql command:

[Microsoft][ODBC SQL Server Driver]Communication Link failure

This problem occurs only with Window XP SP2. With XP SP1 it works fine. It seems to be problem on the client side as with Windows XP SP1 I do not get this error message at all.

Here are the various details:

1. The firewall is off on the client workstation.

2. the connection string is:

driver={SQL Server};server=AA;uid=BB;pwd=CC;database=DD

where AA = DNS name of server machine where sql server is running.

BB = user name

CC = password

DD= database name

3. The client is remote to the server.

4. I can ping the server machine when the client machine reconnects to the network.

5. I can still telnet the server when the client machine reconnects to the network.

6. client database provider is MDAC odbc.

7. the client and server machines are in the same domain.

8. Shared memory and TCPIP protocols are enabled and TCP is at the top of the list.

9. No alias is being used.

10. Viris scan is not installed.

11. force encriptioned is NOT checked.

Please reply.

It appears a connection pooling issue. The closed connections by the client app are returned to the pool and become invalid after you unplug the cable. Next time you try to connect, odbc reuse the invalid connectin and throw the error. Retry your connection or disable pooling should resolve your issue.|||

I am already doing this:

1. When the machine disconnects from the network, I close the database connection. when the machine reconnects to the network, I try to establish a new connection to the database.

2. The connection pooling is also disabled for SQL server odbc driver under Connection Pooling tab of ODBC Data Source Administrator.

Please reply.

|||

Good day,

Tahir posted this request in Oct this year, has there been any response yet?

We are experiencing exactely the same problem in completely different ODBC client and are desperately looking for a way around this.

regards

|||

I eventually managed to find a way around it. Here are the changes which I made to my code:

1. Changed the connection steing to use native OLE DB as follows:

Provider=sqloledb;Data Source=AAA;Initial Catalog=BBB;User Id=CCC;Password=DDD

where AAA = SQL Server name

BBB = database name

CCC = login user name

DDD= password

2. I declare a list which holds pending SQL request.

3. hook up ADO connection object's Connectioncomplete and Disconnection events.

4. when execution of a SQL query failes, an exception is raisedcatch this exception. check the list of pending requests. if it is empty then add this failed request into the list and disconnect from the database. (this will force to disconnect from an invalid connection if there is any). Do not attempt to disconnect from the database if there is already a pending request in the list.

5. I have a separate thread which attempts to connect to the database. once I have got connection to the database, i suspend that thread.

6. in disconnection event handler, I check if there is an error while I tried to disconnect from the database. If there is NO error then I resume the thread which attempts to connect to the database.

7. in connection event handler, I check if there is an error while I tried to connect to the database. If there is NO error then I start a timer which checks pending request list and if there is any pending request, send it to the SQL server and then empty the list.

Regards,

Tahir Sultan

|||

Tahir thanks for the response.

We still have a problem because we can only use ODBC?

regards

Amanda

|||

Can catch the error and retry the connection be one of your option?

Otherwise, please post your code here and we can try to repro it.

HTH

|||

At the moment we are diconneting and then re-connecting, but even this is not solving the problem. We need to stop the application to get rid of the error. This is only the case for the communication link failure error with all other errors diconnecting and re-connecting works fine.

regards

|||

I had the same problem when I was using ODBC. Even disconnecting and reconnecting did not work at all. I tried all possible ODBC driver configuration but none of them seemed to make any difference. But moving to native OLE DB driver solved the problem.

Tahir Sultan

|||We have a situation common to laptops. I'm convinced that it is the result of some power management setting (hibernate, hard drive shutdown, or standby), but can never log it to pinpoint it exactly. Any suggestions?

Communication Link Failure Error

Hi,

I am using ADO in my application to connect and retrieve data from Microsoft SQL Server 2000 SP4. When I start my application, it establishes connection to the server successfully and I am able to retrieve data from the server. here is my test scenario:

1. unplug the network cable from the client machine and put the cable back in after some time. I disconnect from the database in my code when the client machine disconnects from the network

2. Once the client machine comes back on the network, I try to reconnect and retrieve data from the sql server but I get the following error message when I try to execute a sql command:

[Microsoft][ODBC SQL Server Driver]Communication Link failure

This problem occurs only with Window XP SP2. With XP SP1 it works fine. It seems to be problem on the client side as with Windows XP SP1 I do not get this error message at all.

Here are the various details:

1. The firewall is off on the client workstation.

2. the connection string is:

driver={SQL Server};server=AA;uid=BB;pwd=CC;database=DD

where AA = DNS name of server machine where sql server is running.

BB = user name

CC = password

DD= database name

3. The client is remote to the server.

4. I can ping the server machine when the client machine reconnects to the network.

5. I can still telnet the server when the client machine reconnects to the network.

6. client database provider is MDAC odbc.

7. the client and server machines are in the same domain.

8. Shared memory and TCPIP protocols are enabled and TCP is at the top of the list.

9. No alias is being used.

10. Viris scan is not installed.

11. force encriptioned is NOT checked.

Please reply.

It appears a connection pooling issue. The closed connections by the client app are returned to the pool and become invalid after you unplug the cable. Next time you try to connect, odbc reuse the invalid connectin and throw the error. Retry your connection or disable pooling should resolve your issue.|||

I am already doing this:

1. When the machine disconnects from the network, I close the database connection. when the machine reconnects to the network, I try to establish a new connection to the database.

2. The connection pooling is also disabled for SQL server odbc driver under Connection Pooling tab of ODBC Data Source Administrator.

Please reply.

|||

Good day,

Tahir posted this request in Oct this year, has there been any response yet?

We are experiencing exactely the same problem in completely different ODBC client and are desperately looking for a way around this.

regards

|||

I eventually managed to find a way around it. Here are the changes which I made to my code:

1. Changed the connection steing to use native OLE DB as follows:

Provider=sqloledb;Data Source=AAA;Initial Catalog=BBB;User Id=CCC;Password=DDD

where AAA = SQL Server name

BBB = database name

CCC = login user name

DDD= password

2. I declare a list which holds pending SQL request.

3. hook up ADO connection object's Connectioncomplete and Disconnection events.

4. when execution of a SQL query failes, an exception is raisedcatch this exception. check the list of pending requests. if it is empty then add this failed request into the list and disconnect from the database. (this will force to disconnect from an invalid connection if there is any). Do not attempt to disconnect from the database if there is already a pending request in the list.

5. I have a separate thread which attempts to connect to the database. once I have got connection to the database, i suspend that thread.

6. in disconnection event handler, I check if there is an error while I tried to disconnect from the database. If there is NO error then I resume the thread which attempts to connect to the database.

7. in connection event handler, I check if there is an error while I tried to connect to the database. If there is NO error then I start a timer which checks pending request list and if there is any pending request, send it to the SQL server and then empty the list.

Regards,

Tahir Sultan

|||

Tahir thanks for the response.

We still have a problem because we can only use ODBC?

regards

Amanda

|||

Can catch the error and retry the connection be one of your option?

Otherwise, please post your code here and we can try to repro it.

HTH

|||

At the moment we are diconneting and then re-connecting, but even this is not solving the problem. We need to stop the application to get rid of the error. This is only the case for the communication link failure error with all other errors diconnecting and re-connecting works fine.

regards

|||

I had the same problem when I was using ODBC. Even disconnecting and reconnecting did not work at all. I tried all possible ODBC driver configuration but none of them seemed to make any difference. But moving to native OLE DB driver solved the problem.

Tahir Sultan

|||We have a situation common to laptops. I'm convinced that it is the result of some power management setting (hibernate, hard drive shutdown, or standby), but can never log it to pinpoint it exactly. Any suggestions?

Communication Link Failure error

Hi Y'all,

When i alter 1 single value in my sql server 2000 sometimes i get following error:

1) [MICROSOFT][ODBC SQL SERVER DRIVER] Communication link failure

After clicking away:

2)CANNOT START MORE TRANSACTION ON THIS SESSION

Maybe someone can help me out on this?

Thanks!

Hi,

First, make sure that your largest column is the last column retuned. Make sure that you do not have any columns returned after a text or an image column

Second, have you recently finished any kind of an upgrade that may have impacted the MDAC? The default connection protocol in MDAC 2.5 was Named Pipes. In 2.7, it changed the default to TCP/IP. You mentioned that you are connecting via TCP/IP, but can you verify that in EM?

Third, you may try the following article which may be helpful to you.http://support.microsoft.com/kb/316872

Hope this helps. Thanks.

Communication Link Failure C++ & SQL Server

Hi Guys,

I am using C++ (Ver 6) that connects to a SQL Server 7 DB using ODBC drivers. The apps connects to the database in the start and listens to the users requests and replies with the required data.

The apps is working fine, but once in a while it looses connection and gives "Communication link failure" message.

I just restart the apps and it is able to reconnect and perform as normal without any problems.

I am not able to find the reason as this behaviour as its very much unpredictable!

The error is returned by SQLExecDirect() function.

The question is, since I still have the Connection Handle, is it possible to just reconnect to the database re-using the same handle ? or do I have any other choices ?

Thanks in advance.
Faisal.This is the wrong forum to ask this question. Try one of the SQL forums.|||You might get this error when the server gets restarted. I look for error 0x80004005 and reconnect to the server, it has worked well.

I'll move this thread to the SQL forum for a better answer.
|||

Hi Brian,

I think my question was confusing. I actually meant, how to re-connect to the DB using the same Connection Handle ? I am new to C/C++

Thanks.|||

Thanks for the help. As I mentioned above, I am new to C/C++ and dont know how to reuse the same connection handle. So that I dont need to re instantiate all the other classes that are using a reference to that connection handle

Hope you can help me out here.