connection.exec

Does any body know if the connection.exec has a size limitation. I am sendin
g
30k of text through connection.exec and I get rusults but if I send 50k it
does not work. It's almost as if the connection.exec can't handle the extra
20k. Any help would be great I have a production app down.I figured it out, I was using the datashape and that is what was breaking it
.
I removed it and it works great.
"DAVID S" wrote:

> Does any body know if the connection.exec has a size limitation. I am send
ing
> 30k of text through connection.exec and I get rusults but if I send 50k it
> does not work. It's almost as if the connection.exec can't handle the extr
a
> 20k. Any help would be great I have a production app down.

connection with sql server through asp.net

hi every body,

i find problems in connection string to connect with sql server through asp.net. the error is unknown connection option in connection string.

the connection string i have used is:

dim cnn as sqlconnection = new sqlconnection()

sqlcnn.ConnectionString = "datasource=arun;initialcatalog = reporting system;"

here arun is server name;reporting system is database

anyone help me

I think it's "initial catalog" instead of "initialcatalog". Take a look at following link for various connection string related info.

http://www.connectionstrings.com/

|||

hi,

take u for ur help. now i got the solution