Unable to serialize the session state when session mode is SqlServer - ASP.NET Discussion Boards

Dinesh Mani1-Dec-09 1:11

1-Dec-09 1:11

Try to manually register the server on the Server Explorer to connect to the database to test the connectivity. You have a wizard there to help you and at the end of it you can get the connection string from the registered server's properties.

BTW, are you sure if Windows authentication is enabled on the database?

Re: connection string problem

m@dhu1-Dec-09 1:36

m@dhu

1-Dec-09 1:36

Dinesh Mani wrote:
Try to manually register the server on the Server Explorer

i did it and connection is successful there...
but still same error....

Dinesh Mani wrote:
are you sure if Windows authentication is enabled

windows authentication is enabled..

Re: connection string problem

Dinesh Mani1-Dec-09 1:51

Dinesh Mani

1-Dec-09 1:51

Did you check the resultant connection string from the Server registration? You can get it by accessing the properties of the server. Try using that from your code.

If possible try to generate a dataset/datatable using the Visual Studio wizards and check if you are able to connect and fetch data from the code.

Re: connection string problem

The Man from U.N.C.L.E.1-Dec-09 2:08

The Man from U.N.C.L.E.

1-Dec-09 2:08

So, is 'NT AUTHORITY\NETWORK SERVICE' listed in SQL Management Studio as one of the users with access to the database? I guess not.

If you have knowledge, let others light their candles at it.
Margaret Fuller (1810 - 1850)
[My Articles] [My Website]

Re: connection string problem

souidi abderrahman1-Dec-09 5:37

souidi abderrahman

1-Dec-09 5:37

try to get the connexion string from the database properties and test it then put it in your code Sleepy | :zzz:

Re: connection string problem

S. Brozius1-Dec-09 2:11

S. Brozius

1-Dec-09 2:11

What user do you use to check with Server Explorer if the connectionstring is valid?
Looks like an authorization-issue to me...
If it is a service, try running it under another account.

Nah... What's up, Doc?
CCC's solved : 1

Re: connection string problem

Vimalsoft(Pty) Ltd1-Dec-09 3:45

Vimalsoft(Pty) Ltd

1-Dec-09 3:45

Good Day

i can Help. First your Connection is not Correct it has to be done this way

SqlConnection cnn=new SqlConnection("Initial Catalog=new;Data Source=NETZOOM;Initial Catalog=NETZOOM User ID=sa;Password=mypassword");

now here is the Problem you might not have a sa password. I see above you want to use WindowsAuthontication. Create a SQL Account and use it for your Application.

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Unable to serialize the session state when session mode is SqlServer

Kuricheti1-Dec-09 0:20

Kuricheti

1-Dec-09 0:20

Hi,

I have two web applications with session state mode = SQLServer.

Both application are hosted in windows Server with different virtual names.

Now I have added the link of application2 in application1 Viceversa added application1 link in application2 to come back.

both applications are working fine..after some time when I click on link of application2 from application1 it is immediately displaying server error saying that

" Unable to serialize the session state. In 'State Server' and 'SqlServer' mode, ASP.NET Will serialize the session state objects, and as a result non-serialize objects or MarshalByRef objects are not permitted. The same restriction applies if similar serialization is done by the custom session state store in 'Custom' mode."

Application2 is having some sessions which holds some class objects, all classes are serialized classes,
and also some sessions holds datatables and hash tables directly will it be any problem, if so what is the solution for this.

As the site is in Live, It is very urgent to fix this issue.

Please help me to overcome from this problem.

Thanks
Haribabu K

Re: Unable to serialize the session state when session mode is SqlServer

Abhishek Sur1-Dec-09 0:40

Abhishek Sur

1-Dec-09 0:40

Did you put any object that is not serializable into session ?

Confused | :confused:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Unable to serialize the session state when session mode is SqlServer

Kuricheti1-Dec-09 22:29

Kuricheti

1-Dec-09 22:29

Hi Abhishek,

Thanks for the reply,

I am placing some class objects and List<objclass> objects in sessions, but all classes are serialized.

And also we are placing some dataset objects, DataTable objects and HashTable objects and ArrayList objects into sessions. will it be causing any problem.. if so what could be the solution..? else where is the problem.

Thanks
Haribabu K

Re: Unable to serialize the session state when session mode is SqlServer

Abhishek Sur2-Dec-09 20:28

Abhishek Sur

2-Dec-09 20:28

To have a good code, please dont put any complex objects in Session.
Dont put DataSets, DataTables, List etc in session. I dont know why do you require this?

If you see what a dataset serializes to, you will find there are lots of unnecessary properties and objects which it serializes. That means you will very easily eat up all the server memory within seconds.

It is always recommended to put premitive types, structures in Session. If you are creating a Serializable type, always use NotSerialisable attribute for unnecessary public members.

Why dont you put the id in session. It is a good technique to call database when needed for WEB environment rather than putting huge data into session.

The only possibility to have corrupted session object is because of issues on Serialization. Check each object you put in session. There must be something.

Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Unable to serialize the session state when session mode is SqlServer

Abhishek Sur2-Dec-09 20:29

Abhishek Sur

2-Dec-09 20:29

Oh.. sorry... You re using Database as session... then it is ok. Just check if it is deserialised properly or not. Cool | :cool:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Unable to serialize the session state when session mode is SqlServer

Abhijit Jana1-Dec-09 0:54

Abhijit Jana

1-Dec-09 0:54

