I
tried your suggestion
conn.Open("Provider=SQLOLEDB.1;Driver={SQL
Server};server=NYMPH;database=dbCCDB_development;uid=test1;PWD=test1;");
it
still gives me the same error.
It
works when I run it in VB
--------Original Message-----
From: Steve Onnis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 13 July 2004 2:44 PM
To: CFAussie Mailing List
Subject: [cfaussie] RE: ADO in CFMX (still)you havent passed in the provider argument into the connection string which ADO required (pretty sure it does)ADOConn.Open( "Provider=SQLOLEDB.1;Driver={SQL Server};SERVER=.;UID=obscured;PWD=obscured;DATABASE=dbCCDB_development;");Steve--------Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Taco Fleur
Sent: Tuesday, July 13, 2004 2:09 PM
To: CFAussie Mailing List
Subject: [cfaussie] 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/
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/
Register now for the 3rd National Conference on Tourism Futures, being held in Townsville, North Queensland 4-7 August - www.tq.com.au/tfconf |
