mrtk421 has asked for the wisdom of the Perl Monks concerning the following question:

Fellow Mongers, I have exhausted all resources in an attempt to access.. I have a Sybase ASA instance and I'm trying to connect to it via Sybase Central. I'm creating a DSN to to connect to this instance. However, I do not know the database name. I have the location of the dbf file, but that's about it. Are there some command line utilities for me to determine it's name?

Replies are listed 'Best First'.
Re: DBI::DBD /siebel/sybase
by Ninthwave (Chaplain) on Jun 02, 2004 at 17:21 UTC

    I have not clue but did a quick search and this looks like it might answer your question, though not having the specific software, I can not confirm.:
    http://linux.co.uk/Pages/howtos/Sybase-ASA-HOWTO.html#AEN576

    Scroll down to the ODBC information for setting up dsn's this could be reverse read to see current dsn settings.

    Update:
    Sybase manual resource 1
    Resource 2
    Resource 3
    Show how to get the database properties from Sybase central and with the above I think you can find the name the server uses to represent the databases.

    "No matter where you go, there you are." BB
Re: DBI::DBD /siebel/sybase
by mpeppler (Vicar) on Jun 02, 2004 at 17:41 UTC
    I think this question would be more appropriately posted in one of the sybase.public.sqlanywhere.* newsgroups, available on the news://forums.sybase.com news server, or via the web at http://www.sybase.com/detail/1,6904,1002557,00.html, as you are more likely to get answers specific to Sybase ASA that aren't really related to perl there...

    Michael

Re: DBI::DBD /siebel/sybase
by jfroebe (Parson) on Jun 02, 2004 at 18:01 UTC

    Hi,

    The database name is the filename minus the extension (mydb.dbf is "mydb" database) for Sybase SQL Anywhere (ASA) databases.

    Michael is correct to recommend news://forums.sybase.com/sybase.public.sqlanywhere.general as this is not at all Perl related.

    Jason L. Froebe

    No one has seen what you have seen, and until that happens, we're all going to think that you're nuts. - Jack O'Neil, Stargate SG-1