Setting Data Source with a .mdf?

Report · Apr 21, 2008

I'm not a developer so I won't even pretend to know what I'm talking about lol. 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 sucessful 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....

Thanks,

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.

Report · May 01, 2008

The .mdf extension is for a MS SQL Server database, so you would need to use the MS SQL Server database driver.