Test Connection failed if "attach database filename" property was set

we use SQL Server 2005 Express.(download from 17.november.)
and tried to create a DSN that attaches a database file to server.
I created the datasource with the following configuration:

>Microsoft SQL Native Client Version 09.00.1399
>
>Data Source Name: sds
>Data Source Description: sds
>Server: (local)
>Use Integrated Security: No
>Database: mynorthwind
>Language: (Default)
>Data Encryption: No
>Trust Server Certificate: No
>Multiple Active Result Sets(MARS): No
>Mirror Server:
>Translate Character Data: Yes
>Log Long Running Queries: No
>Log Driver Statistics: No
>Use Regional Settings: No
>Use ANSI Quoted Identifiers: Yes
>Use ANSI Null, Paddings and Warnings: Yes
>Attach Database Filename: c:\porta\mynorthwind.mdf

A click on test connection results in the following error message:

>Microsoft SQL Native Client Version 09.00.1399
>
>Running connectivity tests...
>
>Attempting connection
>[Microsoft][SQL Native Client][SQL Server]Could not open new database 'mynorthwind'.
>CREATE DATABASE is aborted.
>[Microsoft][SQL Native Client][SQL Server]Could not attach file 'c:\porta\mynorthwind.mdf'
>as database 'mynorthwind'.
>
>TESTS FAILED!


The presence of original _log.LDF has no influence on the error
message.

If I use stored procedures to attach database, everything is ok.(same
user for login)
>EXEC sp_attach_db 'mynorthwind',N'c:\\porta\\mynorthwind.mdf',N'c:\\porta\\mynorthwind_log.ldf'

How can I create a DS that attaches a database?

regards

Steffen

.

Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: OLE DB connection string in SharePoint for Sybase ASA
    ... I wen to the Sybase site and found a reference to Connection String ... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > Server Error: An error occurred while retrieving the list of Databases ...
    (microsoft.public.frontpage.client)
  • Re: OLE DB connection string in SharePoint for Sybase ASA
    ... > where I WANT it to say Database Connections. ... > and up pops a Data Source Properties Window. ... > connection string" radio button and click on edit. ... > Server Error: An error occurred while retrieving the list of Databases ...
    (microsoft.public.frontpage.client)
  • Re: Copy database from development PC to deplyment server
    ... Release Management in the Analysis Services ... > to the sample database in my LAN. ... > developing/testing it, I'd like to copy it to the deplyment server, where ... > the data source. ...
    (microsoft.public.sqlserver.olap)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
Loading