Search results for query: *

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,

Hey There, First off, thanks for all the help I've gotten so far. It's really helped me. Aha, but I have some more questions : I have a table full of records, and I want to create queries that do the following : 1) Delete all the records except the last x amount of records (ordered by date)...

Thanks, it works 100%

It's easy doing a query to get the last x records from the data (they each have a date field) QUERY : select * from sourcetable order by date limit x But I need to get the records that were added the last x days ??

ok, i see what you're trying to say. how ??

I'm currently developing an application which uses two indicators, which shows the network status (link to server) and sql status. I need a way to check for these two, without having my app to hang while waiting (or if either on of the two might be down). Network : I had this idea of pinging...