I'm not a developer so I won't even pretend to know what I'm talking about lol. I could really use some advice though. I've scoured the web looking for the answer to no avil. I just loaded CF 8.0 & DWCS3 and i'm trying to load an existing website that uses CF. I'm trying to set a data source and was successful with one of the sites that uses an .mdb extension. The other data source i'm trying to set is a .mdf extension. Is this why I am unable to set the data source and if so how do i fix it? I'm trying to set it on a MS ACCESS server??? if that helps.... I think .mdf extension is for SQL Server 2005?? I dunno i'm lost lol. Anyhelp would be greatly appreciated. This is the error; Connection verification failed for data source: connTownsend java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt. The root cause was that: java.sql.SQLException: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.
Hi, I think you should check your mdb file. If the file is damaged, you can try a utility called Advanced Access Repair to repair your Access MDB file. It works rather well for my corrupt Access MDB files. Hope this helps. Alan
Yes, .mdf is a sql server data file. You would need to use your SQL Server driver. So either choose SQL Server from your available drivers in Coldfusion Administrator, or set up an ODBC connection using a SQL server driver. Obviously, you would have to have SQL Server running.
I don't know if I would call any developer an expert as technology is always changing, but I am certainly advanced. What kind of web site are you setting up?