Recent content by Grudge

thanks wengyan, hmm, this actually makes sense. I'll try it out and let you guys know. Thanks for all the ideas and tips.

Hi Guys, I got a problem with ADO components. I've got a little program running on a server which does updates certain records to another sql server if certain conditions are met. That works fine, without any problem. The problem comes in when the connection fails (due to the other server being...

Thanks 2ffat, worked like a charm !

I can set the version options under the project options in Builder 6 (Version, Copyright, etc.). Is there a way to grab this data while the program is running to display it ? I'd like to display a splash with this information including the Build Version. Is this possible ?

Thanks for all the help sofar guys. I've tried just about everything and now I'm waiting. The db shows grey in the enterprise manager after applying a transaction log and it show loading in brackets after the dbname. Not sure if this is a good thing. It's taking quite a bit. Is this normal ?

What does this mean ? Server: Msg 4326, Level 16, State 1, Line 1 The log in this backup set terminates at LSN 3361000000110200001, which is too early to apply to the database. A more recent log backup that includes LSN 3362000000462000001 can be restored. Server: Msg 3013, Level 16, State 1...

This is what I meant : RESTORE LOG MainDBTest FROM disk='p:\maindb_backup' WITH RECOVERY, STOPAT = 'Mar 11, 2003 09:00 PM' maindb_backup is a complete backup of the current database, I'm trying to get it to restore the db from the transactions log in the maindb_backup, but I get the...

I mean how can specify the actual transaction log file (file.ldf). I've created a new database with our latest db backup (about two months ago). And now i've backed up the transaction logs of the current db (with missin table). Now I want to get the new db (with the old backup ) updated upto the...

>RESTORE LOG MyNwind > FROM MyNwindLog2 > WITH RECOVERY, STOPAT = 'Apr 15, 1998 12:00 AM' How would this syntax change if I want to restore from a transaction log file ?

Think I can fix it. How do I restore a transaction log up to a certain time. I've got a transaction log which I want to restore upto a certain time, lets say this morning. Is this possible ?

We had a problem in our Office System and one of our tables got completely deleted, our backups are totally screwed and I'm having a very bad friday... The SQL server is still running, is it possible to reverse the delete by using the transaction log in some or other way. Where will I be able...

I'm trying to create the TADOConnection at runtime, with the following code : // the connection TADOConnection *Test; Test = new TADOConnection(NULL); // specify the connections string Test->ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security...

I'm busy developing an application that needs to connect to different sql servers on a network. Is there a way that I can search for these servers on the network and display them in a listbox. Other SQL question(s) : I know how to get a list of fields from a specified table. But How do I...

I get the error "CoInitialize not called" when I do this in a thread. I don't get this error in a normal application. This is the execute code from the query : void __fastcall ThreadTest::Execute() { Message = "Thread Started"; Synchronize( LogMessage )...

Hey Guys, I'm trying to connect to a SQL database, using ado inside a threads execute statement, but it's not working. I'm not sure if I can do this, can I ? Thanks,