We use Aspose stuff on the project I'm on at the minute. I'm not sure what the license fee is (the client had already bought it) but it seems to be quite effective.

Parse the servername from Request.ServerVariables("HTTP_REFERER") IPHostEntry ipEntry; //The IP Address Array. Holds an array of resolved Host Names. IPAddress [] ipAddr; //Value of alpha characters ipEntry = Dns.GetHostByName (servername ); ipAddr = ipEntry.AddressList;

I replied here. http://www.codeproject.com/script/Forums/View.aspx?fid=12076&msg=2908867[^] Books are as useful to a stupid person as a mirror is useful to a blind person. - Chanakya

Thank u , just what I needed. select deptname,COUNT(deptid) from emp,department where emp.deptid =department.id group by deptname

Thanks.It's just what I needed.

Thanks for the reply. The authentication mode is SQL Server and Windows.

If you still have some doubts about the impersonation, then the Security guy might give you a hand. http://www.pluralsight.com/wiki/default.aspx/Keith.GuideBook/WhatIsImpersonation.html[^] One of the examples is to use the Word application at the server side which is quite often asked recently in the forum. Basically, the ASP.NET process identity does not have the permission to active the Word application, so you may want to run your ASP.NET application under a window account who has the permission to start the Word application.

Don't really know that much about Crystal, but I've seen this problem a lot. Usually affects older operating systems (Win 98/ME/NT) in my experience, and is down to a missing DBGHELP.DLL file. Visit: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=CD1FC4B2-0885-47F4-AF45-7FD5E14DB6C0 to see if this helps.

ok , thanks guffa snd sathish and ista for taking the time to reply. -- modified at 23:21 Tuesday 28th February, 2006

Thanks for ur reply Mike. i am unable to add hidden field to class file.

ok , thanks u so much. sarah

Sorry my question is wrong i just don't want the text in label control to be wrapped.(Label is in grid) I included FooterStyle-Wrap=False in the template column and now the label text is not wrapped . Thanks a lot for taking the time to read my query and reply. -- modified at 3:06 Wednesday 1st February, 2006

I have used this driver instead of Jet 3.51 DRIVER={Microsoft Access Driver (*.mdb)};DBQ= and it is working now (My boss says it's alright to use this driver in our project) Thanks Scott and KaptinKrunch for ur help. -- modified at 7:11 Tuesday 6th December, 2005

More information can be found here: http://support.microsoft.com/default.aspx?scid=kb;en-us;301202[^] "Although not the most reliable way to check the MDAC version", I use a launch condition and install it if the version is below 2.7

VB6 Is this a list of queries to be accessed sequentially, or do you need to select? Basically read the query from the file into a string, or string array depending on what you need to do, and then execute the appropriate string. If you need more help I can assist if it is VB6

hi i got the desired output i had to change the sp. crate procedure sp_user @NAME char(50), @PASSWORD varchar(50), @NO_OF_users INT OUTPUT AS SELECT @NO_OF_users = COUNT(*) FROM LOGINTAB WHERE (((LOGINTAB.NAME)=@NAME) AND ((LOGINTAB.PASSWORD)=@PASSWORD)); PRINT @NO_OF_users thanks again bye sarah

You can use a TemplateColumn to do that : My Blog

thanks minhpc_bk for taking the time to read my doubt and reply. thanks for the info.i'll check out the site