macromedia.coldfusion.database_access
[Top] [All Lists]

Re: Setting Data Source with a .mdf?

Subject: Re: Setting Data Source with a .mdf?
From: GArlington <garlington@xxxxxxxxxxxxx>
Date: Tue, 22 Apr 2008 03:00:15 -0700 (PDT)
Newsgroups: macromedia.coldfusion.database_access

On Apr 22, 3:51 am, "Heldhostage1" <webforumsu...@xxxxxxxxxxxxxx>
wrote:
> 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.

.mdf is MS SQL Server, NOT MS Access. So, use corresponding driver...

<Prev in Thread] Current Thread [Next in Thread>