Create Database Error ODBC SQL SERVER

Question

Create Database Error ODBC SQL SERVER

mrs.cocomitius

SSC Rookie

Points: 28
More actions
November 7, 2007 at 1:51 am

#200236

Dear Friends,
I faced this error while I was creating new database (named it cm_empty) for Replication
What does this error means?
how will I resolve this error?
could you help to me, please?
Sincerly,
Error ScreenShot

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 1

Operating system error 5 means either the path does not exist, a file with the same name already exists or access is denied. So check the path and the filename and make sure the path already exists. Creating a database will create onle the files but not the folder structure.

Markus

P.S. I wouldn't advise to place database files on the C: drive

[font="Verdana"]Markus Bohse[/font]

mrs.cocomitius SSC Rookie Points: 28 More actions · Answer 2

Yes, error said that in (Access is denied).

but in Program's Replication Guide said that "You need to create database where installed Program setup "

I have got a cm_empty.sql file but I dont know, why there is this file and what will doing with this file?

Thanks for reply.

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 3

A .sql file is a sql script which in your case probably is used to create the database.

You can open it with a SQL Server client like Management Studio or Query Anlyzer or even Notepad if you don't have the client installed. Open the file and check for any paths references in it and when either change the path or at least make sure that the path(s) exist.

[font="Verdana"]Markus Bohse[/font]

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 4

Marcus is right i think ..either the path doesn't exists or u dont have permission in that.

mrs.cocomitius SSC Rookie Points: 28 More actions · Answer 5

Dear Friends,

There isnt path in file.

Table of contents cm_empty.sql file

if exists (select * from dbo.sysobjects

where id = object_id(N'[rep_Error]') and

OBJECTPROPERTY(id, N'IsUserTable') = 1)

begin

drop table [rep_Error]

end

;

CREATE TABLE [rep_Error] (

[id] [int] NOT NULL ,

[ErrorType_id] [int] NOT NULL ,

[TableName] [sysname],

[Error] [int] NULL ,

[ErrorMessage] [image] NULL ,

[ExecHost] [nvarchar] (30) NULL,

[ExecApp] [nvarchar] (128) NULL,

[ExecSQL] [text] NULL ,

[ExecDate] [datetime] NULL,

[Description] [image] NULL ,

CONSTRAINT [PKError_id] PRIMARY KEY([id])

)

;

if exists (select * from dbo.sysobjects

where id = object_id(N'[rep_Error_Delete]') and

OBJECTPROPERTY(id, N'IsUserTable') = 1)

begin

drop table [rep_Error_Delete]

end

;

CREATE TABLE [rep_Error_Delete] (

[id] [int] NOT NULL ,

[ErrorType_id] [int] NULL ,

[TableName] [sysname],

[Error] [int] NULL ,

[ErrorMessage] [image] NULL ,

[ExecHost] [nvarchar] (30) NULL,

[ExecApp] [nvarchar] (128) NULL,

[ExecSQL] [text] NULL ,

[ExecDate] [datetime] NOT NULL,

[Description] [image] NULL ,

CONSTRAINT [PKError_Delete_id] PRIMARY KEY ([id])

)

;

if exists(select * from [rep_Version])

begin

update [rep_Version]

set [version] = 3.02

end else

begin

insert into [rep_Version] ([version])

values (3.02)

end

;

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 6

Hi,

Kindly provide modify privilege to SQL service account to the path "C:\Program Files\Terrsoft CRMX25" and then try executing the script.

Regards..Vidhya Sagar
SQL-Articles

mrs.cocomitius SSC Rookie Points: 28 More actions · Answer 7

I did active all right for services, but again getting same error.

VastSQL SSC-Dedicated Points: 36121 More actions · Answer 8

VastSQL

SSC-Dedicated

Points: 36121

November 7, 2007 at 6:21 am

#749064

Try executing create table statement one by one..