Problem with Third Party DB: MS SQL SERVER 2008

hacymurat · Post by **hacymurat** » Mon Mar 02, 2009 4:24 pm

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 · Post by **taitan** » Fri Mar 06, 2009 9:59 am

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 · Post by **hacymurat** » Sat Mar 07, 2009 11:20 am

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 · Post by **taitan** » Mon Mar 09, 2009 12:13 am

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 · Post by **hacymurat** » Mon Mar 09, 2009 7:24 am

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 · Post by **james** » Mon Mar 09, 2009 11:05 am

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 · Post by **hacymurat** » Mon Mar 09, 2009 12:52 pm

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 · Post by **james** » Tue Mar 10, 2009 3:07 pm

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 · Post by **hacymurat** » Tue Mar 10, 2009 4:13 pm

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 · Post by **james** » Thu Mar 12, 2009 2:46 pm

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..