Title: ADO in CFMX (still)

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.)......

---
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/
Register now for the 3rd National Conference on Tourism Futures, being held in Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf



Reply via email to