2

I try generate dbml from sdf file.

So I localize sqlMetal util in: C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin

Sdf DB file path: D:\DB_TEST\Spiri_SQL_CE_DB.sdf

So I try this command on generate dbml file:

C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin>sqlmetal.exe D:\DB_TEST\
Spiri_SQL_CE_DB.sdf /dbml:D:\DB_TEST\Spiri_SQL_CE_DB.sdf\Spiri_SQL_CE_DB.dbml

I get this error:

Error : SQM1007: There is an IO error and the output file 'D:\DB_TEST\Spiri_SQL_
CE_DB.sdf\Spiri_SQL_CE_DB.dbml' cannot be opened.

So I try this command:

C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin>sqlmetal.exe D:\DB_TEST\
Spiri_SQL_CE_DB.sdf /dbml:Spiri_SQL_CE_DB.dbml

But I get this error:

Error : Access to the path 'C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\
Bin\Spiri_SQL_CE_DB.dbml' is denied.

On the end I try this version of command:

C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin>sqlMetal /dbml:Spiri_SQL
_CE_DB.dbml D:\DB_TEST\Spiri_SQL_CE_DB.sdf

But I get same error:

Error : Access to the path 'C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\
Bin\Spiri_SQL_CE_DB.dbml' is denied.

I know that file Spiri_SQL_CE_DB.dbml doesn’t exist yet, but I try generate with sqlMetal turil this file, what is bad?

Cœur
  • 37,241
  • 25
  • 195
  • 267

1 Answers1

1

Copy both the SDF and DBML to a location where you have sufficient write/modify rights.

Else start the command prompt with elevated permissions (aka runas administrator).

BTW your first attempt is completely bogus.

OR do:

sqlMetal /dbml:D:\DB_TEST\Spiri_SQL_CE_DB.dbml D:\DB_TEST\Spiri_SQL_CE_DB.sdf
leppie
  • 115,091
  • 17
  • 196
  • 297