![]() ![]() NONE of the above worked but the following did Open VB6 Un-Installing VB6 and re-Installing (this I thought was a last resort) The problem was occurring on a new project and not just existing ones. Manually editing the vbp file (after making it writeable) to amend/remove the references and generally fiddling. Installing the distributable version of the project. (through source safe)Ĭopying the OCX files from a machine with no problems and registering those. Unregistered and re-registering MSCOMCTL, MSCOMCTL2 and the barcode active X controls in every directory I could think of trying (VB98, system 32, sysWOW64, project folder.)ĭeleting working folder and getting everything again. VB6 Win7 64 bit and have come across a very simple solution, so I figured it would be a good idea to share it here in case it helps anyone else.įirst I have tried the following with no success: to handle the : Automation “:’Microsoft ActiveX Data Objects 2.8 Library’.I have been having the same problem. functions like EVALUATE, DT2DATE, COPYSTR, CONVERTSTR, DELCHAR etc. and then you can use normal string manipulation IF (‘datetest’).Value.ISDATE THEN BEGINĪDOStream.WriteText((‘datetest’).Value) IF (‘decimaltest’).Value.ISDECIMAL THEN BEGINĪDOStream.WriteText((‘decimaltest’).Value) Handling TYPICAL PROBLEM 3: conventing binary ADO data to Navision text dataĪDOStream.WriteText((‘texttest’).Value) so I think we can just stick to this uglier, but safer method maybe something is not installed on my PC although an ADOField variable would be nicer, but I could not instantiate that, handling TYPICAL PROBLEM 2: null values 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 |