Re: JDBC/ODBC user issues accessing SQL Server 2000 database

From: ITM (itm_at_manning.uk.com)
Date: 12/29/03

  • Next message: killerTomato: "Re: Servlet Threads Database Connections" 
    Date: Mon, 29 Dec 2003 11:50:36 GMT

    Thanks for your reply. Unfortunately this is a legacy database which
    is not administered by me - I just need to implement an application
    using JDBC and these tables which appear to be owner by user X.

    Presumably the only way I can work around this without the need to
    prexix the user name is to define views for all of the tables, using
    the basic table name as the view name?

    On Sat, 27 Dec 2003 14:31:49 +0200, Sampsa Sohlman
    <sampsa_sohlman@hotmail.com> wrote:
    >To avoud prefixes on table names, they have to be owned by 'dbo'.
    >
    >To change existing tables to dbo use sp_changeobjectowner procedure.
    >
    >Example: myuser.mytable -> dbo.mytable
    >
    >sp_changeobjectowner 'myuser.mytable', 'dbo'
    >
    >If you want to create these tables by default you need that user id that
    >you are using is configured for that. If you are sa level user it is
    >done automaticly, but if you want to use different user id, your user id
    >has to be made dbo, by using sp_changedbowner procedure. Your database
    >adminstrator has to execute that procedure to your user id.
    >
    >More information on SQL Server Books online.
    >
    >Other things :) There are quite good JDBC drivers from Microsoft
    >available to MS-SQL Server or you can try open source
    >http://jtds.sourceforge.net driver which is good. They are better option
    >than JDBC/ODBC bridge.
    >
    >Merry christmast and happy new year.
    >
    >Sampsa

  • Next message: killerTomato: "Re: Servlet Threads Database Connections"