|Date Added:||15 November 2012|
|File Size:||12.38 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
How do we know which DSN is installed with software. I’d use a tool like squirel which is great at browsing any database to check if anyone was successful with “SQL Anywhere” this google result:. It’s quite easy to use This software was installed on their local server, including a patient database, sgbase schedule and all manner of medical records.
They do have an interactive query window, but obviously that’s no good for writing automated queries. Once we find a solution, we can post it here. My customer is a dental practice that has bought a piece of practice management software.
Justin Shafer: Eaglesoft 18 Beta Security
Like I mentioned before, Eaglesoft 19 has a locked-down version of the database. As far as I can tell, there’s no API for their software, and understandably they’re reluctant to tell me how to query the DB directly, programmatically.
Once you are in there, there’s an option to set a read-only password for access to the database. All the Eaglesoft clients at least back in the version ish days would create a database connection to the server and query directly rather than sending some data to the server process and getting a result. I use SQLWorkbench to copy the data from the production system into synase Postgres oebc so I can hack on it without damaging the production environment.
ShaulBehr Do you remember what kind of driver you used?
[Sybase][ODBC Driver][SQL Anywhere] Database server not found
The username is ‘dba’ and whatever password you set. To see database structure you can use the technical reference included in eaglesoft or advanced query tool. I installed nmap since winpcap can’t do localhost traffic, but don’t see anything using Wireshark. Turns out the simplest way eaglesofy do it was to write a little app using OdbcDbConnectionand connect using the DSN installed with the software. It sounds like you are trying to extort eaglssoft by holding our data hostage.
Looking at the ODBC. How to get at the database schema of a hidden DB? Can you explain how you used PHP to establish a connection with eaglesoft database please. Then I use Django’s inspectdb to generate models of the database environment. Also do we need any credentials to connect to the database?
I’d be happy to work with you on the issue as I had to deal with Eaglesoft for 10 years. I am trying to connect using RazorSQL and it is asking for database name and auth ocbc.
For read-only access you can call Patterson and ask them for the password to the “Database Admin” section of their “Technical Subase tool that is installed on your server. I’d use a tool like squirel which is great at browsing any database to check if anyone was successful with “SQL Anywhere” this google result: Code buried somewhere in an archived project.
I should probably run this by our eaglesofr team. This means the client signs in with a username and password.