Micros 3700 database connection

[RitwickGupta]

Hello,

Is there a way to connect to Micros 3700 database if you don't know the password? I just need to access the database, and ability to make changes to the database is not required. Is odbc the only way to do it?
Some machines do have "custom" and "support" as default username and password but it's not a proper solution. Please help

 

[pmegan]

Unless you're going to write your own application to run queries, yes, odbc is the only way to access the database.
I'm not quite sure what you mean about the "custom" or "support" accounts not being proper solutions. I've been using the "custom" user as my main database access for 15 years.

 

[Moregelen]

FYI - the custom and support users are being phased out, so he has a point about not relying on it. Micros has already (or are supposed to have at any rate) stopped creating any 'standard' users. They are all supposed to be uniquely generated passwords now. My company is following suite, so any program that connects to our database will need to be able to accept configuration for a username and password.

 

[RitwickGupta]

Hey, The new machines may not have custom and support as default username and password.

PS: What do you mean writing my own application to run queries? Don't I need to connect to the database even to run the queries by my own application? Is there a way of just accessing and copying the whole database without the need of a username and password?

 

[RitwickGupta]

I meant Yes not Hey

 

[Moregelen]

Sure, you can copy the whole database, but that won't give you access. You can't access it without credentials. But if you just want a copy that you can import into another RES install, use DM to create a backup and do a restore.

 

[RitwickGupta]

Then what did pmegan mean when he said "unless I am writing my own application"? From what I can see, there is no way to access the database without the username and password, but someone I know is doing they. Can't ask them coz they won't tell.

 

[Moregelen]

They aren't accessing it without a username and password, they are likely using the custom account. This account has been a standard for so long virtually every single Micros installation has it.

 

[Moregelen]

What she meant was that the only way to access the database locally with existing tools, or through something like SIM, is with ODBC. While you can connect using other methods, like OLEDB, you'd have to write your own application to do it.

 

[Moregelen]

Er. Or he. No idea on pmegan's gender. Just see Megan in PMegan ;D

 

[RitwickGupta]

I see. In that case, they might get into trouble if there is no custom account on the machine

 

[Moregelen]

Indeed. Most SIMs, including those listed on the Micros site, use this account without any way to correct if that account doesn't exist. Some of the SIMs are even encrypted, without using a CFG file for the connection username and password.

 

[RitwickGupta]

Haha. Sorry I just assumed that he is a male, or she is a male

 

[pmegan]

I'm a guy, my initials are PM. Mystery solved, lol.

By "write your own application" I meant that if you're writing something to run queries, you can connect using an OLEDB connection string rather than an ODBC connection. It's much easier to connect remotely that way.

Micros has stopped including the custom and support users by default, but when a database is upgraded they stay in place. You can always add those users through Database Manager if needed. New user accounts have read access on most of the tables, which will probably be enough in this case, but if you want anything more than that you need the dba password to grant privileges.

I've done a few jobs with a new user account, but those were by customer request. Until random generated passwords are mandatory, I'm going to continue the way I've been going. On any given day I'm and and out of sql and sybase central multiple times on 4 or 5 different databases, so random passwords just isn't feasible.