General network error

What are some of the reasons why one could get a "General Network error "
from the app especially if the n/w between the app and SQL appears to be
fine.
Thanks
Hello, Hassan
See:
http://support.microsoft.com/kb/827422/
http://support.microsoft.com/kb/812817/
Razvan

General network error

What are some of the reasons why one could get a "General Network error "
from the app especially if the n/w between the app and SQL appears to be
fine.
ThanksHello, Hassan
See:
http://support.microsoft.com/kb/827422/
http://support.microsoft.com/kb/812817/
Razvan

General network error

What are some of the reasons why one could get a "General Network error "
from the app especially if the n/w between the app and SQL appears to be
fine.
ThanksHello, Hassan
See:
http://support.microsoft.com/kb/827422/
http://support.microsoft.com/kb/812817/
Razvan

General Advice - Timesheet application

So I have been tasked with converting a pilot timesheet application (written in Access) into an all singing all dancing web app. I'm planning on using SQL Server to provide some scale but wondered if anyone had any advice about processing time calcs.

I can of course use the smalldatetime datatype to store all the start at, finish at and elapsed hours times but wonderd if there was any comparative advantage to using numerics instead and converting to/from HH:MM representation.

Maybe I need to finally figure out how to create and use custom data types?

There's lots of math to do on these things once the data is captured for reporting and such and smalldattime looks like a fairly big waste of space for something that really only deals in hours.

Anyone doen things like this before? Any advice on what not to do?

many thanks

Steve1) Use datetime
2) If necessary, denormalize your datetime field converting them in several int fields. This method sometimes is used in DW environment (with a dimension time)

GAC issues with my C# app

not sure if this is an SQL issue or a development issue, but as im using c# and visual studio so il place this here for now.

I wrote a small app to script out jobs from sql server. it worked fine, and then , without any changes it stopped working. I got the error:

Could not load type

'Microsoft.SqlServer.Managment.Smo.AgentJobBaseCollection' from assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, publicKeyToken=89845dcd8080cc91'.

I checked the version of the Microosft.SqlServer.Managment.Smo Dll installed in sql server installation dir, and its version 9.00.1399.00, so i try to update the gac . The version in the gac is 9.0.242.0. I cannot delete it via the gac MMC plugin as it tells me it is required by another app. I cannot delete it via GacUtil for the same reason. I went to the windows directory to the assemblies folder and tried deleteing it there, but also could not as it is required by another application.

How do i delete the old version from the gac and install the new version?

I was going to try editing the registry, but when i searched for that specific assembly "Microsoft.Sqlserver.Managment.Smo, i find thousands of entries, and i am not editing each one. that would take me days.

Any help would be greatly appriciated.

Probably this might help you PRB: "Could not load type"

|||

afraid not. this is a windows app. nothing to do with asp.