This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- help with Error 27506.Error executing SQL script
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Aug 11, 2012
04:07 PM
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]
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]
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Sep 02, 2012
03:10 AM
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.
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.