SQLString := ‘select texttest, as decimaltest,datetest from testdata’ ĪDORecSet := ADOConnection.Execute(SQLString,RecordsAffected,RSOption) handling TYPICAL PROBLEM 1: spaces in result set names + ‘Initial Catalog=adotest User ID=sa Password=mynicepassword ’) don’t forget to modify this connectionstring to reflect YOUR setupĪDOConnection.ConnectionString(‘Provider=SQLOLEDB Data Source=MYNICEPC\MYNICESQLSERVER ’ use the latest version of ADO available to you – it will automatically convert to an older version if an older version isĮRROR(‘Cannot create ADO Connection automation variable.’) ĮRROR(‘Cannot create ADO Recordset automation variable.’) ĮRROR(‘Cannot create ADO Stream automation variable.’) ADOStream – Automation – ‘Microsoft ActiveX Data Objects 2.8 Library’.Stream ADORecSet – Automation – ‘Microsoft ActiveX Data Objects 2.8 Library’.Recordset ADOConnection – Automation -‘Microsoft ActiveX Data Objects 2.8 Library’.Connection Version List=ADO Test by Miklos Hollender
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |