Search results for query: *

Lots of examples here. Thanks to all of you for your help!

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...

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...

Guess what? I found the answer to my own question. You need the help files for ADO 2.6. If you don't have ado260.chm on your disk already, you have to get the ADO 2.6 SDK from Microsoft's web site and install it to get the files. The file ado260.chm has to be registered in this subkey...

Thanks to all of you. I must have missed the warning that the install flashed on the screen when it sensed that I don't have VB.Net loaded.

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...

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...

RiverGuy, I appreciate your interest. You are correct. I have written code to update an empty SQL database with data from Access. What I need to do is make sure that nobody else can go into that SQl database and add or edit data while my code is running. Setting the Mode property of the...

My utility will be used to port our customer's data from Access to SQL. We are providing the script to create the SQL database and a utility to copy the data. We will not be there at all our customer's sites when it is done. We are also making some changes in the SQL data structure. We have to...

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...

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...

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...