Solved

connect to sybase then query

Posted on 2014-04-08
1
714 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
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how the fundamental information of how to create a table.

910 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now