Please have a look :
Exploring Session in ASP.Net[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

how we generate Tally XML file

lrsalunkhe30-Nov-09 21:37

lrsalunkhe

30-Nov-09 21:37

Respected,

How we generate Tally XML file using c#.net.
My Generate File Like:
- <ENVELOPE>
- <HEADER>
<TALLYREQUEST>Import Data</TALLYREQUEST>
</HEADER>
- <BODY>
- <IMPORTDATA>
- <REQUESTDESC>
<REPORTNAME>Vouchers</REPORTNAME>
- <STATICVARIABLES>
<SVCURRENTCOMPANY>Crystal Softwares.</SVCURRENTCOMPANY>
</STATICVARIABLES>
</REQUESTDESC>
- <REQUESTDATA>
- <TALLYMESSAGE xmlns:UDF="TallyUDF">
- <VOUCHER REMOTEID="6178b2bd-1d64-4c89-9c2a-20080725-Receipt-MAX LOGISTICS PVT. LTD./002131-20080725" VCHTYPE="RECEIPT" ACTION="Create">
<ISOPTIONAL>No</ISOPTIONAL>
<USEFORGAINLOSS>No</USEFORGAINLOSS>
<USEFORCOMPOUND>No</USEFORCOMPOUND>
<VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>
<DATE>20080725</DATE>
<EFFECTIVEDATE>20080725</EFFECTIVEDATE>
<ISCANCELLED>No</ISCANCELLED>
<USETRACKINGNUMBER>No</USETRACKINGNUMBER>
<ISPOSTDATED>No</ISPOSTDATED>
<ISINVOICE>No</ISINVOICE>
<DIFFACTUALQTY>No</DIFFACTUALQTY>
<VOUCHERNUMBER>002131-20080725</VOUCHERNUMBER>
<PARTYLEDGERNAME>MAX LOGISTICS PVT. LTD.</PARTYLEDGERNAME>
<NARRATION>Ch. No.:002131 Ch. Date:7/25/2008</NARRATION>
<ASPAYSLIP>No</ASPAYSLIP>
<GUID>6178b2bd-1d64-4c89-9c2a-20080725-Receipt-MAX LOGISTICS PVT. LTD./002131-20080725</GUID>
- <ALLLEDGERENTRIES.LIST>
<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<LEDGERFROMITEM>No</LEDGERFROMITEM>
<LEDGERNAME>MAX LOGISTICS PVT. LTD.</LEDGERNAME>
<AMOUNT>72091</AMOUNT>
- <BILLALLOCATIONS.LIST>
<NAME>E/1025/P</NAME>
<BILLTYPE>Agst Ref</BILLTYPE>
<AMOUNT>11193</AMOUNT>
</BILLALLOCATIONS.LIST>
- <BILLALLOCATIONS.LIST>
<NAME>E/1023/P</NAME>
<BILLTYPE>Agst Ref</BILLTYPE>
<AMOUNT>10393</AMOUNT>
</BILLALLOCATIONS.LIST>
- <BILLALLOCATIONS.LIST>
<NAME>E/1022/P</NAME>
<BILLTYPE>Agst Ref</BILLTYPE>
<AMOUNT>12472</AMOUNT>
</BILLALLOCATIONS.LIST>
- <BILLALLOCATIONS.LIST>
<NAME>E/1021/P</NAME>
<BILLTYPE>Agst Ref</BILLTYPE>
<AMOUNT>6067</AMOUNT>
</BILLALLOCATIONS.LIST>
- <BILLALLOCATIONS.LIST>
<NAME>E/1020/P</NAME>
<BILLTYPE>Agst Ref</BILLTYPE>
<AMOUNT>10393</AMOUNT>
</BILLALLOCATIONS.LIST>
- <BILLALLOCATIONS.LIST>
<NAME>E/1019/P</NAME>
<BILLTYPE>Agst Ref</BILLTYPE>
<AMOUNT>7079</AMOUNT>
</BILLALLOCATIONS.LIST>
- <BILLALLOCATIONS.LIST>
<NAME>E/1018/P</NAME>
<BILLTYPE>Agst Ref</BILLTYPE>
<AMOUNT>14494</AMOUNT>
</BILLALLOCATIONS.LIST>
</ALLLEDGERENTRIES.LIST>
- <ALLLEDGERENTRIES.LIST>
<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
<LEDGERFROMITEM>No</LEDGERFROMITEM>
<LEDGERNAME>ICICI BANK</LEDGERNAME>
<AMOUNT>-72091</AMOUNT>
</ALLLEDGERENTRIES.LIST>
</VOUCHER>
</TALLYMESSAGE>
- <TALLYMESSAGE xmlns:UDF="TallyUDF">
- <VOUCHER REMOTEID="6178b2bd-1d64-4c89-9c2a-20080725-Receipt-PINKCITY LOGISTICS LTD/544405-20080725" VCHTYPE="RECEIPT" ACTION="Create">
<ISOPTIONAL>No</ISOPTIONAL>
<USEFORGAINLOSS>No</USEFORGAINLOSS>
<USEFORCOMPOUND>No</USEFORCOMPOUND>
<VOUCHERTYPENAME>Receipt</VOUCHERTYPENAME>
<DATE>20080725</DATE>
<EFFECTIVEDATE>20080725</EFFECTIVEDATE>
<ISCANCELLED>No</ISCANCELLED>
<USETRACKINGNUMBER>No</USETRACKINGNUMBER>
<ISPOSTDATED>No</ISPOSTDATED>
<ISINVOICE>No</ISINVOICE>
<DIFFACTUALQTY>No</DIFFACTUALQTY>
<VOUCHERNUMBER>544405-20080725</VOUCHERNUMBER>
<PARTYLEDGERNAME>PINKCITY LOGISTICS LTD</PARTYLEDGERNAME>
<NARRATION>Ch. No.:544405 Ch. Date:7/25/2008</NARRATION>
<ASPAYSLIP>No</ASPAYSLIP>
<GUID>6178b2bd-1d64-4c89-9c2a-20080725-Receipt-PINKCITY LOGISTICS LTD/544405-20080725</GUID>
- <ALLLEDGERENTRIES.LIST>
<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<LEDGERFROMITEM>No</LEDGERFROMITEM>
<LEDGERNAME>PINKCITY LOGISTICS LTD</LEDGERNAME>
<AMOUNT>12121</AMOUNT>
</ALLLEDGERENTRIES.LIST>
- <ALLLEDGERENTRIES.LIST>
<REMOVEZEROENTRIES>No</REMOVEZEROENTRIES>
<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
<LEDGERFROMITEM>No</LEDGERFROMITEM>
<LEDGERNAME>ICICI BANK</LEDGERNAME>
<AMOUNT>-12121</AMOUNT>
</ALLLEDGERENTRIES.LIST>
</VOUCHER>
</TALLYMESSAGE>
</REQUESTDATA>
</IMPORTDATA>
</BODY>
</ENVELOPE>

Thanks Help me.

Re: how we generate Tally XML file

Abhijit Jana30-Nov-09 21:50

Abhijit Jana

30-Nov-09 21:50

First of all , you do not need to put whole XML to find out the answer.
Secondly you are asking the same question from a quite long time and asked many time and many people have given you the answer.
Your Questions[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: how we generate Tally XML file

lrsalunkhe30-Nov-09 21:58

lrsalunkhe

30-Nov-09 21:58

Respected,

But my problem is not been solved.So please help me in this.

Thanks.

Re: how we generate Tally XML file

dan!sh 30-Nov-09 22:04

dan!sh

30-Nov-09 22:04

There will be very few here who would know what Tally is. Whatever that is, if it has a dedicated forum, you should be really going there t opost your query.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Re: how we generate Tally XML file

Dinesh Mani30-Nov-09 22:35

Dinesh Mani

30-Nov-09 22:35

Can you explain what exactly are you trying to achieve here?

If I'm not wrong, then Tally generates this XML file when you create a trial balance or some other operation and this data has to be submitted to some Govt service to complete the transaction or something on those lines. Am I correct?

Now, do you need a way to parse this XML data and view it so as to validate it before submitting? Or is it something else you are looking for?

Re: how we generate Tally XML file

Abhishek Sur1-Dec-09 0:27

Abhishek Sur

1-Dec-09 0:27

If this is the schema, building an xml file is very easy.

Use X-LINQ to generate this xml and feed that in Tally.

Read all on how to generate any xml from here :
Linq to XML[^]

Finally after you generate the xml file, consume it from tally. Cool | :cool:

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: how we generate Tally XML file

Shyam Bharath1-Dec-09 8:01

Shyam Bharath

1-Dec-09 8:01

WTH is Tally? Sniff | :^)

Exam-O-Matic - Online exam conduction tool in ASP.net

Re: how we generate Tally XML file

Abhishek Sur1-Dec-09 8:27

Abhishek Sur

1-Dec-09 8:27

I never used it.. But it is an accounting package AFAIK... Poke tongue | ;-P

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Send Email Using My gmail Account

Thilina.madush30-Nov-09 20:22

Thilina.madush

30-Nov-09 20:22

HI
Could anybody please give me a reference or a description about how to send an Email, using my gmail account, from my asp.net web site. I've tried code in this reference.
http://www.aspdotnetfaq.com/Faq/How-...l-account.aspx

But its not working.
It gives an exception "failure sending mail"

Please help me
Thank you.

Re: Send Email Using My gmail Account

sashidhar30-Nov-09 20:24

sashidhar

30-Nov-09 20:24

try this:
Send E-Mail from your .NET Application using your GMail Account[^]

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: Send Email Using My gmail Account

Abhishek Sur30-Nov-09 20:45

Abhishek Sur

30-Nov-09 20:45

Here you go..
How to Send Mails from your GMAIL Account through VB.NET or C#. Windows Programming, with a Bit of Customization[^]

Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Re: Send Email Using My gmail Account

souidi abderrahman1-Dec-09 5:43

souidi abderrahman

1-Dec-09 5:43

try this code :
string _bodyMessage = "";
MailMessage mail = new MailMessage();
mail.To = emailto;
mail.From = emailfrom;
mail.Subject = "hello";
mail.Body = _bodyMessage;
SmtpMail.SmtpServer = "";
SmtpMail.Send(mail);

it works in my application Sleepy | :zzz:

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.