Hi all,
I use a stored procedure to insert values. But turkish characters are not inserted correctly.
Collation of the database is true (Turkish_CI_AS) . Anyway there is no problem when I run the same insert script on SQL Query Analyzer.
I would be grateful if someone can help me...
User Profile
Collapse
-
Turkish character problem in stored procedure
-
I included SQL-DMO library in my application. Using SQL-DMO objects, I create a job in SQL Server Agent and assign a schedule so that back up can be done periodically. -
Thank you for your advice. I already tried this but it didn't help. But my problem is solved:) (I don't know how) I just wrote the SProc all over from the beginning....Leave a comment:
-
Write a Script as Varchar Parameter in Stored Procedure
Hi all,
I paid 3 hours for it but couldn't get succeed.
I'm writing a stored procedure to get a data entry in a table. The problem is that I can't simply use commands "SELECT" or "CASE" directy. First I have to declare a varchar parameter and put all of this in this parameter. (The reason is that the stored procedure is not unique for a table. Year and month, which are parts of the table name are also parameters... -
Thank you. But, what I want to do is to realize it programmaticall y. I don't want that the user has to set up anything in Enterprise Manager. All the back up procedure must be organized during the installation of my application program.
An idea is to define a scheduled job on server agent by using SQL-DMO library. So, the job will back up the database periodically. But I am not sure if it is the best choice.
Any other ide...Leave a comment:
-
Automatic Database Backup
Hi all,
I have written an application in C# .NET which will run on another PC. The database required for the application will be created during the installation. How can I provide that the application backups the database periodically? Can I generate an SQL script which will run at installation and then backup the database automatically?
I really need advices.
Thank you...
Burcu -
-
Thank you george, but it is exactly what I do.
It works on my computer. But a thread continues working when I test my application on another computer. There is no .NET framework on that computer. But I put the framework in setup project. May the problem depends on it ??
Thank you kenobewan. But I don't see the point in using application unload event. Can yo explain it please?Leave a comment:
-
C#, Application does not terminate
Hi all,
my problem is that the application doesn't terminate when I close the form using the close box on the caption bar. Actually it seems as if the program is closed but task manager's process list shows that it is not.
There is one thread that I manully create and start in forms load event. But I set the IsBackground property of the thread to true. So, it should terminate while exiting the application.
There are...
No activity results to display
Show More
Leave a comment: