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 bkrike 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: arnierudy
  • Content: Threads
  • Order by date
  1. arnierudy

    How to write to a text file using a stored procedure.

    Is it possible to open a disc file for read/write using a SQL script in a stored procedure? For example, I would like to open a cursor, format each record and then write it out to a csv file. I know how to format the record but I can't figure out how to open the csv file for output. Thanks in...
  2. arnierudy

    Nested VB transactions with SQL produce error.

    My VB app is currently being upsized from DAO using Jet to ADO 2.6 with SQL 2000, using the SQLOLEDB.1 provider. I have transactions in the VB code using the .BeginTrans method of the connection. In some cases there are nested transactions. These were never a problem with Jet, but now the second...
  3. arnierudy

    MSDN and VB6

    I recenly loaded the MSDN July 2003 library, all three cd's. When I go to the Start menu I can get to it but when I press F1 in any VB6 project I get a message "The MSDN collection does not exist. Please re-install MSDN". I did, but to no avail. Any ideas as to what the problem may be...
  4. arnierudy

    Getting the F! key to display ADO help in VB6

    I posted this once and got no replies, so I'll try again. I have been working with ADO 2.6 in VB6 on a Windows 2000 machine. When I put the cursor on an ADO object, property or method and press F1, I get "No help available". Help for regular VB commands and SQLDMO object work fine. I...
  5. arnierudy

    Exclusing Connection to SQL with ADO

    I am writing an application to migrate data from Access to SQL using VB6 and ADO. According to all the documentation I can find, I can force the user to open the databases exclusively by setting the Mode property of the connections to adModeShareExclusive before opening them. This works fine...
  6. arnierudy

    ADO Context-sensitive Help

    I have been working with ADO 2.6 in VB6 on a Windows 2000 machine. When I put the cursor on an ADO object, property or method and press F1, I get "No help available". Help for regular VB commands and SQLDMO object work fine. I suspect the help files may have been installed in the wrong...
  7. arnierudy

    How does Jet know a transaction is pending?

    When you start a transaction with BeginTrans, Jet knows you have done so, because if you try to do a RollBack without having first done a BeginTrans an error is raised. I always set a boolean to True when I do the BeginTrans and False when I Roll back or Commit, but there MUST be some property...

Part and Inventory Search

Back
Top