resetting a SQL Anywhere datasource password

Posted on 2003-03-11
Medium Priority
Last Modified: 2006-11-17
I inherited an application built in Powerbuilder that uses SQL Anywhere 5.0 as the database server.  I need to move the data out of Sybase and into Access or SQL Server as I am completely unfamiliar with Sybase.  I don't care about the application, just the data.

The Problem?  I can't get hold of the password used in the datasource because the developer is no longer involved or contactable.  I am an administrator on the machine.  Is there a way to reset or change this without knowing the existing password so I can import the tables into Access or SQL Server.
Question by:chris_insomniac
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

Accepted Solution

gletiecq earned 300 total points
ID: 8122131
I would look at the PowerBuilder source code to see how the transaction object is defined.  It should be specified in the DBParm member of SQLCA.  Can you get the application source code?

There is no way to get into a database without specifying a valid userid and it's corresponding password.  The default dba password is 'sql', and perhaps it was never changed, although that's very bad practice.

SQL Anywhere 5 is a good product, and I wouldn't abandon it just because you're unfamiliar with it.  If there's extensive use of triggers and stored procedures, you may not be able to sucessfully migrate to Access, and going to MS SQL Server might end up being a bigger headache than the minimal amount of learning that will be useful for managing SQL Anywhere.

LVL 17

Expert Comment

ID: 10337247
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: gletiecq {http:#8122131}

Please leave any comments here within the next four days.

EE Cleanup Volunteer

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

800 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