Hello!

I downloaded DBMail trial version and I see that database setup
for Sybase SqlAnywhere is grey. I this database supported or not?

Regards

It is supported in ASA versions 6.0 and later. Only email (w/o attachments), popup and net messages are supported in ASA at this time, faxes, attachments, and voice messages are not (because of the limited ASA features) .

You can either install the required back-end components manually by running "C:\Program Files\DB Mail2\Install Scripts\db_mail_install_syb_simple.sql" script or if you can connect to ASA using CTLib you can then select "Sybase ASE" option in the setup and it will install the required objects for ASA.

: Hello!

: I downloaded DBMail trial version and I see that database setup
: for Sybase SqlAnywhere is grey. I this database supported or not?

: Regards

Thanks for your answer.

I tried to run db_mail_install_syb_simple.sql but I have problems.

When I try to run this script

CREATE TABLE dbmail.pipe(
id NUMERIC(8, 0) IDENTITY NOT NULL,
message_type VARCHAR(50) DEFAULT 'EMAIL' NULL,
recipients VARCHAR(255) NULL,
subject VARCHAR(255) NULL,
message text null ,
options VARCHAR(255) NULL,
reply_to VARCHAR(255) NULL,
content_type VARCHAR(50) DEFAULT 'text/plain' NULL,
priority SMALLINT DEFAULT 0 NULL,
attachment_id NUMERIC NULL,
PRIMARY KEY (id) )

I get error that column name message and options are not allowed?

This words are reserverd words.

Regards

Tomaz

Tomaz,

I will check with support and get back to you.

: Thanks for your answer.

: I tried to run db_mail_install_syb_simple.sql but I have problems.

: When I try to run this script

: CREATE TABLE dbmail.pipe(
: id NUMERIC(8, 0) IDENTITY NOT NULL,
: message_type VARCHAR(50) DEFAULT 'EMAIL' NULL,
: recipients VARCHAR(255) NULL,
: subject VARCHAR(255) NULL,
: message text null ,
: options VARCHAR(255) NULL,
: reply_to VARCHAR(255) NULL,
: content_type VARCHAR(50) DEFAULT 'text/plain' NULL,
: priority SMALLINT DEFAULT 0 NULL,
: attachment_id NUMERIC NULL,
: PRIMARY KEY (id) )

: I get error that column name message and options are not allowed?

: This words are reserverd words.

: Regards

: Tomaz

Here is what I found, names "message" and "options" are reserved words in SQLAnywhere. In order to use them in the SQL as column names you must enclose them in double quotes

To create the pipe table use the following syntax

CREATE TABLE dbmail.pipe(
id NUMERIC(8, 0) IDENTITY NOT NULL,
message_type VARCHAR(50) DEFAULT 'EMAIL' NULL,
recipients VARCHAR(255) NULL,
subject VARCHAR(255) NULL,
"message" text null ,
"options" VARCHAR(255) NULL,
reply_to VARCHAR(255) NULL,
content_type VARCHAR(50) DEFAULT 'text/plain' NULL,
priority SMALLINT DEFAULT 0 NULL,
attachment_id NUMERIC NULL,
PRIMARY KEY (id) );

After you create this table you can verify if its working by executing the following SQL

INSERT INTO dbmail.pipe(message_type,
recipients,
subject,
"message",
reply_to)

VALUE ('EMAIL',
'put your email here',
'test subject',
'test message',
'put your email here');

: Tomaz,

: I will check with support and get back to you.