Brekeke Forum Index » Brekeke SIP Server Forum

Post new topic   Reply to topic
how can I use 3rd party DB on Windows MSSQL?
Author Message
Sunnyscx
Brekeke Newbie


Joined: 22 Oct 2012
Posts: 2
Location: Singapore

PostPosted: Mon Oct 22, 2012 9:36 pm    Post subject: how can I use 3rd party DB on Windows MSSQL? Reply with quote

1. Brekeke Product Name and version:

2. Java version:

3. OS type and the version:

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: my question is I plan to install the Brekeke on Windows server 2003 and I want to use the 3rd party DB with MSSQL. How can I configure it from the the Brekeke? who can give me a advice? Thanks

_________________
sunny
Back to top
View user's profile
Tata
Brekeke Master Guru


Joined: 27 Jan 2008
Posts: 223

PostPosted: Mon Oct 22, 2012 10:12 pm    Post subject: Reply with quote

Have you looked at this document?
http://www.brekeke-sip.com/download/bss/v2_x/3rd_party_database_en.pdf


For MSSQL, use Microsoft's JDBC Driver.
http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx
Back to top
View user's profile
Sunnyscx
Brekeke Newbie


Joined: 22 Oct 2012
Posts: 2
Location: Singapore

PostPosted: Mon Oct 22, 2012 10:29 pm    Post subject: Reply with quote

Tata wrote:
Have you looked at this document?
http://www.brekeke-sip.com/download/bss/v2_x/3rd_party_database_en.pdf


For MSSQL, use Microsoft's JDBC Driver.
http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx


Hi, Thank you for your advice. I were read the file already. However the file give is refer to use the MySQL. What I want to use is MSSQL and The Brekeke be installed at the Windows. So I want to make sure on this connection. Is it have to use JDBC at the Windows server instead of ODBC?

_________________
sunny
Back to top
View user's profile
Tata
Brekeke Master Guru


Joined: 27 Jan 2008
Posts: 223

PostPosted: Tue Oct 23, 2012 2:47 pm    Post subject: Reply with quote

The document said:
Quote:
The following sections are using MySQL as an example but other databases can be
used in a similar way.

So.. you should follow the document even if you use MSSQL but use MSSQL's JDBC driver.


> Is it have to use JDBC at the Windows server instead of ODBC?

Yes.
It must be JDBC not ODBC.
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    Brekeke Forum Index » Brekeke SIP Server Forum All times are GMT - 7 Hours
Page 1 of 1