Jump to content

Recommended Posts

Posted

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

post-20721-1171756421_thumb.jpg

Posted

*** 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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...