 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Java Forum / Databases / September 2007about connecting to a database
i am a faculty in NIIT, INDIA. i am working over ms-windows and sqlserver2000 as backend. i want to know if there is any way to connect to a database without creating a DSN(Data Source Name) which we have to create in-order to connect to a database. > i am a faculty in NIIT, INDIA. > i am working over ms-windows and sqlserver2000 as backend. > i want to know if there is any way to connect to a database without > creating a DSN(Data Source Name) which we have to create in-order to > connect to a database. If you are talking about an ODBC datasource then you would only do that if you where using the JdbcOdbc driver, which is really a bad idea. If you want to access SQLServer directly simply use the Jdbc driver from MS or use the jTDS driver. Both will work fine and allow you to connect to any SQLServer as long as it accepts connections via TCP/IP (which is not default, if I am not mistaken). Silvio Bierman On Thu, 27 Sep 2007 12:20:11 +0200, Silvio Bierman <sbierman@jambo-software.com> wrote, quoted or indirectly quoted someone who said : >If you want to access SQLServer directly simply use the Jdbc driver from >MS or use the jTDS driver see http://mindprod.com/jgloss/jdbc.html#CONNECTING  SignatureRoedy Green Canadian Mind Products The Java Glossary http://mindprod.com > i am a faculty in NIIT, INDIA. > i am working over ms-windows and sqlserver2000 as backend. > i want to know if there is any way to connect to a database without > creating a DSN(Data Source Name) which we have to create in-order to > connect to a database. Yes, most ODBC drivers support connecting without a DSN. Google for answers with "DSN-less connection". However, I must echo the advice of others, against using the standard JDBC/ODBC driver and for using a native JDBC driver. -- Lee Fesperman, FFE Software, Inc. (http://www.firstsql.com) ============================================================== * The Ultimate DBMS is here! * FirstSQL/J Object/Relational DBMS (http://www.firstsql.com) Free MagazinesGet these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...
|
Reply to this Message
|
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.