Re: Any help here???

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?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Any help here???
    ... I think MDAC Applies in this instance. ... > ADO.NET has its own SQL Server provider for data access. ... > could think of off hand for installing MDAC is for any old COM applications ... > then what does your connection string and connection object look like? ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Error Message When Setup MS SQL Server Developer Edition
    ... I my case it was caused by a problem with MDAC. ... Try downloading and installing the latest ... as you no doubt know running Windows XP without any service pack is not ... My Experience is that the SQL Server developer edition ...
    (microsoft.public.sqlserver.setup)
  • Re: update query ODBC--call failed
    ... I have done a search for the latest version of MDAC, which appears to be 2.8 back from 2003. ... Ultimately I want to post this small application on my server, as a runtime to do some import and updates on some tables on the local server SQL database. ... I am a little unclear about why the "ODBC Driver Manager" is reporting the error rather than the "ODbc Driver For SQL Server". ...
    (microsoft.public.access.queries)
  • RE: connect to remote sql server in business Intelligence Developm
    ... I installed visual studio 2005 and sql ... our sql server 2000 to sql server 2005 and I noticed I need BI development ... MSSQL$SQLEXPRESS and it seems installing sql server standard edition doesn't ...
    (microsoft.public.vsnet.general)
Loading