I get "Timeout expired"

Hi, everyone! As many of guys around this newsgroup, I've been getting
"Timeout expired" using SQL Server 2000.
It raises that error message out of nowhere... first, I tought it was
because of too many users connected, but made some test with just ONE SINGLE
user connected to DataBase, and I'm still getting this message.
It acts randomly, as I can be working perfectly now and the next second, I
get the anoying message again.
I've even tried to remake the table's index, but it doesn't seem to work...
I'm not even able to erase the primary index in the first place...
I have 52 tables in my database, and the other 51 work just fine, it's just
one which is getting me into trouble...
I'm desperate, can you help me, please?!? (picture a face of agony while
reading the latter LOL ;-) )
best regards,
Alex
AlexTirado wrote:
> Hi, everyone! As many of guys around this newsgroup, I've been getting
> "Timeout expired" using SQL Server 2000.
> It raises that error message out of nowhere... first, I tought it was
> because of too many users connected, but made some test with just ONE
> SINGLE user connected to DataBase, and I'm still getting this message.
> It acts randomly, as I can be working perfectly now and the next
> second, I get the anoying message again.
> I've even tried to remake the table's index, but it doesn't seem to
> work... I'm not even able to erase the primary index in the first
> place...
> I have 52 tables in my database, and the other 51 work just fine,
> it's just one which is getting me into trouble...
> I'm desperate, can you help me, please?!? (picture a face of agony
> while reading the latter LOL ;-) )
> best regards,
> Alex
What do you have your timeout value set to in your code? This is either
a lock:timeout or a query timeout. Both can be captured in Profiler
using the Lock:Timeout and Attention events. What statement is running
just prior to the problem. Use the SQL:StmtStarting and RPC:Starting
events as well as SP:StmtStarting if this is occurring inside a stored
procedure.
David Gugick
Imceda Software
www.imceda.com
sql

I can't open my dtsx

Hi everyone,

After a while I'm come back to SSIS but a drawback appears.

I’ve copied from our server a folder which contains a few dtsx on my local folder and when I’m going to open dtproj and then choose any of them:

Error1Error loading 'M_Hac_Modelo187.dtsx' : Error al recuperar un generador de clases COM para el componente con CLSID {E80FE1DB-D1AA-4D6B-BA7E-040D424A925C} debido al siguiente error: 8000401a..c:\ssis\hacienda_anual\M_Hac_Modelo187.dtsx11

..

..

..

(I think that is not necessary to translate into english due to simpleness of the message.)

What the hell is happening? I perfectly remember have been doing the same a month ago and I was able to open them without problems.

TIA

It's strange. How odd.

Now, I can't be able to create any SSIS project from my BIDS. SSAS no problem at all.

In the last month I've installed Visual Studio Professional Edition 2005 and Enterprise Library January Edition 2006 for Framework in my own workstation.

What happened?

I don't want that workaround for it have to be install again SSIS component from my installation CD.

Let me know any comment or link related.

Thanks again,

|||

Hi again,

Does anyone ever faced any problem like that?

Following actions has been commited:

-Desinstalling assemblies related (Microsoft.SqlServer namespace) and installing them again - UNSUCCESSFUL

-Reinstall SSIS component - UNSUCCESSFUL

-Repair Visual Studio 2005 Professional Edition installation - UNSUCCESSFUL

-A full desinstallation of Visual Studio 2005 Professional Edition - UNSUCCESSFUL

-A full installation of Visual Studio 2005 - UNSUCCESSFUL

-A full desinstallation of Sql Server 2005 Developer Edition - UNSUCCESSFUL

I've searched that CLSID in my registry and it belong to C:\Archivos de programa\Microsoft SQL Server\90\DTS\Binn\DTS.dll

So that, Package Neutral and Package Neutral Classes involved...

CLSID: E80FE1DB-D1AA-4D6B-BA7E-040D424A925C
TypeLib: {D1D9A51E-B4FE-420B-97B1-28A383EF9168}

So that, I've unregistered that COM component by means regsvr32 and registered again...

Unsuccessful.

I'm stuck with that. I don't get the point at all.

Any idea?

i can't connect with the MSDE instance from another computer

I've installed a MSDE in one computer and i can access the
data without problems from the same computer , but if i
try to connect to the MSDE from another computer in the
same network , the instance doesn't appear. I tried from
almost 3 computers but i can't connect.
What i'm doing wrong?
Jorge,
If you installed the latest version the network protocols are probably
disabled (the default setting). Use svrnetcn.exe in the Binn folder under
your sql server directory to enable TCP/IP and things should work again. If
the machine with MSDE has a firewall make sure that the appropriate ports
can pass through the firewall (normally 1433). Use Properties on the
enabled TCP protocol to see the port used.
Ron Allen
"Jorge Lozano" <j.lozano@.initron20.com> wrote in message
news:07f001c49a51$94f2b8e0$a601280a@.phx.gbl...
> I've installed a MSDE in one computer and i can access the
> data without problems from the same computer , but if i
> try to connect to the MSDE from another computer in the
> same network , the instance doesn't appear. I tried from
> almost 3 computers but i can't connect.
> What i'm doing wrong?