Hmmmm...the line nibbler is back...here's Sam's post re: dsnless connections (I hope) ;-)
As earlier posters stated, DSN-less connections are no longer directly supported in CFMX because they are not supported in JDBC. However, there is an easy work around. Jet (MS Access database engine) supports a special use of the IN keyword in the FROM clause of a query to specify another source database. The secondary source can be a Jet (Access) database or any Jet accessible source (Excel, DBase, Text, etc.) or any ODBC connection (dynamic connect string). To set this up create an empty Access database and then create a datasource for this database named "PassThroughMDB". Then you can run queries like: <cfquery name="getFromDynamicConnection" datasource="PassThroughMDB"> SELECT * FROM some_table_in_another_db IN 'c:\wherever\other_database.mdb' </cfquery> You can experiment with paths to an MDB, XLS, etc. or you can use an ODBC connect string. To use ODBC I believe you have prepend it with ODBC; as in FROM wherever IN 'ODBC; [dynamic odbc connect string]' See MS Access help for more information. You can also view some examples in MSDN Library. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/htm l/acsqlINX.asp Another option is to create linked tables in the Access database. I know you can do this with DAO, and you may be able to do it with some combination of ADOX/JRO or even with DDL through CFQUERY. If using MSSQL or Oracle (and if so why would you need a dynamic connect string?) you can use linked databases (perhaps they use a different term, but the concept exists in both). Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Bryan Stevenson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, March 26, 2003 2:09 PM Subject: Re: Very odd behavior with data sources. please help if you can > I'm not sure what you're meaning by an ODBC connection so I'll just make > some suggestions ;-) > > 1) Use "Datasources (ODBC)" in control panel to add the datasource > > 2) There is a workaround for DSNless connections in MX but it's different > than previous CF versions. Sam Neff posted this for me a while back: > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
