I am trying to set up my first connection using ADO from VB6 to a Access database.
Some settings:
I have the Microsoft ActiveX Data Objects Recordset 2.7 Library and the Microsoft ActiveX ...
Hi, can somebody show me the correct connection string to connect an sql server database (dsn-less) I have tried a few. I will actually be using it in excel 2000 vba, which should be the asa...
I'm getting this error Run-Time error 3146 ODBC - Call failed when i try to run this code. I dont know what i'm doig wrong. The code worked until i changed the SQL query. I have pasted both, ...
hi all,
i try to use a recordset in vb to count a distinct records in a table with statement like below:
objrec1.open "SELECT count(distinct fieldA) as distinctcounter from tableA;",gldb...
I need one or more sql queries that will find all the SQL Databases on a SQL Server along with the table count, size in Mb, and number of current connections for each of the databases found. ...
Hi!
I have a MS Access 2000 database containing a table.
The table has 10 fields which are of textual or numerical format.
What is the best/simplest/most reliable way for me to conne...
Hello,
In Microsoft Excel I currently have a query set up referencing an ODBC data source named "SALES", table "SALES_2007".
What I would like to do is have this query use a value in ce...
Hello,
Im trying to connect an access file to my application and im recieving the following run time error... "The connection cannot be used to perform this operation. It is either closed or ...
novice needs help!!!!!!!
I am getting error 3021, (either BOF or EOF is true, or the current record has been deleted. requested operation requires a current record with this code.) i have a...
Right now I have an application that uses an Access database and an ODBC connection using VB6.
I currently have to set up the ODBC configuration using Control Panel/ Administrative Tools/Da...
I am getting an Automation Error -2147417848(80010108) The object invoked has
disconnected from its clients. The control application that is getting these errors is written in VB6 using DA...
I get the following message when trying to connect to an advantage database:
Run-time Error '3706' Provider cannot be found. It may not be properly installed.
It works fine when I try an...
Hello all,
I am working on a already developed visual basic program. That program resides on a shared drive. My boss was using that from long back. Recently it was not working, I fixed it a...
Hi,
I am trying to use a sql stored procedure instead of a query from my VB 6.0 code. I am passing parameters. Basically the stored procedure checks if a given record or set of records exis...
"Item cannot be found in the collection corresponding to the requested name or ordinal."
Using ADO against an Access 2002 database.
I am reading fine from table Config, then I reset my sql...
I have an Access 2007 frontend which connects to several linked tables on a MySQL server using ODBC, through VBA. On my Windows XP Professional SP3 machine with MySQL ODBC Connector 3.51 I ha...
I need to create linked tables in MS Access databases.
Problem the line giving me errors is the "catdb.tables.Append tblLink" saying "-2147467259 Could not find installable ISAM". I think ...
I am NOT a VBScript or db expert, but I understand them conceptually. I will need some handholding on this (sorry), so please make instructions highly detailed, or give me links to other refe...
Hi all,
I'm trying to get data from an excel file (2000/2003).
To connect to the excelfile and do a simple query is rather easy:
Set Con = CreateObject("ADODB.Connection")
StrCon = "Pr...
Hi folks
I have 2 tables, parent categories and child categories relating to products for an online shop.
Parent Categories Table fields
*Cat_id cat_name
Child Categories Table f...
Hello all!
When I try to insert values into sql in vb6 using ADO I receive an error of "Obeject variable or with block variable not set"
Here is my code :
Private Sub TestConnect_Click(...
Does the ADO Recordset.Open adLockReadOnly lock the underlying SQL 2000 rows or does it just lock the returned ADODB recordset?
We have a Visual Basic 6.0 application with SQL 2000 on the b...
Using VB6, MS Access 2000, ADO. Used VB Data Form Wizard, Access, linked to the database NE.mdb, used "Single Record" option, ADO Data Control, selected a table called "Students", all records...
I'm using RDO method to connect to my database.
I'm using connection string like this:
Private cn As rdoConnection
Dim En As rdoEnvironment
Dim CPw As rdoQuery
Dim Rs As rdoResultset
...
Hi there,
I have UTF8 characters stored on SQL database, and I need to read it as ANSI or UNICODE characters using Visual Basic 6.0 and I need to store it in Access Database for future work.
...
