[Venting]

So I have this box with SQL Server 2000, Evaluation edition of SQL 2005
which has top be installed as a named instance because of the way that 2K &
2K5 co-exist on the same box, and then there are a couple silly apps I have
that install MSDE as other named instances.
and the STUPI .NET DATA CONNECTION DIALOG doesn't have a field geared toward
named instances.
@.#$%^&
I will now crawl back under my rock.
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSenseiCan you edit the connection string in web.config or the source code?
"Mike Labosh" <mlabosh_at_vbsensei_dot_com> wrote in message
news:uwZSfc5PGHA.4900@.TK2MSFTNGP09.phx.gbl...
> So I have this box with SQL Server 2000, Evaluation edition of SQL 2005
> which has top be installed as a named instance because of the way that 2K
> &
> 2K5 co-exist on the same box, and then there are a couple silly apps I
> have
> that install MSDE as other named instances.
> and the STUPI .NET DATA CONNECTION DIALOG doesn't have a field geared
> toward
> named instances.
> @.#$%^&
> I will now crawl back under my rock.
>
> --
> Peace & happy computing,
> Mike Labosh, MCSD MCT
> Owner, vbSensei.Com
> "Escriba coda ergo sum." -- vbSensei
>|||> Can you edit the connection string in web.config or the source code?
2K
Of course I can. It just angers me that the silly little foolish dialog
doesn't let me say so.
Peace & happy computing,
Mike Labosh, MCSD MCT
Owner, vbSensei.Com
"Escriba coda ergo sum." -- vbSensei

[Microsoft][ODBC SQL Server Driver] Timeout Expired

Hello,
I installed MS SQL Server 2000 Evaluation Edition on
Windows XP Pro PC. I have database on the same PC. When I
am running a query(view) from Query Analyser I
get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
error message . When I am running the same view on
smaller amount of data it works.
Could you please help me with that?
Thanks
DJ
hi
goto the server properties.then there is a property called connection time.
check it and give the appropiate time on this

[Microsoft][ODBC SQL Server Driver] Timeout Expired

Hello,
I installed MS SQL Server 2000 Evaluation Edition on
Windows XP Pro. I have database on the same PC. When I
am running a query(view) from Query Analyser I
get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
error message . When I am running the same view on
smaller amount of data it works.

:confused:

Could you please help me with that?
Thanks
DJCheck out this page.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;313661|||The link in the previous post is for a connection timeout using SQL Server 7. It does not apply to running a query on SQL Server 2000.|||SQL Server 2000's default timeout period it 600 seconds (10 minutes). If you change it to zero (0), that's infinite. How long is it taking to timeout?

If you run a long query through the Enterprise Manager, it will timeout after 30 seconds. MS's answer to this is to use the Query Analyzer (which should not timeout). I've run a 14-hour query through SQL Query Analyzer before.

[Microsoft][ODBC SQL Server Driver] Timeout Expired

Hello,
I installed MS SQL Server 2000 Evaluation Edition on
Windows XP Pro PC. I have database on the same PC. When I
am running a query(view) from Query Analyser I
get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
error message . When I am running the same view on
smaller amount of data it works.
Could you please help me with that?
Thanks
DJhi
goto the server properties.then there is a property called connection time
.
check it and give the appropiate time on this