Errors trying to retrieve large excerpts

hi again,
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
[Microsoft][ODBC SQL Server Driver]TDS buffer length too large
Cheers,This is a great error message, but can you provide more information? What
is the table structure? What is the code that causes the error? Where does
it live (Query Analyzer, an application, ...)?
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Enric" <Enric@.discussions.microsoft.com> wrote in message
news:15162A38-1922-4500-9197-118A544857D1@.microsoft.com...
> hi again,
>
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
> [Microsoft][ODBC SQL Server Driver]TDS buffer length too large
> [Microsoft][ODBC SQL Server Driver]TDS buffer length too large
> [Microsoft][ODBC SQL Server Driver]TDS buffer length too large
> [Microsoft][ODBC SQL Server Driver]TDS buffer length too large
> Cheers,|||See if this helps:
http://support.microsoft.com/default.aspx/kb/176256
Anith

Error:Type Expected

I did create one simple program which is used to retrieve data from SQL Server Database into the DataGrid. Unfortunately,compilation stops at the position that 'Dim conn as SQLConnection'.The error is just same as the subject 'Type Expected'.

By the way, the default frameworkSDK from VS.NET version 1.0 lies different place from .NET1.1 I did install recently.If so, I wonder which FrameworkSDK will be used if I'm intending to compile ASP.NET Web Application.

Looking forward to your timely kind reply!At the top of your page with the code, are you importing the System.Data namespace?

Imports System.Data

Josh

Error: unable to retrieve column information from the data source

Hi,

I am trying to set up a data flow task. The source is "SQL Command" which is
a stored procedure. The proc has a few temp tables that it outputs the final
resultset from. When I hit preview in the ole db source editor, I see the
right output. When I select the "Columns" tab on the right, the "Available
External Column List" is empty. Why don't the column names appear? What is
the work around to get the column mappings to work b/w source and
destination in this scenario.

In DTS previously, you could "fool" the package by first compiling the
stored procedure with hardcoded column names and dummy values, creating and
saving the package and finally changing the procedure back to the actual
output. As long as the columns remained the same, all would work.
Thats not working for me in SSIS.

Thanks in advance.
Asim.

Anyone?

|||I am having the same problem. I assume it is because the stored procedure I am using is long running (1min 20s) The designer looks like it starts to run the sproc to get the metadata, but then gives up after 15 or 30 seconds. Any solutions?|||

Hi,

If your final select statement is for a temporary table, u will get this problem. Use table variable or actual table instead of temp table.

|||

Yes, I figured out a solution. Basically create a hard coded resultset (select stmt) at the top of the procedure with the same columns as the actual resultset.

That did it for me.

Asim.

|||

Ok, that solution does not work. By adding the header, the package compiles and runs, but the row from the header is inserted in the destination, not from the (actual) second resultset. So I am back to square one.

Can anyone please help.

Asim.

|||This solved my problem. However, it was not enough to change the last select from a temp table to table variable. I had to change all occurences of temp tables to table variables. I also found that it sped up my query by a factor of 16x from 1min 20s to 5s.|||My workaround is to create output columns that are being returned by the query manually.

Error: Unable to load one or more of the requested types.

When I'm trying to deploy a SQLCLR assembly , I get the following error:

Error: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

This is an error you get were you cannot get the assembly types during reflection.

I was able to deploy it previously, and I'm not aware of any change I made that could make it refer to a different external type.

It has a reference to another SQLCLR assembly that was successfully deployed. If I remove all the references in in the code to classes in that assembly, it works OK, so it looks that it cannot load this other assembly when trying to deploy the first one.

Is there any way to troubleshoot this? Getting that 'LoaderExceptions property' could be useful..

Any other hint?

Thanks

Are you using reflection against types that are in assemblies that are also registered in the database? or these are assemblies that are were not registered using CREATE ASSEMBLY? if it's the later, that's by design, you cannot load assemblies that were not registered with SQL Server.

Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

|||Thanks Pablo.

I run into this issue again today, and it looks like a VS.NET thing.

I create two projects, one with an enumeration:

public enum MyEnum
{
MyValue,
MyValue2
}

and another project with a reference to the first one, that declares a variable of that enumeration type

MyEnum myEnum;

Then when I try to deploy the second project, I get

Error: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

But, I execute the CREATE ASSEMBLY commands, then it works OK. The weird thing is that in my real world case, I could deploy the assemblies without any problem and now I cannot.

So, it looks like a VS.NET issue. I'm not sure which is the right forum to post it ;)

|||Please make sure that the top level assembly was compiled against the version of the referenced assembly that is in the assembly.

- Balaji Rathakrishnan|||It looks that it was caused by a versioning issue. Even if I tried that before, it looks that setting a '1.0.0.0' version fixed the problem.

Thanks a lot.

Andres|||

Sir,

i am also facing the same problem.

first i refered the assembly from local. at that time it is working properly.

but now i moved assemblies to GAC ,now it shows the above mentioned error.

i seen the abve answers.

can u tell me how to run the CREATE ASSEMBLY commend.

thanks

Error: Unable to load one or more of the requested types.

When I'm trying to deploy a SQLCLR assembly , I get the following error:

Error: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

This is an error you get were you cannot get the assembly types during reflection.

I was able to deploy it previously, and I'm not aware of any change I made that could make it refer to a different external type.

It has a reference to another SQLCLR assembly that was successfully deployed. If I remove all the references in in the code to classes in that assembly, it works OK, so it looks that it cannot load this other assembly when trying to deploy the first one.

Is there any way to troubleshoot this? Getting that 'LoaderExceptions property' could be useful..

Any other hint?

Thanks

Are you using reflection against types that are in assemblies that are also registered in the database? or these are assemblies that are were not registered using CREATE ASSEMBLY? if it's the later, that's by design, you cannot load assemblies that were not registered with SQL Server.

Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.

|||Thanks Pablo.

I run into this issue again today, and it looks like a VS.NET thing.

I create two projects, one with an enumeration:

public enum MyEnum
{
MyValue,
MyValue2
}

and another project with a reference to the first one, that declares a variable of that enumeration type

MyEnum myEnum;

Then when I try to deploy the second project, I get

Error: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.

But, I execute the CREATE ASSEMBLY commands, then it works OK. The weird thing is that in my real world case, I could deploy the assemblies without any problem and now I cannot.

So, it looks like a VS.NET issue. I'm not sure which is the right forum to post it ;)

|||Please make sure that the top level assembly was compiled against the version of the referenced assembly that is in the assembly.

- Balaji Rathakrishnan|||It looks that it was caused by a versioning issue. Even if I tried that before, it looks that setting a '1.0.0.0' version fixed the problem.

Thanks a lot.

Andres|||

Sir,

i am also facing the same problem.

first i refered the assembly from local. at that time it is working properly.

but now i moved assemblies to GAC ,now it shows the above mentioned error.

i seen the abve answers.

can u tell me how to run the CREATE ASSEMBLY commend.

thanks