Re: Syntax error or access violation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

SP look like this:

create procedure "sp_tmp_rn_tp"
@c1 numeric(10,0),
@c2 numeric(10,0),
@c3 numeric(10,0),
@c4 numeric(10,0),
@c5 numeric(10,0),
@c6 numeric(10,0),
@c7 datetime,
@c8 datetime,
@c9 datetime,
@c10 datetime,
@c11 char(1),
@c12 char(1),
@c13 char(1),
@c14 char(1),
@c15 char(1),
@c16 char(1),
@c17 char(1),
@c18 char(60)
as
begin
insert into "dbo"."tmp_rn_tp"(
"DBOWNER_ID"
,"CUSTOMER_ID"
,"PRODUCT_ID"
,"TIMEPLACE_ID"
,"CUS_DBOWNER_ID"
,"CUS_CUSTOMER_ID"
,"FROM_DATE"
,"TO_DATE"
,"FROM_TIME"
,"TO_TIME"
,"MONDAY"
,"TUESDAY"
,"WEDENSDAY"
,"THURSDAY"
,"FRIDAY"
,"SATURDAY"
,"SUNDAY"
,"NAME"
)
values (
@c1
,@c2
,@c3
,@c4
,@c5
,@c6
,@c7
,@c8
,@c9
,@c10
,@c11
,@c12
,@c13
,@c14
,@c15
,@c16
,@c17
,@c18
)
end

GO
"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:eynnBM5kGHA.4816@xxxxxxxxxxxxxxxxxxxxxxx
what does the proc sp_tmp_rn_tp look like?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Roger Nygård" <roger@xxxxxxxx> wrote in message
news:129d0ql20fr0k37@xxxxxxxxxxxxxxxxxxxxx
msSQL2000 sp4
Win2003 server

ERROR:
[Microsoft][ODBC SQL Server Driver]Syntax error or access violation

when I run this SP.


{CALL sp_tmp_rn_tp (260, 340, 1, 4, NULL, NULL,
{ts '2006-07-03 00:00:00.000'},
{ts '2006-08-13 00:00:00.000'},
{ts '2006-06-17 11:00:00.000'},
{ts '2006-06-17 15:00:00.000'},
''+{fn CHAR(0)}+'',
''+{fn CHAR(0)}+'',
''+{fn CHAR(0)}+'',
''+{fn CHAR(0)}+'',
''+{fn CHAR(0)}+'',
'1',
''+{fn CHAR(0)}+'',
NULL)}

The statement is from the Distribution database (sp_browsereplcmds) and
ment for a subdcriber (mssql2005)

But I got the same error localy when I create a test table and a test SP
and run it

what is wrong here?



Table look like this:
CREATE TABLE tmp_rn_tp (
[DBOWNER_ID] [T_NUM_ID] NOT NULL ,
[CUSTOMER_ID] [T_NUM_ID] NOT NULL ,
[PRODUCT_ID] [T_NUM_ID] NOT NULL ,
[TIMEPLACE_ID] [T_NUM_ID] NOT NULL ,
[CUS_DBOWNER_ID] [T_NUM_ID] NULL ,
[CUS_CUSTOMER_ID] [T_NUM_ID] NULL ,
[FROM_DATE] [T_DATE] NULL ,
[TO_DATE] [T_DATE] NULL ,
[FROM_TIME] [T_TIME] NULL ,
[TO_TIME] [T_TIME] NULL ,
[MONDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[TUESDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[WEDENSDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[THURSDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[FRIDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[SATURDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[SUNDAY] [char] (1) COLLATE Finnish_Swedish_CI_AS NULL ,
[NAME] [T_NAME] NULL
) ON [PRIMARY]








.