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...
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...
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. ...
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 ...
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, ...
I am learning VB.Net. I am trying to write some generalized code that I can use with any datagridview of "y" rows by "x" columns to which I am binding a bunch of string data. In the code belo...
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...
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...
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...
Hi,
I am using VB6 and in the code I execute a SQL query that returns a set of records.
I need to check 2 columns in the recordset for being Null.
When I use IsNull the application throws...
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...
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 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!
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(...
I wrote the following code for Access 97 where it runs with no problems. However when I brought it into VB5 it didn't like the CDate function in the SQL statement. Giving the error message
...
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...
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
...
"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...
Hi,
I am using ADO ver 2.0 for connecting to Oracle database in VB. I could open the connection and query the database with this connection. But if the connection lost due to network failur...
Hello. my question is in regards to the new access database format in 2007. i have a program i wrote and maintain for a local business and it is backended with an access 2000 mdb. i'd like ...
In VB6 using ADO, do you get an error message if you try to close a recordset that is not open?
example:
Dim cn As ADODB.Connection, rs As ADODB.Recordset
Set cn = N...
Hello to you all,
My question is as follows:
Before i insert a new record in the company database, i want to check if the company name allready exists in the database, and if not then ad...
Question Background
Im developing a POS(Point Of Sales) application. System Design to access several (average 6) POS computers from a BackEnd Computer. Data Including about 40000 products, 15...
