AutoChris Posted October 11, 2006 Share Posted October 11, 2006 (edited) I am attempting to pull some information out of a MSSQL table with AutoIt. However, the data I get back just shows extended ASCII characters rather than the data I want. If I do an objName on the $adRS("column_name") it tells me it is a "Field" so I know it is seeing it properly. Here is an example of the code I am using: Local $adCN, $adRS $adCN = ObjCreate("ADODB.Connection") $adRS = ObjCreate("ADODB.Recordset") $adCN.Open("DRIVER={SQL Server};SERVER=SERVER_NAME;DATABASE=DATABASE_NAME;uid=user_name;pwd=password") $adRS.ActiveConnection = $adCN $adRS.Open("SELECT column_name FROM Table_Name") Do MsgBox(0, "SQL Test", $adRS("column_name")) Until $adRS.EOF $adRS.Close $adCN.Close Any thought on how I can get the info I need from the table? Edited October 11, 2006 by SerialKiller Link to comment Share on other sites More sharing options...
AutoChris Posted October 11, 2006 Author Share Posted October 11, 2006 *BUMP* Any ideas? Suggestions? Recommendations? Shots in the dark? Link to comment Share on other sites More sharing options...
Zedna Posted October 11, 2006 Share Posted October 11, 2006 (edited) *BUMP*Any ideas? Suggestions? Recommendations? Shots in the dark?Use search engine and type: ADODB.Recordsetyou will see how to work with Recordset ...EDIT: my lucky post number Edited October 11, 2006 by Zedna Resources UDF ResourcesEx UDF AutoIt Forum Search 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