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 IamaSherpa 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: *

  1. gorack

    Current recordset does not support updating...

    current recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. My code is in VBSCRIPT i create a connection then Set rs = CreateObject("ADODB.Recordset") rs.Open "table", SourceConn, adOpenDynamic rs.addnew the addnew...
  2. gorack

    Timeout expired when deleting a million record table

    Thanx! I forgot the TRUNCATE TABLE command hehheh
  3. gorack

    Timeout expired when deleting a million record table

    why ?
  4. gorack

    Better coding option in SQL SERVER 2000

    If i need to convert an access application (query, tables, codes...) in SQL SERVER 2000 and i need to make code, what is the better solution (with performance and portability in mind)? -Stored procedures (cursor is slow) -VBScript or a VB PACKAGE in DTS ?
  5. gorack

    Incorrect syntax near '*' when i tr

    Incorrect syntax near '*' when i try to delete from a sql server 2000 table
  6. gorack

    Can't update,delete or insert in sql server 2000

    It's surely not a network connection because the sql server 2000 is local. Tere is no DBA who can help me ?
  7. gorack

    Can't update,delete or insert in sql server 2000

    I am de dba and programmer of the datawarehouse. So i must know why in vb6 in the data window it work (delete, insert or update) ? i use the same connection as in vb6 use.
  8. gorack

    Can't update,delete or insert in sql server 2000

    sql sister how do i do that ? with the login ?
  9. gorack

    Can't update,delete or insert in sql server 2000

    I have a data warehouse in my workstation in sql server 2000. I installed Sql server 2000 with windows nt authentication. I create a database and i create tables. In sql server 2000, when i create stored procedure and i insert, delete or update table it's fine. But when i use access with an...
  10. gorack

    Can't update,delete or insert in sql server 2000

    Why i can't insert, delete or update in a sql server 2000 database with an odbc connection or an ole db connection (ADO) ?

Part and Inventory Search

Back
Top