Connection to the Database and Running SQL queries -

 
Author
Message
SysAider
1
 
Hi,

I would like to know how to connect to the database through SQL Server Management Studio and be able to run queries directly from some tables.

Below is part of the serverconf.xml file (of course this is not the real password....)

<serverConf>
<dbConf>
<dbDriver>net.sourceforge.jtds.jdbc.Driver</dbDriver>
<dbUrl>jdbc:jtds:sqlserver://localhost:1450/ilient;useCursorsAlways=true</dbUrl>
<dbUser>sa</dbUser>
<dbPassword>qwerty</dbPassword>
<dbType>mssql</dbType>
<dbCPType>TomcatCP</dbCPType>
<dbEncoding>utf-8</dbEncoding>
<dbMultiply>false</dbMultiply>
<dbMainName>ilient</dbMainName>


Can someone give me some help?

Thank you