[cfaussie] Re: ADO in CFMX (still)

[Pat Branley]

Title: ADO in CFMX (still)

Taco,   what about writing your VB App that returns XML as a string from a VB Com component ?   do your ADO specific stuff where it should live (in VB Code) and just call that from CF   <cfscript> myObj = createObject('com','myADOComObj');   strXML = myObj.getXMLString( param1, param2 .... ); </cfscript>   <cfoutput>#strXML#</cfoutput>   and your done!   Pat "Taco Fleur" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... yeah yeah month slate rI am still clowning around with ADO (I don't give up) Anyone ANY idea why ADOConn = createObject("com", "ADODB.Connection"); ADOConn.Open( "Driver={SQL Server};SERVER=.;UID=obscured;PWD=obscured;DATABASE=dbCCDB_development;"); Gives me An exception occurred when executing a Com method.      The cause of this exception was that: AutomationException: 0x80020005 - Type mismatch. in 'Provider'.           Before anyone asks (they always do when you mention ADO) its to get a stream from FOR XML in MS SQL (yup the topic I touched about 200 times on this list and 300 times elsewhere.)...... Register now for the 3rd National Conference on Tourism Futures, being held in Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/