Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Installation for DatabaseMetaData

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-04-15 17:37:01.0Z
Brad Burton Posted on 1997-04-10 14:11:11.0Z
Message-ID: <334CF4FF.2F70@ca.uky.edu>
Date: Thu, 10 Apr 1997 10:11:11 -0400
From: Brad Burton <bburton@ca.uky.edu>
X-Mailer: Mozilla 4.0b2 (Win95; I)
MIME-Version: 1.0
Subject: Installation for DatabaseMetaData
X-Priority: 3 (Normal)
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Newsgroups: sybase.public.jdbcconnect
Lines: 16
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:1039
Article PK: 252792

I have just obtained a trial version of jConnect and need help. I have
installed the JDBC driver and was successful to the point of installing
the stored procedures.

IsqlApp -U user -P pass -S server:port# -I sql_server.sql -c go

When running the above command, I receive many errors regarding
"sso_role". Do I need my database admin to install the procedures? If
not, what should I ask the admin to do in order for me to install the
procedures?

I really need to get the getTables, getColumns DatabaseMetaData methods
to work for me. Any help will be greatly appreciated.

Brad Burton


David Clegg Posted on 1997-04-15 17:37:01.0Z
Message-ID: <3353BCBD.6036C3CD@sybase.com>
Date: Tue, 15 Apr 1997 10:37:01 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Brad Burton <bburton@ca.uky.edu>
Subject: Re: Installation for DatabaseMetaData
References: <334CF4FF.2F70@ca.uky.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 19
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:1002
Article PK: 252753

Yes, the script MUST be run as "sa" to properly install the metadata
support.

dave

>
> I have just obtained a trial version of jConnect and need help. I have
> installed the JDBC driver and was successful to the point of installing
> the stored procedures.
>
> IsqlApp -U user -P pass -S server:port# -I sql_server.sql -c go
>
> When running the above command, I receive many errors regarding
> "sso_role". Do I need my database admin to install the procedures? If
> not, what should I ask the admin to do in order for me to install the
> procedures?
>
> I really need to get the getTables, getColumns DatabaseMetaData methods
> to work for me. Any help will be greatly appreciated.
>
> Brad Burton