[Opensource] OrangeTrader Expresso [ I Got The Flu ]

[Peter A. J. Pilgrim]

> ----- BEGIN FORM -----
> Name	sean
> Organisation	v2k
> Email	seanzhanglink at yahoo.com
> comments	Hi, peter
> you really did a great job. I got my first expresso lesson from your website. Thank you very much
> 
> 
> could you please help me check MSSQl 2000 for expresso?
> Here is my MSSQl configuration in Expresso:


I do not have MSSQL (Microsoft SQL Server). So I can help you
there. May be someone else on the mailing list can help?

I am sick with the bloody flu just reading direct mail and then
hitting the bed to sleep!


> <context name="default">
> 		<description>ms  Database</description>
>     <jdbc
>      driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
>      url="jdbc:microsoft:sqlserver://192.168.0.10:1433;databaseName=v2k"
>      connectFormat="1"
>      login="sa"
>      password=""
>      dateSelectFormat="dd-MM-yyyy"
>      dateUpdateFormat="dd-MM-yyyy"
>      dateTimeSelectFormat="yyyy-MM-dd"
>      dateTimeUpdateFormat="yyyy-MM-dd"
>      createTableIndicies="true"    
>      cache="y">
>      
>      <dbWildcard>%</dbWildcard>
>      <dbWildcard>*</dbWildcard>
>    </jdbc>
>  
>    
>    <type-mapping>
>      <java-type>LONGVARCHAR</java-type>
>      <expresso-type>text</expresso-type>
>      <db-type>text</db-type>
>    </type-mapping>
>  
>    <type-mapping> 
>      <java-type>DATE</java-type> 
>      <db-type>datetime</db-type> 
>    </type-mapping> 
>  
> 
> 
> <type-mapping> 
>      <java-type>TIMESTAMP</java-type>
> 	     <db-type>smalldatetime</db-type> 
>    </type-mapping> 
>    
>    <type-mapping> 
>      <java-type>DOUBLE</java-type> 
>      <db-type>NUMERIC</db-type> 
>    </type-mapping> 
>    
>    <type-mapping> 
>      <java-type>LONGVARCHAR</java-type>
>      <db-type>VARCHAR(1024)</db-type>
>    </type
> ----- END FORM -----
> 



-- 
Peter Pilgrim         +-----\ +-++----++----+
Java Technologist     |     | | ||    ||    | 'n' Shine
                       |  O  | | ||  --+| ---+
         /\            | ._  / | | \  \ |    |
        /  \           | | \ \ | |+--  || ---+ A new day
       /_  _\  "Up"    | | | | | ||    ||    | is coming
         ||            +-+ +-+ +-++----++----+
<home page="http://www.xenonsoft.demon.co.uk/" />