Hi When I try to connect my Access DB in CF Admin I receive the following error: Connection verification failed for data source: achieve_access java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'. Any Ideas on how to fix this problem. Thanks Jon
It sounds like you dont have the correct file path to your access database. Where is your access database stored?
I think it is in the right place CFusionMX7/wwwroot folder. I have another database (MySQL) in this folder and Coldfusion connects to it fine. I recall having to add the following code to get that to work though: JDBC URL: jdbc:mysql://127.0.0.1:3306/achieve_tuition Driver Class: com.mysql.jdbc.Driver I'm wondering if you need to do something similar to get the Access DB to connect? Also do you know if MySQL uses the Boolean (yes/no) data type? I am using Navicat software to work with my database and it won't recognise it but I thought MySQL used the Boolean data type. Hence my move to Access DB for this purpose - is there another way around this problem. I tried using an enum data type with "yes" "no" fields but this doesn't work either. Any ideas? Thanks Jon
Just double checking, when you added the access database to your CFMX7 admin did you select "Microsoft Access with Unicode" as your driver. I went and checked how I had my access database is configured and the only two thing I see is the file path and the driver type. My file path looks like this: C:\CFusionMX7\wwwroot\CFIDE\htdocs\db\register.mdb and driver type is : Microsoft Access with Unicode not sure this will help. I just switched to MYSQL about two months ago and I'm not real confident that I using it the best way. Although i will say it has opend so many doors for development. Anyway, I have accomplished a BOOLEAN type function by using the "bit" data type because the length can only be one character long. Then I just store everything in the column either as a 1 or a 0. Like I said though I'm not sure if this is the correct way to do this. Good luck and sorry I couldnt be more help. James
surfer_sven, I can only agree with unitedlocalbands' comments. What Driver Type did you select and what settings did you enter for you datasource? I don't use navicat, but their docs say MySql does not have the boolean type http://support.navicat.com/index.php?_a=knowledgebase&_j=questiondetails&_i=45 Which is interesting, because the MySql 5 docs say it does. But its really just storing a number anyway as unitedlocalbands described. So you could just use SMALLINT. http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html BOOL, BOOLEAN These types are synonyms for TINYINT(1). A value of zero is considered false. Non-zero values are considered true: I was going to suggest using BIT but it looks like it changed after v5.0.3. http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html BIT[(M)] Before 5.0.3, BIT is a synonym for TINYINT(1).
I would suggest that you do not store your databases under the webroot. If the db's are in web accessible folder, someone might be able to download them and there goes your security