cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
emad1989
Level 2

help with Error 27506.Error executing SQL script

[SIZE="3"]Hi guys

i'm trying to create a setup file using InstallShield 2010 for my project which uses sql server 2008

everything is ok all necessary programs is installed but when i try to install my project it will give this error

Error 27506.Error executing SQL script dbName.sql Line 9 Create Database failed. some file names listed could not be created Check related errors (1802)

i searched it says that my path in SQL script not existed but how to make Database to be created in installation folder of program itself

here first few lines of my SQL script

[CODE]USE [master]
GO

/****** Object: Database [InventoryDB] Script Date: 08/11/2012 19:01:00 ******/
CREATE DATABASE [InventoryDB] ON PRIMARY
( NAME = N'InventoryDB', FILENAME = N'C:\Inventory\DB\InventoryDB.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'InventoryDB_log', FILENAME = N'C:\Inventory\DB\InventoryDB_log.ldf' , SIZE = 2816KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

ALTER DATABASE [InventoryDB] SET COMPATIBILITY_LEVEL = 100
GO[/CODE]

please help [/SIZE]
Labels (1)
0 Kudos
(1) Reply
puneet404
Level 4

Hi,

In my opinion, the path in you SQL script "C:\Inventory\DB\" is not created yet. So First you have to allow Installer to create respective path.

I hope this helps.
0 Kudos