Thanks for the help.
When you go to add a datasource through the control panel datasource
applet, there is no MS Access driver listed. The prevalant work-around is
to use the 32-bit datasource applet. (odbcad32.exe)
So I add the datasource with the 32-bit applet, which looks just like the
64-bit applet. (System DSN, like I've always done)
Check BD Admin to make sure the "Auto-Configure ODBC Datasources" is on,
then restart Tomcat/BD service.
No datasources show up in BD Admin.
So, in the interest of trying SOMETHING, I added this section, which I took
from a working 32-bit BD JX7 server, to the <cfquery> section of
bluedragon.xml:
<datasource name="kentecmaster">
<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>kentecmaster</databasename>
<description>Microsoft Access Driver (*.mdb)</description>
<logintimeout>120</logintimeout>
<hoststring>jdbc:odbc:kentecmaster</hoststring>
<maxconnections>24</maxconnections>
<name>kentecmaster</name>
</datasource>
Restart Tomcat/BD service...
Now the datasource is visible in BD Admin (Database Type = "Other"). But
when I click Verify, I get this error:
Could not verify datasource: [Microsoft][ODBC Driver Manager] The specified
DSN contains an architecture mismatch between the Driver and Application
And if I click to edit the datasource, I get the fields I would get for a
MySQL datasource.
I probably have the format of that xml entry wrong. I don't mind adding
them by hand, if I could get that right.
I don't know what to say about BD not being able to find it on it's own.
Again, much thanks!
C
On Monday, May 7, 2012 2:46:39 AM UTC-5, Confused wrote:
>
> I'm trying to run OBD on GoDaddy's cloud on 64 Bit W08.
>
> I need to connect a couple of dinky sites to MS Access DB's. (I know, I
> know...)
>
> To make any ODBC Datasource you have to use the 32-bit Datasource
> application on the server. (C:\Windows\SysWOW64\odbcad32.exe)
> But it doesn't seem that BD can see those to "Auto Configure" them.
>
> I got close by manually adding the datasource to the bluedragon.xml file,
> but I don't have a sample of a working datasource.
>
> Can anyone tell me how to make the ODBC datasources work in this
> situation...
>
> AND / OR..
>
> Provide a sample from bluedragon.xml for a working ODBC connection to an
> Access DB.
>
> Many Thanks,
> C
>
>
>
>
>
--
online documentation: http://openbd.org/manual/
google+ hints/tips: https://plus.google.com/115990347459711259462
http://groups.google.com/group/openbd?hl=en
