Forums Read-only archive

Problem with Third Party DB: MS SQL SERVER 2008

10 posts · Brekeke SIP Server Forum

hacymurat Original post
1. Brekeke Product Name and version: trial

2. Java version:windows

3. OS type and the version: xp

4. UA (phone), gateway or other hardware/software involved:

5. Select your network pattern from http://www.brekeke-sip.com/bbs/network/ ... terns.html :

6. Your problem: Hi, i have a softphone that i use brekeke for sip user registeration. I want to this registiration automatically. So i need to access db tables of brekeke. I found third party db access document on site for Mysql but i couldn't do this with SQL 2008.

Can anybody help me?

Thanks
taitan
which version of SIP Server are u using??

do you want to access a database to make a registiration?
does your softphone support REGISTER?
hacymurat
I use trial version of brekeke.

Yes I want to access a database to make a registiration. If i could ccreate and access db easily, i try to register on softphone's registiration form.

How can i access the db?

Thanks
taitan
if your client can send REGISTER, you don't have to access the database because the SIP Server can accept REGISTER requests and update the database.

what kind of SIP client are you using??
hacymurat
I developed my own client so i need to make registration automatically. For ex: If i send my softphone to somebody, i register him/her manually but i wanna access db and configure it with my web site db. So user can make his/her registration automatically.


How can i do this scenerio?
james
Hi hacymurat,

Do you have an account in Brekeke Dev Support? Ask Brekeke to send information if you are a developer.

Are you creating a SIP client based on RFC3261?
hacymurat
I use a SDK which was developed from pjsip, mine is Sipek SDK. I don't know anything about Brekeke Dev Support. What must i do? Also i have 2 days to present my project, have can i connect it with my database?

Thanks
james
Contact Brekeke (sales@brekeke.com) if you want to join Brekeke Dev Support.

Have you read Third-Party Database Tutorial?
http://www.brekeke-sip.com/download/bss ... ase_en.pdf

The document said: " The following sections are using MySQL as an example but other databases can be used in a similar way."
hacymurat
Thanks but i used this pdf when creating and trying to access db but i did some wrongs i think. Is there anybody who use MS-SQL?
james
For using MS SQL, you should install its JDBC driver.

http://www.microsoft.com/downloads/deta ... laylang=en

And follow the document.
You need to create tables in the database..