• V20: 3CX Re-engineered. Get V20 for increased security, better call management, a new admin console and Windows softphone. Learn More.

connection to mssql

Status
Not open for further replies.

GMBİL

Customer
Joined
Jun 4, 2009
Messages
9
Reaction score
0
i need to get a number from sql but could not manage
instance name: SQLSERVER\INSTANCE
database name: database1
table: customer
user: username
password: password

i am trying to customernumberid from the table customer and from the database database1 with database instance SQLSERVER\INSTANCE

customernumberid consists of 2 numbers like 04 or 88 or 52

I am selecting Database Access Component and trying to figure out the options. What will be the eaxt statement for the options for the above given statements?

SERVER
PORT
DATABASE
USERNAME
PASSWORD
STATEMENT TYPE
TIMEOUT
SQL STATEMENT
PARAMETERS

Thanks
 
Hi @GMBİL

Please take a look at the following article which explains how to access a database from the CFD:
https://www.3cx.com/docs/cfd-accessing-database/

If you use an instance name, you might need to specify a connection string instead of each field separately. Here you have information on how to create your connection string:
https://www.connectionstrings.com/sql-server/

Also, please note that fields are expressions, so if you enter a constant value you need to add quotes, and escape some characters like the back slash, so for example to enter the instance name SQLSERVER\INSTANCE you will need to enter:
"SQLSERVER\\INSTANCE"

(with double slash)

If you open the Expression Editor and select the Constant String option, you can enter the plain string and the tool will escape it for you.

Kind regards.
 
I have managed to connect to database... What i want to learn this time is; we have a java script based ticketing web server. we create tickets for the incidents from the http web site. I can see that via webservice-post component in 3cx i should handle to send some posts to my ticketing web server which is SYSAID. so that users via pbx can create tickets directly. Is there any example for this?
Lets say after validation in 3cx i want 3cx to that validated number to the server in a query. in SYSAID documentation it seems like with "POST/sr?view={view_name}&type={sr_type}&template={template_id}" we can create a ticket within the database.
 
Status
Not open for further replies.
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.