Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Works in IDE but not in EXE

1 view
Skip to first unread message

AGP

unread,
Apr 5, 2002, 12:44:21 AM4/5/02
to
Ive almost completed my VB app which is a
DB viewer based on ADO. In the Visual Basic
IDE the project works great but then I build my EXE
and execute it and I get an error "Multiple-step OLE DB
operation generated errors. Check each OLE DB status
value if available. No work was done"

Anyone know what this is about and why the project works in
the IDE but not in an executable.

Im running VB6SP5, WinXPPro and ADO 2.7

tia
AGP


Ken Halter

unread,
Apr 5, 2002, 1:25:21 AM4/5/02
to
You seemed to have come across one of those errors that can mean one of a
hundred things <g>

One of these archived discussions may help..

http://groups.google.com/groups?hl=en&th=24fce2cb937b67de&rnum=2

http://groups.google.com/groups?hl=en&th=ffe0b41ebb2ad53&rnum=10

or....

FIX: Uninitialized String Variables, Empty String Values, Jet Provider, and
Errors Occurred (Q228935)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q228935

probably doesn't apply but...
BUG: Identity Field Remains Read-Only After Executing SET IDENTITY_INSERT ON
Statement (Q253157)
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q253157

Hopefully you'll already be up and running by the time you need to go
through these...
Searched Groups for "Multiple-step OLE DB" group:*.vb.*. Results 1 - 10 of
about 204
http://groups.google.com/groups?as_epq=Multiple-step%20OLE%20DB&as_ugroup=*.
vb.*&hl=en

--
Ken Halter
MS-MVP-VB
Please keep it in the groups..

AGP

unread,
Apr 5, 2002, 1:51:47 AM4/5/02
to
Hmmm...very odd. Ill try those links but at the point of loading
all Im doinf is importing the database with a connection like so:

strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DBfullPath &
";Persist Security Info=False;Jet OLEDB:Database Password=" & Pwd & ";"

and then I run a SQL as such
strSQl = "SELECT * FROM tblMyStuff " & _
"ORDER BY Num;"

No updating of fields...just loading a database.

thanx
AGP

"Ken Halter" <Ken_Halter@Use_Sparingly_Hotmail.com> wrote in message
news:O9iBnpG3BHA.2748@tkmsftngp07...

Mike Scirocco

unread,
Apr 5, 2002, 3:29:53 AM4/5/02
to
what is in the string DBfullPath? Is it a relative path?

AGP

unread,
Apr 5, 2002, 7:40:08 PM4/5/02
to
No its what it implies...the database full path & name.
Thanx
AGP

"Mike Scirocco" <ms...@yahoo.com> wrote in message
news:3CAD6081...@yahoo.com...

AGP

unread,
Apr 5, 2002, 10:35:47 PM4/5/02
to
I found the "bug"!!!!! I was in the process of making the
app have WinXp compatibility by making a manifest file.
Well i forgot to initialize the common control and thus when
i ran the EXE it was automatically set to Compatibility mode
for Windows 2000. Im developing in Windows XP so once
i turned the compatibilty mode off it worked like a charm.
It was so simple it was ridiculous!!!

Thanx for the help guys.
AGP


"AGP" <sindiz...@softhome.net> wrote in message
news:Itrr8.1398$CU....@rwcrnsc51.ops.asp.att.net...

0 new messages