Create Database Error ODBC SQL SERVER
-
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
-
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]
-
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.
-
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]
-
Marcus is right i think ..either the path doesn't exists or u dont have permission in that.
-
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
;
-
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 -
I did active all right for services, but again getting same error.
-
Try executing create table statement one by one..
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply