DSN Less connection to MSAccess not working

[clposter]

This was working yesterday.... Really ... it was...

$conn3 = ObjCreate ("ADODB.Connection")

$conn3.Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & "c:\climages\yahoo.mdb" & ";")

$rs2 = ObjCreate ("ADODB.Recordset")

$rs2.CursorType = 2

$rs2.LockType = 3

$rs2.open ("select * from ads", $conn3 )

$rs2.movenext

msgbox(0,"filed : ", $rs2.fields(1))

$Conn3.Close

$Conn3 = 0

Now I get funky weird characters back...

like like the extended character stuff...

I have included the screen shot of the code and the msgbox error that pops up.

it is a simple script to test connection...

thanks for any and all help in this matter.

Scott

[clposter]

*** steps I took to resolve the issue ***

By the way I am not EOF.

I can open the ms access table and view the data from the MS Access Program... it works fine

I even moved the code to another computer. same issue.

I created another database with another table entered code. same issue

*** steps I took to resolve the issue ***

This was working yesterday.... Really ... it was...

$conn3 = ObjCreate ("ADODB.Connection")

$conn3.Open ("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & "c:\climages\yahoo.mdb" & ";")

$rs2 = ObjCreate ("ADODB.Recordset")

$rs2.CursorType = 2

$rs2.LockType = 3

$rs2.open ("select * from ads", $conn3 )

$rs2.movenext

msgbox(0,"filed : ", $rs2.fields(1))

$Conn3.Close

$Conn3 = 0

Now I get funky weird characters back...

like like the extended character stuff...

I have included the screen shot of the code and the msgbox error that pops up.

it is a simple script to test connection...

thanks for any and all help in this matter.

Scott

[Will66]

msgbox(0,"filed : ", $rs2.fields(1).value)

[clposter]

msgbox(0,"filed : ", $rs2.fields(1).value)

you da man!!!

thanks for your quick help...

not sure what went wrong...

[Will66]

.value

is what went wrong