CREATING DSN SQLSRVR BY PHYSICAL LOC PUBS.MDF

• ajashadi

  Ten Centuries

  Points: 1017

  More actions

  June 28, 2005 at 2:24 pm

  #87994

  Hi,

  I am using WinXP home with SQL SERVER 2000. I am able to create a System dsn and also successfully TEST IT by selecting a database from default database list which is given in 3rd window of DSN creation. I am not able to connect to SQL SERVER by using a SYSTEM DSN by specifying PHYSICAL PATH in the ATTACH DATABASE FILENAMEi.e. lets say C:\Program files\...\data\pubs.mdf. When I test this dsn by clicking the option TEST THE DATASOURCE button given while creating the DSN, I get this message when this setting is used

  default database to pubs.mdf & attach database filename to C:\...\MSSQL\Data\pubs.mdf

  Attempting connection

  [Microsoft][ODBC SQL Server Driver][SQL Server]Device activation error. The physical file name 'C:\...\MSSQL\Data\northwnd.mdf' may be incorrect.

  Disconnecting from server

  TESTS FAILED!.

  Another error When I specify default database to pubs & attach database filename to C:\...\MSSQL\Data\pubs.mdf

  Running connectivity tests...

  Attempting connection

  [Microsoft][ODBC SQL Server Driver][SQL Server]Could not attach database 'pubs' to file '"C:\...\MSSQL\Data\pubs.mdf"'.

  TESTS FAILED!

  Any suggestions are welcome.

  Thanks in advance.

  Ajas.

• David A. Long

  SSCrazy Eights

  Points: 8421

  More actions

  June 28, 2005 at 11:28 pm

  #569208

  There is no ODBC option for the SQL Server ODBC driver to connect to a file. Sounds like you are confusing Access and SQL Server.

  SQL Server is a server side engine that the ODBC driver connects to, this service always provides access to the database files.

  NOTHING else should ever try, else you run the risk of corrupting the database.

  Andy