Re: Dabse IV,VB6 and Vista

George M. wrote:
> Hi!
> 
> This my first time and I hope someone can help.
> 
> Has anyone seen this error? This is from the Event viewer
> 
> Faulting application Payments.exe, version 1.0.0.0, time stamp 0x459e91a7,
faulting module msxbde40.dll, version 4.0.9635.0, time stamp 0x450b3683,
exception code 0xc0000005, fault offset 0x0003f365, process id 0xdb0,
application start time 0x01c730f326a164c7.
> 
> I have vb6 (SP6) loaded on Vista Business. My program works fine under XP
but under Vista it is unstable (ie works sometimes and other times its fine)
> 
> I get the same message every time the program fails regardless where it
fails (in different places).
> 
> Code sample
> 
>     Dim lsSQL               As String
>     Dim rs                  As ADODB.Recordset
>     Dim cnr                 As ADODB.Connection
>     Dim lsFileName          As String
>  
> 
>    Set rs = New Recordset
>        
>     Set cnr = New ADODB.Connection
>     cnr.ConnectionString = gsConnection
>     cnr.Open
>     
>     
>     lsFileName = gsDBPath & gsCompanyCode & "PSHID"
'& ".dbf"
>     
>     lsSQL = "Select PSHDNUM,PSHDSTK,PSHDDES,PSHDPRICE from "
& lsFileName & " where PSHDINVNO= '" &
frmPayments.txtInvoNO & "' order by 1,2"
> 
>     Set rs = cnr.Execute(lsSQL)
> 
> It dies on the execute statement. Kicks me out of the program completely
(whether in the exe or in debug mode).
> 
> I have tried different connection strings. No luck.
> I played with the code. Made sure I close the recordset and connection
objects before releasing the objects.
> 
> What I have noticed is that I have to attempt to run 3 times and then it
often works on the 4th attempt.
> To get it to work completely I may have to restart 10 times and it might
run smoothly. I may restart the
> program and it may start funky again
> 
> I have tried different version of Microsofts ADO 
> 
> Any ideas?
> 

Well, first, what *software* are you using? If it is Visual BASIC, we 
can't help you ... this is not a set of Visual Basic forums, but forums 
specific to the software called "dBASE". If you need VB support, you 
should check the Microsoft websites. Sorry ...

Ken

-- 
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase/dBASEBooks.htm

Hi!

This my first time and I hope someone can help.

Has anyone seen this error? This is from the Event viewer

Faulting application Payments.exe, version 1.0.0.0, time stamp 0x459e91a7,
faulting module msxbde40.dll, version 4.0.9635.0, time stamp 0x450b3683,
exception code 0xc0000005, fault offset 0x0003f365, process id 0xdb0,
application start time 0x01c730f326a164c7.

I have vb6 (SP6) loaded on Vista Business. My program works fine under XP but
under Vista it is unstable (ie works sometimes and other times its fine)

I get the same message every time the program fails regardless where it fails
(in different places).

Code sample

    Dim lsSQL               As String
    Dim rs                  As ADODB.Recordset
    Dim cnr                 As ADODB.Connection
    Dim lsFileName          As String
 

   Set rs = New Recordset
       
    Set cnr = New ADODB.Connection
    cnr.ConnectionString = gsConnection
    cnr.Open
    
    
    lsFileName = gsDBPath & gsCompanyCode & "PSHID" '&
".dbf"
    
    lsSQL = "Select PSHDNUM,PSHDSTK,PSHDDES,PSHDPRICE from " &
lsFileName & " where PSHDINVNO= '" & frmPayments.txtInvoNO
& "' order by 1,2"

    Set rs = cnr.Execute(lsSQL)

It dies on the execute statement. Kicks me out of the program completely
(whether in the exe or in debug mode).

I have tried different connection strings. No luck.
I played with the code. Made sure I close the recordset and connection objects
before releasing the objects.

What I have noticed is that I have to attempt to run 3 times and then it often
works on the 4th attempt.
To get it to work completely I may have to restart 10 times and it might run
smoothly. I may restart the
program and it may start funky again

I have tried different version of Microsofts ADO 

Any ideas?

Ken,

It looks to me like he's trying to access some dbase tables from Visual 
Basic.

However, we need more info to help in...

- Marty -

Martin Kay
dataBased Intelligence, Inc.