j2EE server

sorry if this is only mildly on-topic, but the question straddles many topic areas, but this one primarily

I have the J2EE server running. I want it to talk to SQL Server 7, do I definitely need a third party driver suite or can this be done without (ie ODBC) by using j2EEadmin to describe the source?  
The J2EE docs are unclear, and the only products that I have been able to find are on limited license, or pay up-front.

thanks
simonm99Asked:
Who is Participating?
 
shyamkumarreddyCommented:
HI Simon
You can use your ODBC in J2EE evironment.
Your j2EE should run in Windows Environment

No configuration is required for ODBC

But if u use 3rd party then u need to configure ur environemnt according to that

*-----thanks for answering, but that does not answer my question - can I use ODBC connections (say, to SQL
server 7) WITHOUT using a third party driver?   ---*


Cheers
Shyam
0
 
shyamkumarreddyCommented:
Hi simonm

You can use ODBC or third party. NO probs which every u like. If u r using third party then u need to include this in your classpath of your j2ee.
If u r using the ODBC then u don't have any probs


shyam
0
 
simonm99Author Commented:
thanks for answering, but that does not answer my question - can I use ODBC connections (say, to SQL server 7) WITHOUT using a third party driver?  

The docs are quite vague about this and seem to give no examples of how to configure it. Any help appreciated as Cloudscape is a trial to use, at best.


0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
simonm99Author Commented:
thanks, I'll give it a try this evening.
0
 
simonm99Author Commented:
Shyam,

you mean by adding something like

jdbcDriver.1.name=sun.jdbc.odbc.JdbcOdbc

(where this class is located in 1.3/jre/lib/rt.jar) ?

if my ODBC ink is called "Titan" how do I format the addition of the datasource?

j2eeadmin -addJdbcDataSource <jndiname> <something>

thanks





0
 
simonm99Author Commented:
i say "average" as your statement "no configuration is required" proved to be incorrect although I appreciate your confirmation that it is possible to do it.

These lines (especially the last one) need to be added to the resource.properties file to make ODBC work for a System DSN ODBC link called "Titan"

jdbcDataSource.5.name=jdbc/Titan
jdbcDataSource.5.url=jdbc:odbc:Titan
// very important below vvvvvvv
jdbcDriver.1.name=sun.jdbc.odbc.JdbcOdbcDriver

but thanks for replying anyway
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.