Solved

connect to sybase then query

Posted on 2014-04-08
1
798 Views
Last Modified: 2014-04-21
I am a SQL Server DBA that has never used Sybase. We have a Sybase server (administrated by a vendor) that I need to run some SELECT queries on. I know SQL Server well. I just need some help figuring out how to connect and query a Sybase db. First, I tried to connect. Here's the error I got: "Could not connect to the database; Login mode 'Integrated' not permitted by login_mode setting. You must give a username. I tried Supply userID and password and the Integrated Login". Neither worked, as predicted. It seems to me that I need to get username/password credentials from the vendor.

These are the steps I implemented:

01. i clicked SQL Anywhere 11
02. once clicked, the db server says Running
03. then i clicked Connect to a database
04. i clicked Server name -> Find
05. Sybase looked for servers
06. Sybase showed three servers, one of which is my target
07. i don't know the db name but there's a field called Datbase name and Database files
08. i didn't have either dbname or dbfiles so i just clicked OK

Do I need credentials from the vendor/SQL Admin? All I got was a Windows account from our internal Systems Administrator to get me on the box. After I get authenticated how do I view a list of dbs on the server? Then how would I run a SELECT statement?

Hopefully, I provided enough info. I have about 10-minutes of Sybase experience.

Thanks,

pae2
0
Comment
Question by:pae2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 500 total points
ID: 40008992
You will need a user name and password, yes. You can try the defaults - DBA/SQL - but I hope vendors aren't selling embedded databases using default passwords. :)
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question