Solved

connect to sybase then query

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSIS On fail action 5 38
sql, case when & top 1 14 29
Error when creating a table from a function 6 20
Casting is giving error in sql server 3 12
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
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…

828 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