ActiveX dll Class & ADODB Connection problem -
Howdy,
I'm developing an ActiveX dll and having some major problems
I want my dll to have basically house functionality to create some reports from a database to a disk file. I have made a class for each report but am having trouble with the database connection in the class object. Its not a dll issue as I've taken the code out of my dll and into a standard project and I'm getting the same problem so I think it's my class and/or the adodb.connection member.
eg
Class Report4
Which would be used as follows,
dim myReport4Obejct as new Report4
set myReport4Object.dbConnection = thisprojectconnection
myReport4Object.CreateReport("disk_file.csv")
The database connection variable is a private member and is declared as new in the class and the Set property takes the arguement byref and has 'set mvardbConnection = inputconnection'.
I have a Set/Get combination for the adodb.connection member and the setting seems to work but I get an "Object variable or With block variable not set" error when using the Get. I've tested the ADODB.Connection.State property in my Get property and it is '1' which means it should be fine but for some reason it just doesn't want to return the connection and there is an error on the return.
Is there something I don't know about ADODB.Connection?
Should I be using a Let instead (even though its an object)?
Can anybody help me for where this is going wrong ????
Thanks in advance,
Damian Del Campo
ActiveX dll Class & ADODB Connection problem -
Howdy,
I'm developing an ActiveX dll and having some major problems
I want my dll to have basically house functionality to create some reports from a database to a disk file. I have made a class for each report but am having trouble with the database connection in the class object.
ActiveX exe with ADODB Connection -
I'm trying to write an ActiveX exe that will perform a check on a database. But I would like to pass my ADODB connection to the ActiveX, so that I don't need to re-establish a connection to the database. I keep getting an "Invalid Property Value" error. Any ideas would be gre
ADO, SQL server 7, VB6 connection problem -
A plea for help!
The following code was placed into a UserDocument in an ActiveX Document Dll project.
We are using VB6(Visual Studio service pack 3), Microsoft ActiveX Data Objects 2.1, SQL Server 7 And IE5 on a Windows 95 machine.
The code runs fine in design mode but once the dl
Database connection from ActiveX Control -
Hi All,
I have created an ActiveX Control which I am using in ASP page. I want to use database from the ActiveX Control. But the problem is when the page get downloaded to the browser with ActiveX control, it is not able to create database connection because the connection which i h
Checking for NULL ADODB.Connection (RESOLVED) -
Hello everybody
I have this problem. When a form of my application is closed, it eventually closes the ADODB.Connection to the MySQL database. Unfortunately, on some occasions the reference might not have been set due to an error of some kind.
How can I check to see if an ADODB.
Is the Connection closed -
Question???
How do I check to see if 1 or the other connection to a database are closed or not?
Dim cnnDVD As New ADODB.Connection
Dim rstDVD As New ADODB.Recordset
Dim rstDVDCheck As New ADODB.Recordset Dim strSQLDVD As String
ADODB Library -
I am following Beacons tutorial on learning ADODB
Here
he says to go to project > references and select the “Microsoft Active Data Objects Library”
All I can see is the
Microsoft ActiveX Data Objects 2.0 - 2.7
RecordSet 2.7 Library
ADO ext. 2.7 for DDL and Security
problem filling a datagrid without ado control -
I try to fill a datagrid, without an ado control.
I found a lot of code to do it, but it doesn't seem to work.
There are no errors, but there is no data in the grid displayed eather. Anyone any idea why??? (did i forgot something or so)
thanks anyway!
ps: I used microsoft act
MDAC DataLinks Object -
According to the MS Knowledge Base, the following code can be used to display a dialog for editing ADO connection strings:
Dim cn As ADODB.Connection
Private Sub Command1_Click()
Dim MSDASCObj As MSDASC.DataLinks
Set MSDASCObj = New MSDASC.DataLinks
Set cn = New ADODB.Conn
[2005] adodb.connection is no more -
Error 1 'Connection' is ambiguous in the namespace 'ADODB'.
dim conn as new adodb.connection
conn = new adodb.connection
what am i doing wrong here? how do i make a conenction like this and also how do i do it for a recordset?
dim rs as new recordset is what i us
Problem with ADO -
Hi
i am getting this error when i try to create a new adodb
connection 'ActiveX cant create object'.
How can this problem be solved?
Can't Figure Out Connection String -
Hello,
I have a ODBC Data Source for a SQL Server. The text connection was good. I am trying to connect with my VB application to the database with ADODB. I get a "Operation is not allowed when object is closed message". Basically, my connection is not open and methods fai
Oracle connection in ActiveX exe -
**Cross-post from CodeGuru**
I have written an application which by nature is often launched then shut down; each time creating then losing a connection to an Oracle database.
To avoid that, I am trying to create an ActiveX exe that would connect to the Oracle database once and
Problem with ADODB -
Hi,
I'm trying to connect to my database using ADODB. When I write this code: Dim RS New as ADODB.Connection. Visual Basic says it doesn't recognize the user-defined set type. I'm using VB5.0. If anyone could shed any light on this problem it would be appreciated.
ADODB.Connection Issue -
hi everyone ...
i use adodb.connection and sql db
i connect to my db through adodb connection.
then i activate my application role with:
adoCon.execute "sp_setapprole 'myrole', 'myrolepwd'"
first time i open the connection its work fine.
then i close the connec
Detect startup folder with NO activeX and NO wsh -
Can you show me how to Detect startup folder using:
1) ENVIRONMENT variables
2) Registry
Using "VBScript" ? and without it triggering ACTIVEX as
a lot of things like Wsh etc. trigger ActiveX.
Whereas opening an ADODB connection object does NOT.
"Simple" problem with ADO -
I'm working on making the connection between VB and and access database using ADO. For some reason, everytime I run the program, I get a compile error right from the start on the declaration of the ADODB.Connection, ADODB.Command, or ADODB.Recordset.
Dim objConn As ADODB.Command
D
.ldb file not getting deleted after closing the adodb.connection -
Hi,
We open a database connection with MS-Access using ADODB.Connection, and even after closing the database connection, the .ldb file is not getting deleted. What will be problem?
Even we have checked the state property of the Adodb.connection. It is showing 0.
We are using F
Problem with SQL & ADO -
Hello,
I'm new with VB6 and ADO, even if I have some experience with VC++ 6
I'm now trying to use VB6 to send SQL commands to an SQLServer database using ADO.
So I created a connection and a recordset :
Dim cn as ADODB.Connection
Dim rs as ADODB.Recordset
Created the ob
Multiple Selects(resolved) -
If I am populating many different controls all with different tables within the same database do I need to have multiple rs and cn statements
ie.
Private adoRS As ADODB.Recordset
Private cn As ADODB.Connection
Private adoRS2 As ADODB.Recordset
Private cn2 As ADODB.Connectio
Type ADODB.Connection is not defined -
Hi all. Im a Delphi programmer by trade but I recently got a copy of Visual Studio 2005 so I could write some applications for PDAs.
Anyway, Im trying to connect to a MS SQL Server with ADO, and all the help Ive read tells me to do something like this :
Public Class Form1
Di
c# Socket pool forward connection request to vb6 activex -
Hi!..
I have a problem i hop someone can help me with!..
I need to set up a c# socket that listning on a port, and the create a new instance of an active dll and forward the (vb6 socket requestid) to the activex to tell the dll to accept the connection and start working..
My p
ActiveX, Recordsets and Locking -
When I use this code if I run it in an ActiveX Control, set a breakpoint at the line in red then go into the SQL DB table and try to modify the record the code is supposed to have a LOCK on, I can still manually change the record. Why is that? When I try to manually change the record f
recordset object problem -
Hello ... am having this little thing troubling me a lot ... hopefully there will be many who know how to solve it and will help me out .. so heres the problem !!!!!!!!!
I want to have two modules for connection object and recordset object .... i have been able to make both and they
ADODB.Connection with SP problem -
Hi,
I'm using ADODB to connect sql server.
i created a connection. i run a stored procedure from connection object, it's not returning resultant recordset. The strored procedure will return recordset
Can anyone clarify that?
OpenSchema Problem -
Hi there,
I am using a Access database and I want to retrieve the tables in a database except system tables, but some problem is arrising while the "filter" line is being executed. My code is written below;
'------------------------------------------------------
Option E
HELP! ADO problem with ASP -
Hi,
I have a problem trying to connect using the connection object. I'm trying to access the filesystem of an IIS5 server running windows2000. The following works in visual basic, but not in ASP:
dim conobj as ADODB.connection
set conobj = new ADODB.connection
connection.open(&
problem using Datagrid with code -
The following is my code. The problem I encountered is the error message will be shown as error # 7004 which indicate Dtagrid
can not be bookmarked.
But I can use "set" method to set up the value of textbox. It didn't work when appling to the Datagrid control.
General_D
Problem making changes to ADODB Recordset -
Hi, Any help with the following would be greatly appreciated.
In Access VBA i'm trying to create a recordset which is linked to a table in SQL Server, set some values in the recordset then open a form that is bound to the recordset. The problem i'm having is that the changes which i m
Help: ActiveX Problem -
Good day everybody...
I have a problem with my ActiveX exe.
I created an ActiveX Exe written in VB. It'll be integrated into my Standard Exe program written in VC++.
When I first integrated it into my Standard Exe and compile it, it runs ok. I install the whole application, incl
Regarding ADODB connection -
I'm using ADODB connection object in Visual basic to access data from SQL server. Should i close the connection while ending the application? or will the connection automatically closes when closing the application?
Thanks for any help.
Regards
Sujatha.
time out error when saving to SQL database -
I keep getting random time out errors when saving to the SQL database. We have been running the same program for close to 2 years and have never had this problem. We have not changed any of the program. Here are some of the lines used to connect and save to the database.
dim db
ActiveX Control Database Connection -
I am creating an online chat program using the ActiveX control. The one thing hindering me is making a database connection (DSN-less) to an accesss database residing on an online server. This the code i tried, but it doesn't work. It gives me an error saying "object required&qu
[2005] Recordset Problem -
I have a problem with the following code:
Code:
Dim Conn As ADODB.Connection ' Connection to database
Dim Rs As ADODB.Recordset ' Recordset
Dim Query01_ListTemplates As String ' Select Query
Conn = New ADODB.Connection ' Set "conn" as d
Error 429: ActiveX cannot create the object -
This problem has been bugging me for a while now and would love any kind of imput on it.
Here is the problem:
I am creating a VB application that connects to QuickBooks using the Quickbooks SDK. It takes orders from a SQL server Database. I am using ADO to connect to the DB. Below
Error 429: ActiveX cannont create the object. -
This problem has been bugging me for a while now and would love any kind of imput on it.
Here is the problem:
I am creating a VB application that connects to QuickBooks using the Quickbooks SDK. It takes orders from a SQL server Database. I am using ADO to connect to the DB. Below
ActiveX control delays on some networks when internet is down -
We are having this strange problem with an ActiveX control of ours, in fact all of our web application's activeX controls have the same problem.
On some networks, when the internet connection is down, the control takes about 20-30 seconds to open.
The controls all reference a MyS
Opening Connection to Acces DB 97/2000 -
Hello World,
Could anyone help me with a list of (all ?) possiblities of provider information to open a ADO connection to a access 97 and/or access2000 DB.
what i mean exactly :
Code:
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cnn = New ADODB.Connection
Best way to organize ADO objects in my program -
I have a VB6 program with about 25 forms that manipulates data in an ACCESS database via ADO.
Originally I had the bright idea to establish a data connection ONCE using a global ADODB.Connection object variable, and then create, open, and close ADODB.Recordsets in each form as requ
Winsock(cSocket) Accept RequestID problem... -
I have a server app that uses cSocket...a request comes in for a connection, I create a new cSocket(winsock) object and get it to accept the request ID...This ALL works fine in one project (same thread)...
But I wrap a cSocket up in an Active X EXE, which I create a new instance of wh