how can I use 3rd party DB on Windows MSSQL?

Sunnyscx · Post by **Sunnyscx** » Mon Oct 22, 2012 9:36 pm

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

Tata · Post by **Tata** » Mon Oct 22, 2012 10:12 pm

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

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

Sunnyscx · Post by **Sunnyscx** » Mon Oct 22, 2012 10:29 pm

Tata wrote:Have you looked at this document?
http://www.brekeke-sip.com/download/bss ... ase_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?

Tata · Post by **Tata** » Tue Oct 23, 2012 2:47 pm

The document said:

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.