Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: opo
  • Order by date
  1. opo

    Deleting Records on Large Table

    It worked perfectly! Thank you, thank you thank you!
  2. opo

    Deleting Records on Large Table

    The updates come in a flat file. I use a DTS to put them in a temp table on the same database. I then use another DTS to try to insert them into the primary table. When the DTS fails, because of the violation of the primary key, the VB program tries to inserts the records one at a time from the...
  3. opo

    Deleting Records on Large Table

    I have a table that contains over 6,000,000 records. It has a primary index on 4 char columns. I receieve duplicate or updated information regularly, so i need to either delete the existing record and insert the new, or update the old with new info. I tried doing this in vb program, but the...
  4. opo

    Timed outs on Deletes and Updates

    I have a table with more than a million records. and it is indexed. I can select * from... the table based on a indexed-field with no problem, but any deletes or updates timeout. Any suggestions?
  5. opo

    IDispatch

    I need to make an .ocx that uses IDispatch to interface with another application. Trying to find a straight-forward and complete example of how to do this, if anyone has or knows of one. Thanks
  6. opo

    Bulk Insert Error

    Played around with DTS packages for two days, I now understand how to do it. Thanks!
  7. opo

    Triggers Across Server

    Just looked at the linked servers tab in Enterprise Manager. I can see the sys tables but not the tables I want the triggers to affect. Is this a reason why they don't work?
  8. opo

    Bulk Insert Error

    The file is fixed length. I did not have a format file. The errors are in the bulk statment when doned in the Enterpriser Manager. The VB program works, just slowly. And I will send another post regarding the triggers.
  9. opo

    Bulk Insert Error

    Sorry, it took awhile to respond, had to research what you were talking about with a format file. I am a VB programmer and i have to add records to an exisitng Sql table from a text file. There could be anywhere from 40,000 to 100,000 records in each txt file. Currently i do this with an insert...
  10. opo

    Bulk Insert Error

    I'm trying to bulk insert a textfile into a sql server table. The message I get is unexpected end-of-file error Should there not be one at the end of a text file. Please help!!
  11. opo

    Trigger problem from Server to server

    I have just made my first simple trigger! all i need is to go between servers the code is CREATE TRIGGER pop3 ON dbo.test For Update As If Update (one) Begin Update server1.dbname.dbo.test2 Set server1.dbname.dbo.test2.two = test.one from test inner join server1.dbname.dbo.test2 on...
  12. opo

    Triggers, Stored Procedures or Constraints

    We are in the process of sharing a server with another company. We are thinking of using sql replication to send the data back and forth from ours to the central server then to theirs. There are concerns if their data is incorrect and gets copied to our tables. What is the best way to 'scrub'...
  13. opo

    transaction log

    Log Question? Not sure if this is. I am a VB programmer and I need to know when our DBMA has change the structure of a table,deleted some information, or made ran some update queries. Is there a log that will show what he has done and when or is there a way to notifiy me when it occurs?
  14. opo

    Printer Problems and NT permissions????

    Check Microsoft Site, that reference you gave no longer exists :(
  15. opo

    Printer Problems and NT permissions????

    Hi Checked the Event Log, message: 'Document failed to print due to GDI/Driver error in rendering' Window Graphic Driver Interface ? If so how do i fix?
  16. opo

    Printer Problems and NT permissions????

    the job is queued to the printer then notifies of error sometimes get message no permission to computer, sometimes can see computer, although icon is there. I will check the event log sys admin does not want to give everyone admin priveleges thanks
  17. opo

    Printer Problems and NT permissions????

    I now have two printer that are not working. Anyone with Adminstator privleges can see and use the printers. Anyone else cannot. Being told it has nothing to do with permissions. But shouldn't it be? The driver is not faulty or would not work. They can be seen on network and can be used And the...
  18. opo

    VB6 and DbaseIV Files & ADO

    Finished a program that accesses a dbIV file thru ADO. Program works fine, with exception of one thing. The queries to the database are toooo slow. No problem with Sql Server tables or Visual FoxPro only DBaseIV. Anyone know why?
  19. opo

    Corrupt OCX file

    I have several programs that us the msmapi.ocx. I believe the ocx is somehow corrupted. I can run the programs in develeopment mode & can save them. If i try to make them an executables i get the error: The instruction at "0x005620d2" referenced memory at "0x21d714c". The...
  20. opo

    Need help with an error: A string is required here

    I have just had the same problem. I found that when i was making a record selection in vb code, the was sytax error in my selection. If that doesn't work. Send copy of your code. might be able to find it.

Part and Inventory Search

Back
Top