Title: Message
Yep Pretty much.
 
They are an absolute pain to debug. since you need to restart servers n such each time your re-register
 
heres a tutorial on how to create a VB Dll for ASP
 
Pat
 
 
 
 
 
"Taco Fleur" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]...
That sounds cool, I haven't touched VB in years and probably would need to do a bit of brushing up to do that, but certainly not a bad idea...
How difficult do you reckon this is? What's involved?
 
Is it as easy as opening a new project VB component, paste the code, save it, register it and call it?
 
 
Taco Fleur

Tell me and I will forget
Show me and I will remember
Teach me and I will learn
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pat Branley
Sent: Tuesday, 13 July 2004 5:15 PM
To: CFAussie Mailing List
Subject: [cfaussie] Re: 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/
---
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/

Reply via email to