Sign in to follow this  
Followers 0
clposter

DSN Less connection to MSAccess not working

5 posts in this topic

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

Share this post


Link to post
Share on other sites



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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

you da man!!!

thanks for your quick help...

not sure what went wrong...

Share this post


Link to post
Share on other sites

.value

is what went wrong :whistle:

Share this post


Link to post
Share on other sites

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
Sign in to follow this  
Followers 0