Here is the entry I created in the bluedragon.xml to get it to work:
<datasource name="utilsdsn">
<password></password>
<servername></servername>
<sqldelete>true</sqldelete>
<sqlupdate>true</sqlupdate>
<username></username>
<drivername>sun.jdbc.odbc.JdbcOdbcDriver</drivername>
<sqlstoredprocedures>true</sqlstoredprocedures>
<sqlinsert>true</sqlinsert>
<sqlselect>true</sqlselect>
<connectiontimeout>120</connectiontimeout>
<drivertype>3</drivertype>
<port></port>
<databasename>utils</databasename>
<description>Microsoft Access Driver (*.mdb)</description>
<logintimeout>120</logintimeout>
<hoststring>jdbc:odbc:DRIVER={Microsoft Access Driver
(*.mdb)};DBQ=C:\utils\utils.mdb</hoststring>
<maxconnections>24</maxconnections>
<name>utils</name>
</datasource>
Then for one of my queries:
<cfquery datasource="utilsdsn" name="SQL_select_execute_times">
select ...
</cfquery>
-Josh
On Jan 17, 7:09 pm, btousson <[email protected]> wrote:
> Uh, guys? An interesting note...I hate to be the bearer of bad news,
> but I just thought I'd clean up the query and remove the .mdb from the
> cfquery - and gues what....????
> It can't even see the database when I do that. At least when I put in
> the .mdb, it reads the db:
>
> with .mdb at end of database in query:
>
> [
> Type Database
> Query Error No data found
> Datasource EHB_WEB_DATABASE.MDB
> Native Error Code 0
> SQL State
> SQL Select * From Blend_Info Where Retired_Blend = No
> Tag Context CFQUERY: Line=65; Column=1
> Source 62: <br><br><i>Select the Health Category of interest below or
> scroll down our product menu on the right. The product information
> will appear Below Menu Section. </i></font></td></tr></table></td></
> tr><tr>
> 63: <!--- These two local variables set up the read ability of the
> Blends page to read from the Blended Information Table 5-5-06 --->
> 64:
> 65: <cfquery name=Get_ProdMenu_Data datasource=EHB_Web_Database.mdb>
> 66: Select *
> ]
>
> without .mdb at end of database in query
> [
> Type Database
> Detail The datasource EHB_Web_Database could not be found or was
> invalid
> Extended Info javax.naming.NoInitialContextException: Need to specify
> class name in environment or system property, or as an applet
> parameter, or in an application resource file:
> java.naming.factory.initial
> Tag Context CFQUERY: Line=65; Column=1
> Source 62: <br><br><i>Select the Health Category of interest below or
> scroll down our product menu on the right. The product information
> will appear Below Menu Section. </i></font></td></tr></table></td></
> tr><tr>
> 63: <!--- These two local variables set up the read ability of the
> Blends page to read from the Blended Information Table 5-5-06 --->
> 64:
> 65: <cfquery name=Get_ProdMenu_Data datasource=EHB_Web_Database>
> 66: Select *
> ^ Snippet from underlying CFML source
> ]
>
> Now I'm really curious as to what else is different??? (smile)
>
> -belinda
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official site @ http://www.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
