JDBC to Microsoft SQL

Hi !

I am experiencing some problems with MSSQL (ver 8.0).

While I can execute sub-select statement directly on a MSSQL server,
I cannot do the same thing in JDBC.

Like the following statement( JDBC throws exception about mismatched
type)

select idcolumn,a,b,c FROM mytable WHERE idcolumn = (SELECT max
(idcolumn) FROM mytable

I could get the result other way too (like top 1 and descend sort
etc..), but this would be the fastest way and I want to use it.


I am connecting to database server without any settings, just IP,
username and password.

On mysql, I had a several options I could specify in a connect string,
so the server acts different.

Is there any setting I can specify which can help me ? Where can I
read all parameters I can specify when connecting via JDBC to Microsoft
SQL ?

Thx.
.

Relevant Pages

  • Re: JDBC to Microsoft SQL
    ... > I am experiencing some problems with MSSQL. ... > While I can execute sub-select statement directly on a MSSQL server, ... > I am connecting to database server without any settings, just IP, ... > Is there any setting I can specify which can help me? ...
    (comp.lang.java.programmer)
  • Java and Microsoft SQL
    ... While I can execute sub-select statement directly on a MSSQL server, ... I am connecting to database server without any settings, just IP, ... Is there any setting I can specify which can help me? ...
    (comp.lang.java.databases)
  • Re: Email Programming using System.Web.Mail
    ... With System.Web.Mail,, the book for the SmtpMail class says that if you do not specify a value for SmtpServer then it uses the local SMTP server. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Email Programming using System.Web.Mail
    ... configuration first but if that doesn't specify the appropriate ... configuration files, an exception would be thrown when you call the ... The moment I specify a valid server then it works: ... It will only connect to an 'up-line' SMTP ...
    (microsoft.public.dotnet.languages.vb)
  • Multiple Pointers, Xinput and thin clients (remote X)
    ... I have a thin client connecting to a X terminal ... server using XDMCP and gdm. ... # Module section -- this section is used to specify ... # the way multiple screens are organised. ...
    (comp.os.linux.x)