Problem with Third Party DB: MS SQL SERVER 2008

[hacymurat]

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/networkpatterns.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/v2_1/3rd_party_database_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/details.aspx?familyid=f914793a-6fb4-475f-9537-b8fcb776befd&displaylang=en

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