|
Hi,
We recently migrated one of our client's database (for our Application) from SQL 2000 to SQL 2005 server. Now its being told that there are issues with the application. Do we have to make changes to SPs and other queries while migrating to Sql 2005 database? Or is there other changes or settings to be made, has anyone come across such an issue?
Regards,
Blumen
|
|
|
|
|
Perhaps it would help if you care to mention what "issues" your application is facing. All SQL 2000 features are supported in 2005. As for settings, yes, SQL 2005 by default switches off a lot of features for reasons of security. You need to turn em on. Again, for this, it'll help if I know where your application is breaking. If you're using extended procs or link to other databases, you need to set permissions again in your current instance.
SG
|
|
|
|
|
Thanks alot for the information. I was told there were some issues at the client side, and no other details. I was curious about the changes in migration, so I posted the question here.
Regards,
Blumen
|
|
|
|
|
|
Add a parameter with direction ParameterDirection.ReturnValue.
---
single minded; short sighted; long gone;
|
|
|
|
|
You will need to execute command which has a parameter that has parameter direction ParameterDirection .Output
|
|
|
|
|
Hi,
I have created Installer Patch using "Setup and Deployment" option.
everything is working except Reports. I think Crystal Reports services files are not including when I create Installer patch. so thats why my reports are not working.
Is there any method to add Crystal Reports Services/Runtime files etc?
Kindly help me.
Thank you
|
|
|
|
|
Hi Riaz
If you create setup and deployment wizard(windows form), the crystal report is an 3rd party tool, so that necessary dependancy files are to be need to run crystal report in client machine. for this reason, their is a option in crystal report to create distribution package to your .rpt files.it convert .rpt to .exe files, this will create setup files containing all your .rpt files to .exe file. You may instal this distribution package into client machine, it makes ur client mechine have necessary dependancy files.
Regards
Arunkumar Sundaravelu
|
|
|
|
|
Hi, Mr Arunkumar Sundaravelu
I was too embarrassed to solve this problem. Thanks for your reply.
now i am trying.
Thank you
|
|
|
|
|
i've been trying to see how to retrieve texts from notepad to a rich textbox and don't knpw the technicalities involve. pls come to my rescue
ma coding life
|
|
|
|
|
What you want is GetWindowText api
Google:C# GetWindowText api[^]
Read serveral articles on this. There will be other api calls that you wil need to call to make this work and this may not work with some windows.
|
|
|
|
|
I am trying to develop a Chat application without using ajax.
Can anybody tell me if i can get data without firing any event on the client side.
hello every one
|
|
|
|
|
You can do it in simple Javascript by requesting status every once in a while,
then if there's a new message, display it
you can also do it in Flash, that is cool too (would also use javascript)
Regards,
Tzumer Edo.
|
|
|
|
|
I'm using webdav method to fetch mails from exchange server and same as send mails. My problem is - if the mail in exchange server is in spanish langugae how to identify , that mail is spanish mail.
Which property is used to identify mail language
The property "BodyEncoding".
which was not found in webdav method, how can i fetch the value of the BodyEncoding Property.
I use the below coding using search method of webdav.
Please suggest me.
///////////////////<
string strXML;
string strInboxURL = "http" + "://" + strServerName + "/exchange/" + strUserName + "/" + strFolderName;
MSXML2.XMLHTTP objXMLHTTP = new MSXML2.XMLHTTP();
System.Xml.XmlDataDocument xmlDOMParams = new System.Xml.XmlDataDocument();
objXMLHTTP.open("SEARCH", strInboxURL, false, strAliasName,strPassword);
objXMLHTTP.setRequestHeader("Content-type", "text/xml");
objXMLHTTP.setRequestHeader("Depth", "1");
strXML = "" +
" = \'DAV:\'>" +
"" +
"SELECT \"urn:schemas:httpmail:fromemail\"," +
"\"urn:schemas:mailheader:cc\"," + //
"\"urn:schemas:httpmail:displayto\"," +
"\"urn:schemas:mailheader:thread-topic\"," +
"\"urn:schemas:httpmail:to\"," +
"\"DAV:displayname\"" +
" FROM scope(\'shallow traversal of " + "\"" + strInboxURL + "\"\')" +
" WHERE \"DAV:ishidden\"=" + "false" +
" AND \"urn:schemas:httpmail:read\"=" + "false" +
" AND \"DAV:isfolder\"=" + "false"+
"" +
"";
objXMLHTTP.send(strXML);
xmlDOMParams.LoadXml(objXMLHTTP.responseText);
xmlDOMParams.Save("D:\\Test.xml");
///////////////////////
|
|
|
|
|
By now CodeProject has an expert[^] on this.
|
|
|
|
|
please share ur suggestion with us regarding above problem
Regards
Arunkumar Sundaravelu
|
|
|
|
|
what he is trying to tell you is to use the Search capability within this website.
__________________
Bob is my homeboy.
|
|
|
|
|
Hello. I have a windows forms application that has some timers. One of these timers has a tick event that raises another thread to continue with the application. I did that because the next operations include listening to a socket, and the UI gets blocked.
The problem is that in some occasions, I need to reactivate the timer, but it is not raised. I think it's because it's called from another thread.
Any way to solve that?
Regards,
Diego F.
|
|
|
|
|
|
Can you please tell me how to use Invoke to enable a timer?
Regards,
Diego F.
|
|
|
|
|
Something like this should work:
timer.Invoke(new MethodInvoker(timer.Start));
Robert
|
|
|
|
|
Sorry I am changing the question.I have to know the color of image that is displayed in bmp.
Please reply if you know.\
thnx
|
|
|
|
|
The answer doesn't change. If you want to know the single color, then you can grab the top left pixel. If you want to know one of the many colors, it's impossible to work out which one you want, unless you want one at a specific location, or you want the one that occurs the most, or the least, or some rule like that.
My image processing articles show how to look over an entire image, GetPixel is fine for grabbing one value.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
My customer want that either the image is blue-ish or not.nothing else
|
|
|
|
|
What is "blue-ish"? Do you mean something like calculate average color and if its close enough (given some metrics) to blue, it's "blue-ish"?
"Throughout human history, we have been dependent on machines to survive. Fate, it seems, is not without a sense of irony. " - Morpheus
"Real men use mspaint for writing code and notepad for designing graphics." - Anna-Jayne Metcalfe
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
