[Solved] Connecting my ms sql and AOO Base

[jenny143]

hi im trying to connect my ms sql server and Apache open office base

i already follow this steps:
http://www.finefrog.com/2008/04/14/conn ... officeorg/

and change my port and IP to my IP and to 1433
http://support.webecs.com/KB/a375/how-d ... emote.aspx

but my output is:
Network Error IOException: Connection refused: connect

[Robert Tucker]

I've not much experience with MS databases, but can you connect to MSSQL with any other application, from a command prompt for example?

[r4zoli]

Try ODBC connection.
Or try MSSQL JDBC driver: http://forum.openoffice.org/en/forum/vi ... 642#p70642

[jenny143]

thanks for the replies

i already try it from my VB 6.0, and still working
but when i migrate to base... its not working for me

Try ODBC connection.
Or try MSSQL JDBC driver: viewtopic.php?f=20&t=15133&p=70642#p70642

when i try to test the class, the JDBC driver could not be loaded..
i think the Microsoft JDBC Driver 4.0 for SQL Server is not working

net.sourceforge.jtds.jdbc.Driver is still bettter than this (working driver) but connection refused

[Robert Tucker]

Are you running mssql on the local machine? Have you seen this thread:

https://answers.atlassian.com/questions ... nfiguation

[Robert Tucker]

Have you tried telnet:

To check whether TCP/IP is enabled and the port is not blocked you can use "telnet <server_host> 1433"

http://www.digipedia.pl/usenet/thread/13899/13430/

[jenny143]

when i change my IP10, IP1, IP2, IP5 to my IP Address from my TCP/IP and restart,

everything works fine now..

i think a restart is a solution... ?


thanks for your replies