jdbc odbc bridge on linux
Hi All, I posted question about how to use Sun's jdbc.odbc bridge from jsp on linux to access SQL server on windows. because all examples I saw were using LOCAL dsn like jdbc:odbc:dsnName. but how to do it if the JSP is on linux and the SQL server is on a remote host. something like jdbc:odbc:@host:port:DB_name(or DSN)??? I am kind of confused!! TIA Jerry
Re: jdbc odbc bridge on linux
The jdbc odbc bridge requires an odbc driver on the local machine. The local datasource then points to the remote machine that the server is on, rather than the JDBC URL. The jdbc odbc driver is also not multi-threaded, so not a good choice for using with Tomcat. I'm not aware of any free jdbc drivers that will work with SQL Server, but there are a number of commercial solutions. I use the OPTA 2000 driver from www.inetsoftware.de. Hope this helps, Jim --- Jerry QU <[EMAIL PROTECTED]> wrote: > Hi All, > > I posted question about how to use Sun's jdbc.odbc > bridge from jsp on linux to access SQL server on > windows. because all examples I saw were using LOCAL > dsn like jdbc:odbc:dsnName. but how to do it if the > JSP is on linux and the SQL server is on a remote > host. > > something like jdbc:odbc:@host:port:DB_name(or > DSN)??? > > I am kind of confused!! > > TIA > > Jerry > > > > __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/
RE: jdbc odbc bridge on linux
Repost your question in plain text instead of RTF and I'll help you. Regards, Emir. -Original Message- From: Jerry QU [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 29, 2001 2:45 AM To: [EMAIL PROTECTED] Subject: jdbc odbc bridge on linux Hi All, I posted question about how to use Sun's jdbc.odbc bridge from jsp on linux to access SQL server on windows. because all examples I saw were using LOCAL dsn like jdbc:odbc:dsnName. but how to do it if the JSP is on linux and the SQL server is on a remote host. something like jdbc:odbc:@host:port:DB_name(or DSN)??? I am kind of confused!! TIA Jerry
Re: jdbc odbc bridge on linux
Emir Alikadic (ADNOC IS&T) at [EMAIL PROTECTED] wrote: > > Repost your question in plain text instead of RTF and I'll help you. It _was_ also in plaintext, and the second part of the mime was in HTML, not RTF... I'm not a fan of HTML, but, IMNSHO, this is just plain rude... Pier
RE: jdbc odbc bridge on linux
> -Original Message- > From: Pier P. Fumagalli [mailto:[EMAIL PROTECTED]] > Sent: Sunday, July 29, 2001 8:33 AM > To: [EMAIL PROTECTED] > Subject: Re: jdbc odbc bridge on linux > > > Emir Alikadic (ADNOC IS&T) at [EMAIL PROTECTED] wrote: > > > > Repost your question in plain text instead of RTF and I'll help you. > > It _was_ also in plaintext, and the second part of the mime > was in HTML, not > RTF... I'm not a fan of HTML, but, IMNSHO, this is just plain rude... > > Pier > What is rude was his posting on the list in format other than plain text. Read the list's FAQ if you don't understand. The number of fancy-formatted messages is on the rise and if we don't nip this in the bud, we may find ourselves in a position where folks who don't use the latest version of $MAILCLIENT are unable to read the messages. I myself use MS Outlook 2000 but I have no right to assume what the others are using. Hence the warning in the FAQ. This is not my first post on this topic and I'm afraid it won't be the last. I'm just trying to create awareness of the problem and I realise I sometimes have to resort to not-so-nice means to draw the subscribers' attention to it. If I can convince one person not to use formatted messages on the list, I'll be a happy man. I don't claim to be an all-knowing guru, but what I do know I will not share with those who are arrogant enough not to respect the rules of the list they're asking for help from. Regards, Emir.
RE: jdbc odbc bridge on linux
Here is a free JDBC Driver for MSSQL 7.0 http://www.thinweb.com/tw_download_twfreetds.html It is based on FreeTDS from www.freetds.org which also has it's own JDBC Driver. I don't know what differences they hold. I wouldn't say it is production quality. But it does do simple SELECT's etc. We have a few problems with it and thus use a commercial version also. Cheers. - Ramon -Original Message- From: Jim Seach [mailto:[EMAIL PROTECTED]] Sent: Sunday, 29 July 2001 10:12 AM To: [EMAIL PROTECTED] Subject: Re: jdbc odbc bridge on linux The jdbc odbc bridge requires an odbc driver on the local machine. The local datasource then points to the remote machine that the server is on, rather than the JDBC URL. The jdbc odbc driver is also not multi-threaded, so not a good choice for using with Tomcat. I'm not aware of any free jdbc drivers that will work with SQL Server, but there are a number of commercial solutions. I use the OPTA 2000 driver from www.inetsoftware.de. Hope this helps, Jim --- Jerry QU <[EMAIL PROTECTED]> wrote: > Hi All, > > I posted question about how to use Sun's jdbc.odbc > bridge from jsp on linux to access SQL server on > windows. because all examples I saw were using LOCAL > dsn like jdbc:odbc:dsnName. but how to do it if the > JSP is on linux and the SQL server is on a remote > host. > > something like jdbc:odbc:@host:port:DB_name(or > DSN)??? > > I am kind of confused!! > > TIA > > Jerry > > > > __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/
Re: jdbc odbc bridge on linux
On Sunday 29 July 2001 01:12 am, you wrote: > I'm not aware of any free jdbc drivers that will work > with SQL Server, but there are a number of commercial > solutions. I use the OPTA 2000 driver from > www.inetsoftware.de. Take a look at www.freetds.org -- Nils O. Selåsdal
Re: jdbc odbc bridge on linux
> > Emir Alikadic (ADNOC IS&T) at [EMAIL PROTECTED] wrote: > > > > Repost your question in plain text instead of RTF and I'll help you. > > It _was_ also in plaintext, and the second part of the mime was in HTML, not > RTF... I'm not a fan of HTML, but, IMNSHO, this is just plain rude... > > Pier > Actually, it wasn't in plain text if the reader uses elm, and possibly some other mailers that don't read MIME at all. Pine was able to turn the MIME into text, but it did strange things with the mailing list information. My vote would be [X] +1 -> Plain Text only. Strip HTML on the mailing list. but also no attachments. -- Sheryl CoppengerSEAS Computing Facility Staff [EMAIL PROTECTED] The George Washington University (202) 994-6853 http://www.seas.gwu.edu/~sheryl
RE: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
yes! > -Original Message- > From: Pier P. Fumagalli [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, July 29, 2001 10:42 PM > To: [EMAIL PROTECTED] > Subject: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc > bridge on linux) > > Emir Alikadic (ADNOC IS&T) at [EMAIL PROTECTED] wrote: > > > > What is rude was his posting on the list in format other than plain > text. > > Read the list's FAQ if you don't understand. > > I believe _I_ wrote that list FAQ. > > > The number of fancy-formatted messages is on the rise and if we don't > nip > > this in the bud, we may find ourselves in a position where folks who > don't > > use the latest version of $MAILCLIENT are unable to read the messages. > I > > myself use MS Outlook 2000 but I have no right to assume what the others > are > > using. Hence the warning in the FAQ. > > > > This is not my first post on this topic and I'm afraid it won't be the > last. > > I'm just trying to create awareness of the problem and I realise I > sometimes > > have to resort to not-so-nice means to draw the subscribers' attention > to > > it. If I can convince one person not to use formatted messages on the > list, > > I'll be a happy man. > > Awareness is created by asking KINDLY "Can you please not post > HTML-formatted messages to the mailing list" more or less as you did on > the > 25th (even though I believe that the list of "offenders" is so > ridiculous). > > If you don't want to see HTML in messages, simply ask to get it removed by > the mailing list owner (whops ME!), as we did on several others... > > > I don't claim to be an all-knowing guru, but what I do know I will not > share > > with those who are arrogant enough not to respect the rules of the list > > they're asking for help from. > > Ok then, try to be a little bit more polite and respectful or just shut > up. > > > > > One thing I can ask to you guys is, do you want me to strip HTML out of > your > messages and reject emails only with HTML content type? Plenary vote open > until 11:59 PM GMT of Monday 07/30/2001. > > [ ] +1 -> Plain Text only. Strip HTML on the mailing list. > [ ] 0 -> I don't give a damn shit. > [ ] -1 -> You mad? I love HTML in messages and want to keep using it. > > Thanks :) > > Pier
RE: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
[X] +1 -> Plain Text only. Strip HTML on the mailing list. [ ] 0 -> I don't give a damn shit. [ ] -1 -> You mad? I love HTML in messages and want to keep using it. New subscribers should be POLITELY (he he he!) directed to read the FAQ upon subscription.
Re: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
[X] +1 -> Plain Text only. Strip HTML on the mailing list. [ ] 0 -> I don't give a damn shit. [ ] -1 -> You mad? I love HTML in messages and want to keep using it.
RE: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
+0
Re: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
On Sunday 29 July 2001 10:42 am, you wrote: [snip...] > One thing I can ask to you guys is, do you want me to strip HTML out of > your messages and reject emails only with HTML content type? Plenary vote > open until 11:59 PM GMT of Monday 07/30/2001. > > [ >X<] +1 -> Plain Text only. Strip HTML on the mailing list. > [ ] 0 -> I don't give a damn shit. > [ ] -1 -> You mad? I love HTML in messages and want to keep using it. > I'd emphasize it more if I could. HTML also comes with it's share of security headaches for those with HTML enabled email clients. David Smith, CISSP Network Operations Supervisor Cornell University Department of Entomology 2121 Comstock Hall Ithaca, NY 14853 Phone: (607) 255-9571 Fax: (607) 255-0939 Email: [EMAIL PROTECTED]
RE: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
+1 for plain text -Original Message- From: Pier P. Fumagalli [mailto:[EMAIL PROTECTED]] Sent: Monday, July 30, 2001 4:37 PM To: [EMAIL PROTECTED] Subject: Re: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux) Pier P. Fumagalli at [EMAIL PROTECTED] wrote: > > [ ] +1 -> Plain Text only. Strip HTML on the mailing list. > [ ] 0 -> I don't give a damn shit. > [ ] -1 -> You mad? I love HTML in messages and want to keep using it. We got more than 20 +1s, a couple of 0s, and no -1. So I asked root to modify the mailing list... I'll keep you updated on how this is going to happen (maybe few hours, maybe few days!) :) Pier
Re: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
+1
Re: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
+1 from me.. no HTML email. - Original Message - From: "Srinivas Reddy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 31, 2001 6:56 AM Subject: Re: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux) > +1 _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com
RE: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
[SNIP] > > This is going the last message with HTML enabled on the > mailing list. :) > Remember to modify your settings :) Those are the rejected stuff: > - text/html > - text/rtf > - text/enriched > - text/x-vcard > > Pier > C'mon, Mary, our job here is done! [rides off into the sunset] On a serious note, I'd like to apologise to all of you who may have been offended in any way with my little crusade against the "Stylelized" messages. The end justifies the means, right? Regards, Emir. DISCLAIMER: The content of the preceding message is exclusively the personal opinion of the author, i.e. myself. Under no circumstances should the content be attributed to my employer.
RE: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
The next question could be: And for the attachments?!? ;) just kidding :) -Message d'origine- De : Emir Alikadic (ADNOC IS&T) [mailto:[EMAIL PROTECTED]] Envoyé : mardi 31 juillet 2001 12:32 À : [EMAIL PROTECTED] Objet : RE: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux) [SNIP] > > This is going the last message with HTML enabled on the > mailing list. :) > Remember to modify your settings :) Those are the rejected stuff: > - text/html > - text/rtf > - text/enriched > - text/x-vcard > > Pier > C'mon, Mary, our job here is done! [rides off into the sunset] On a serious note, I'd like to apologise to all of you who may have been offended in any way with my little crusade against the "Stylelized" messages. The end justifies the means, right? Regards, Emir. DISCLAIMER: The content of the preceding message is exclusively the personal opinion of the author, i.e. myself. Under no circumstances should the content be attributed to my employer.
Re: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
Jim Cheesman at [EMAIL PROTECTED] wrote: > At 12:32 PM 31/07/01, you wrote: > >> - text/x-vcard > > What, no vcards??? I used to be able to waste hours tracking down and > deleting the little buggers from my hard drive! Now what am I going to do > on a Friday afternoon... after defrag, anti-virus, cleanup etc. Next Friday, install a decent operating system :) Pier
Re: VOTE: HTML in Messages and politeness (Was: Re: jdbc odbc bridge on linux)
On Tue, 31 Jul 2001, Pier P. Fumagalli wrote: > Jim Cheesman at [EMAIL PROTECTED] wrote: > > At 12:32 PM 31/07/01, you wrote: > > > >> - text/x-vcard > > > > What, no vcards??? I used to be able to waste hours tracking down and > > deleting the little buggers from my hard drive! Now what am I going to do > > on a Friday afternoon... after defrag, anti-virus, cleanup etc. > > Next Friday, install a decent operating system :) Oh come on then he wouldn't be able to play that new game... whats it called? The red worm game or something isn't it (o: > > Pier > >