Re: Any help here???
- From: "PB" <A@xxxxx>
- Date: Tue, 24 May 2005 14:16:22 -0700
So, are you using the System.Data.SqlClient namespace and its SqlCommand and
SqlConnection objects?
"DavidS" <DavidS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:303843CA-26DF-45D7-9D70-D917CF421272@xxxxxxxxxxxxxxxx
> Connect String -------------
>
> Server=<server name>;database=<database
> name>;uid=<uid>;pwd=<password>;connect timeout=30;pooling=true
>
> Never problem -
>
> "PB" wrote:
>
>> Well, for starters, I believe MDAC is unnecessary for .NET applications -
>> as
>> ADO.NET has its own SQL Server provider for data access. The only reason
>> I
>> could think of off hand for installing MDAC is for any old COM
>> applications
>> that may need it.
>>
>> So, when you say you are connecting to SQL Server, are you doing so from
>> an
>> ASP.NET Web application? or from some COM-based application? If from
>> .NET -
>> then what does your connection string and connection object look like?
>> Are
>> you defining them in code? If so, lets have a look.
>>
>> Also, which version of Visual Studio .NET? 2003? As long as you are
>> setting
>> up a new development environment for new projects that were not based on
>> any
>> prior version of .NET, then you really should be using .NET Framework 1.1
>> (which installs with VS.NET 2003).
>>
>> I personally have worked extensively with many prior versions of MDAC -
>> and
>> honestly since switching to .NET development I've never had to deal with
>> MDAC (and good riddance!).
>>
>> Finally (for now), this news group is run by Microsoft, but most of the
>> people who are posting here are NOT Microsoft employees. We are mostly
>> people just like yourself figuring out how to make all this stuff work
>> and
>> helping each other out.
>>
>> -HTH
>>
>>
>>
>>
>>
>> "DavidS" <DavidS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:A6DCE8BC-FF8C-4B4D-8800-9A9F51D1AB0C@xxxxxxxxxxxxxxxx
>> >I almost was ready to look @ working with UNIX environment - but that's
>> > statement only out of frustration. First, THANK YOU for responding.
>> > Next,
>> > I'll answer all your questions too - and hopefully we can get solution
>> > here
>> > to fix this for our development environment.
>> >
>> > 1) SQL 200 Server is not local - it's on separate server all by itself.
>> > I
>> > have two laptops - both with Visual Studio.NET that I've installed.
>> > MDAC
>> > components 2.6 is what is on laptop I believe. I've never had
>> > connection
>> > issue to SQL databases here - very rare to get timeouts.
>> > 2) I've also installed Visual Studio.NET on 2000 server for development
>> > server - and not issue there. MDAC 2.6 I believe is installed there.
>> > I've
>> > installed IIS and just about everything here - and not issue. Never
>> > SQL
>> > timeouts.
>> > 3) MDAC 2.8 is installed on 2nd laptop with Windows XP SP2. I've also
>> > installed Visual Studio.NET here (I believe this is default with OS).
>> > Everything works great but SQL doesn't connect & popup issue - BUT for
>> > now
>> > lets ignore popup issue. Once in a blue-moon I can connect to SQL
>> > server -
>> > but 98% of time it times out or simply doesn't connect. I have 20
>> > second
>> > default for connection string (changed to 30, 60, etc... and doesn't
>> > help)
>> > as
>> > on Windows 2000 OS laptop. I agree there are many differences with
>> > both
>> > OS's
>> > - DLL's are one variation, MDAC is most obvious that I see @ this time.
>> > I've
>> > downloaded Microsoft Product Support Reporting Tools - to review what's
>> > here
>> > too - after researching on your knowledge base.
>> > 4) Currently, I'm going to formulate more information - but what's best
>> > way
>> > to give you what you need. My initial objective is NOT to conclude
>> > OS -
>> > but
>> > trust me - all that's been done here was to install SP2 or upgrade of
>> > XP
>> > from
>> > Microsoft. Next, I've completed the install of Visual Studio.NET like
>> > I've
>> > done for 3 other computers - without issue. Again - MDAC - I've
>> > research
>> > this myself - since it's relavent to SQL connect objects.
>> >
>> > What would you need from me first - to check/review
>> > similarities/dissimilarities.
>> >
>> > Thank you kindly.
>> >
>> > "PB" wrote:
>> >
>> >> <<Basically the new XP SP2 has issues >>
>> >>
>> >> Maybe so, but not necessarily relevant to your errors. I migrated from
>> >> 2k
>> >> to
>> >> XP SP2 with no issues at all - and did so on multiple development
>> >> machines
>> >> (laptop, desktop). Many other developers in this group report using XP
>> >> SP2
>> >> with NO problems.
>> >>
>> >> As long as you are concluding that XP SP2 is "the problem" then it may
>> >> take
>> >> you more time to figure out what is really causing "the problem".
>> >> There
>> >> are
>> >> potentially many many differences between your 2k machine and your XP
>> >> machine - the OS is just one of those many differences.
>> >>
>> >> Maybe we could help you more if you were to describe specifically what
>> >> your
>> >> setup is. Do you have SQL Server 2000 installed on the local machine?
>> >> When
>> >> you say you can test with other laptop - 2K version - are you saying
>> >> that
>> >> that machine is connecting to the XP machine and choking? If os, then
>> >> XP'
>> >> firewall may need to be opened up a bit. No one can reasonably
>> >> suggest
>> >> you
>> >> look at the firewall NOR ANY other potential configuration issues
>> >> without
>> >> knowing more about your specific setup. If it all works on your 2K
>> >> machine
>> >> (everything is installed locally) but not on the XP machine (with
>> >> everthing
>> >> installed locally), then its time to look at similarities and
>> >> differences
>> >> between specific configuration settings - and not just conclude that
>> >> the
>> >> OS - which is the most unlikely culprit here - is "the" problem.
>> >>
>> >> Help us help you - and we will.
>> >>
>> >>
>> >>
>> >> "DavidS" <DavidS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:00CBD93C-A057-4F4E-A3BC-F3598D6AF9AC@xxxxxxxxxxxxxxxx
>> >> > SQL server is running. I can test with my other laptop - 2K
>> >> > version.
>> >> > All
>> >> > is
>> >> > well there. It does appear to be latest OS - I've also reviewed
>> >> > other
>> >> > posts
>> >> > by others users - but noone has answered questions.
>> >> >
>> >> > Futher, everything fine on SQL - running for every app - again,
>> >> > including
>> >> > other 2K OS laptop - and in development mode there with no problem.
>> >> > Basically the new XP SP2 has issues - but I'm not sure where to fix.
>> >> >
>> >> > "TJS" wrote:
>> >> >
>> >> >> seems like the sql server is not responding,. doesn't seem like it
>> >> >> has
>> >> >> anything to do with the OS.
>> >> >>
>> >> >> Check to make sure SQL server is running and name of the server is
>> >> >> same
>> >> >> as
>> >> >> in connection code
>> >> >>
>> >> >>
>> >> >> "DavidS" <DavidS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> >> news:A16D9908-6EED-49A3-89BB-E0335A4C5378@xxxxxxxxxxxxxxxx
>> >> >> > Have Visual Studio.NET installed on MS 2000 Professional OS
>> >> >> > laptop.
>> >> >> > No
>> >> >> > issue
>> >> >> > ever with web development and SQL connections.
>> >> >> > Purchased new laptop with XP Professional SP2!!!!!!!! & Visual
>> >> >> > Studio.NET
>> >> >> > installed.
>> >> >> > Nothing but headaches. Continually getting
>> >> >> > System.Data.SqlClient.SqlException : Timeout expired message -
>> >> >> > The
>> >> >> > timeout
>> >> >> > period elapsed prior to completion of the operation or the server
>> >> >> > is
>> >> >> > not
>> >> >> > responding.
>> >> >> > Can anyone help with this??? Why error's with LATER versions of
>> >> >> > your
>> >> >> > software?
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>
.
- Follow-Ups:
- Re: Any help here???
- From: DavidS
- Re: Any help here???
- References:
- Any help here???
- From: DavidS
- Re: Any help here???
- From: TJS
- Re: Any help here???
- From: DavidS
- Re: Any help here???
- From: PB
- Re: Any help here???
- From: DavidS
- Re: Any help here???
- From: PB
- Re: Any help here???
- From: DavidS
- Any help here???
- Prev by Date: TextBox control doesn't show value
- Next by Date: RE: Code Behind Page
- Previous by thread: Re: Any help here???
- Next by thread: Re: Any help here???
- Index(es):
Relevant Pages
|
