microsoft.public.vb.database.ado
RSS FEED IDEMS: www.tech-archive.net: microsoft.public.vb.database.ado
- How to Add an ADO Field via XML
Summary:
Does anyone have an example of how to add a field to an XML document that is ... generated via an ADO Recordset.Save? ... Stub example: ... Heather ...
- enumerate sql server in a domain...
Summary:
I want to enumerate alla sql server in a know damain named DIP, ... store the name of server fopund in Excel, ... Tks. ...
- Requery Method
Summary:
spots throughout my program but the rsCCIPinCheck recordset will not requery ... Am I doing something wrong that causes the requery method not to ... Dim conCCIWorking As New ADODB.Connection ... Dim rsCCIDistinctDias As New ADODB.Recordset, ...
- VBA Command dont recognize Error Trapping
Summary:
All SPs have their own Error Trapping, so if there's an error during the ... execution, we have a VB validation reading Output parameters in order to ... Custom Error Trapping code (Most of SPs executes this code when they ...
- How can I modify a report in Crystal Report 7
Summary:
I am a Web developer. ... I am new to VB 6.0 and Crystal Report. ... in VB6 and crystal report 7). ... increased the page margin and made it to zero and zero ...
- RTF to ADO
microsoft.public.vb.database.ado: RTF to ADO
- openschema table owner
Summary:
I want to display all the tables for the ODBC conection. ... Set objRs = objConn.OpenSchema ... the list of tables by table owners. ...
- Text File To SQL Server Using VB6
Summary:
I am developing an application in Vb6 and the datbase is SQL Server 2000. ... Dim objConnMisc As ADODB.Connection, strSQL as String ... It inserts NULLS at places where the data contains characters and numbers. ...
- Trying to use bookmark to set value of a text control after record selected in datacombo
Summary:
One is the order datacombo and the ... The datacombo is hooked up to an adodc data control. ... like to fill the text control with the order price. ...
- VB6 Change all records in specific table
Summary:
I have a System DSN connection already setup called "DBConn" pointing ... to the access database. ... How do I setup a connection in VB6 to use the DSN connection already ...
- VB6 Modify MS Access 2003 Field Names
Summary:
I have been out of the programming world for a little while. ... file that takes a MS Access 2003 mdb file, opens a table and modifies the ... If not just a pointer in the right direction ... Chris ...
- RecordCount returns -1
microsoft.public.vb.database.ado: RecordCount returns -1
- closing VB6 ADO recordset takes much too long with SQL Server 2005
Summary:
We are creating a Forward Only Server Side recordset. ... Closing the recordset is instantaneous, when we are using SQL Server ...
- Is it possible to restore SQL database from my VB application ? -VB question.
Summary:
cn.open connectionstring ... it cannot restore because databa is in use. ... Dim srv As New SQLDMO.SQLServer ... ALTER DATABASE uruntakip SET SINGLE_USER WITH ROLLBACK IMMEDIATE ...
- adPersistXML field order problem
Summary:
I'm trying to use ADODB Recordset Save method with adPersistXML in my ... Access 2k application which will be then opened with ADODC / Datagrid ... Unfortunately this method doesn't preserve my original field order ...