Setting a Data Source in ColdFusion 8 with .mdf extension.

Discussion in 'Databases' started by heldhostage, Apr 21, 2008.

  1. #1
    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.
     
    heldhostage, Apr 21, 2008 IP
  2. fyz

    fyz Peon

    Messages:
    1
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    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
     
    fyz, May 4, 2008 IP
  3. apmsolutions

    apmsolutions Peon

    Messages:
    66
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    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.
     
    apmsolutions, May 5, 2008 IP
  4. heldhostage

    heldhostage Peon

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Thanks for the help. I'm just going to hire a CF expert to set up my site lol.
     
    heldhostage, May 5, 2008 IP
  5. heldhostage

    heldhostage Peon

    Messages:
    29
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    If you know of any please let me know..
     
    heldhostage, May 5, 2008 IP
  6. apmsolutions

    apmsolutions Peon

    Messages:
    66
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    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?
     
    apmsolutions, May 5, 2008 IP