clposter Posted February 17, 2007 Share Posted February 17, 2007 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 Link to comment Share on other sites More sharing options...
clposter Posted February 17, 2007 Author Share Posted February 17, 2007 *** 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 fineI 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.movenextmsgbox(0,"filed : ", $rs2.fields(1))$Conn3.Close$Conn3 = 0Now 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 Link to comment Share on other sites More sharing options...
Will66 Posted February 18, 2007 Share Posted February 18, 2007 msgbox(0,"filed : ", $rs2.fields(1).value) Link to comment Share on other sites More sharing options...
clposter Posted February 18, 2007 Author Share Posted February 18, 2007 msgbox(0,"filed : ", $rs2.fields(1).value)you da man!!!thanks for your quick help...not sure what went wrong... Link to comment Share on other sites More sharing options...
Will66 Posted February 18, 2007 Share Posted February 18, 2007 .value is what went wrong Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now