Simple, free RDBMS for VB3/6 with minimal installation footprint
Can anyone recommend a basic RDBMS (a la MS Access 2.0/97) for use
with VB3 and VB6? What I'm looking for is a solution with the minimum
number of support files (DLLs).
I ~could~ spend a few weeks boning up on Rod Stephens' B-Tree stuff,
but I don't want to reinvent the wheel if someone has already done it.
An ideal footprint would be:
app.exe (the application)
app.ini
db.?? the database
dbsup.dll (its support file/engine) - or preferably VB code I just add
to my app, obviating any need for a support "engine".
MM Tag: FileExists that works? Tag: 651546
GUI Issue: Controls NOT visible when .Visible = TRUE
This is one that I can't figure out. In a large application we have several
forms where this occurs, sometimes randomly ... but some forms it happens to
the same control every time.
In each case the control is either a textbox, ComboBox or Date control In
each case the .Visible property is set to true and if the control is a
"child" to some other "parent" control (such as a Panel or Frame) other
controls on the same "parent" do not exhibit this problem. The control may or
may not contain a value but in the case of ComboBoxes the ComboBox is
populated with a valid list.
The problem is that at runtime (design or compiled mode) when the form loads
the control(s) in question will appear as a blank "white space" and then when
you click on the whitespace the control will appear, but still will appear
"wrong" visually though the data is correct. Since we know that the control
will "try" to appear if you click on it we have tried a forced .SetFocus to
the control but that has not always worked either.
This is hard to describe ... please advise if a screen capture would help
identify the problem.
Thank you for your help on this.
--
Brad Ashforth Tag: FileExists that works? Tag: 651537
CursorLocation of ADO Connection
When using ADO and querying a SQL Server database using Stored Procedure,
will it be faster if I set the CursorLocation of the connection to
adUserServer ?I guess I do not fully understand the effect of setting the
CursorLocation to adUserServer or adUseClient.
Thanks. Tag: FileExists that works? Tag: 651523
Slow application exit on windows 98
Hi all,
I have a big problem. Sometimes, when I close my application it remains as
froozen
on the screen. Debugging my program I've seen that I call a method of a my
class and that before the first instruction is done, 20-30 seconds are
elapsed.
I have verified that during this time the program isn't doing any my
instructions.
Has someone any ideas of what is happening?
Can someone help me?
Thank you
Beatrice Tag: FileExists that works? Tag: 651516
Mystery ... The disappearing VB6 Program
Hello There,
I have a plain 1-form, a couple of controls, VB6 executable, that, when
minimized disappears behind the DeskTop Task Bar. Does anybody know why?, and
What to do to prevent this behavior?
Thanks for your help
Ivan Tag: FileExists that works? Tag: 651515
User action logging
Does anybody have an idea as to how I might (without adding logging
code to every click event) log the user activty within my app? My
problem is this, I have an app that is used by workers on the factory
floor. Most of these users are not very computer literate and therefor
when they do things which cause errors or unexpected results they are,
for the most part, incapable of telling me the actions they took that
caused the problem. The app has very good error handling/reporting
(with stack trace) so when the problem actually creates an error (as
opposed to just giving invalid/unexpected results) I am pretty much
able to track it down. However when no actual error is produced I have
no way of knowing what the opperator did to get the app into the
invalid state.
Any help would be greatly appreciated.
Thanks
Steve Tag: FileExists that works? Tag: 651511
Send messages like server manager
In server manager {NT days} you are able to send messages to a server. Anyone
with a mapped drive or using a resource on that server would get the net send
message. We use it for notifying users a server is being rebooted.
Is there anyway to do this with VB 6?
I have code that will programatically send a messenger service message to a
user or a machine, but not to users connected to resources on a machine...
Thanks
vm Tag: FileExists that works? Tag: 651508
RTF to HTML
I have a small app that allows the users to enter notes in a rich text box.
One of the outputs of this app is a web page that includes the notes
formatted as html output. I have a routine that does that for me reasonably
well.
Unfortunately, the users have discovered that they can put graphics in the
notes using copy and paste from other applications and now they want the
graphics included in the html outputs. I have no idea how to go about doing
this!
Does anyone know of anything that can take a rich text box, with graphics
and generate a web page for me, or any routines that allow me to extract the
images.
Thanks
Steve Tag: FileExists that works? Tag: 651491
Not getting all records from RecordSet
Hi All,
i'm running a vba application using Ms Access.
in my database,Employee table, i'm having department ID same for 3 employees
i need to get that id in an array
i gave the code as
value = recordset.Fields(0).value
'value will record the count of Deptid coulmn whic have the same ID
Dim i As Integer
Dim data(4) As Integer
recordset.Close
Set recordset = New ADODB.Recordset
For i = 1 To value
sql_check = "select Deptid from Employee where deptName = '" & Name
& "'"
recordset.Open sql_check, connection, adOpenDynamic, adLockOptimistic
connection.Execute sql_check
data(i) = recordset.Fields(0).value
Next i
but i' getting a runtime error that operation not allowed when the object is
open
Please help...
regards
Rachel Tag: FileExists that works? Tag: 651487
VB6 Merge Modules and Vista
I donâ??t know whether hereâ??s the right place to post this question, but it
seems that you guys know what youâ??re talking about so might as well try.
We're designing our application's installer (using InstallShield 12) to be
compatible with Window Vista. Our VB6 application requires some merge modules
to be installed on the target PC and one of these is the 'oleaut32.msm'.
We're getting errors with this component when we validate it against Vista
requirements, so I'm just wondering whether Microsoft has any plan to release
a Vista Logo compatible version of VB6 merge modules, particularly for
'oleaut32.msm'?
The ICE (Internal Consistency Evaluators) error weâ??re getting is ICE07,
saying that, each COM component should contain only 1 COM file, component
oleaut32.msm has more than 1 COM file.
Is there anyway we can distribute this VB6 component on a Vista machine?
Thanks! Tag: FileExists that works? Tag: 651486