Solved

Can I create an Interbase User with IBProvider

Posted on 2011-09-06
7
376 Views
Last Modified: 2013-12-09
Hi all,

I would like to create a .NET application using IBProvider that will add users to an Interbase Database.
Any ideas how i can do this?
Any help would be appreciated.

Best regards,

James
0
Comment
Question by:jatkin
[X]
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
  • 4
  • 3
7 Comments
 
LVL 5

Expert Comment

by:zvytas
ID: 36489413
0
 
LVL 4

Author Comment

by:jatkin
ID: 36493819
Hi,

Thanks for the information. I have looked through the article, but it appears that you still need to specify a database to make a connection.
In my case, this is a new install with no database - I would like to connect to a server, add users and create a database...

Any ideas (or have I missed something in the article?)

Thanks...
0
 
LVL 5

Accepted Solution

by:
zvytas earned 500 total points
ID: 36493910
I never used Interbase before, but it should have some kind of "master" database. If that's the case your connection string should connect to the master database, which will allow to create database and users. After that's done you should be able to initiate a SQL command "use <database name>" which will connect to the newly created database.
Another option is to ship the empty database with your application. This would allow you to connect to it straight away and create users on the fly (user creation is described in the article I mentioned earlier).
0
Webinar: Choosing a MySQL HA Solution

Join Percona’s Principal Technical Services Engineer, Marcos Albe as he presents Choosing a MySQL High Availability Solution on Thursday, June 29, 2017 at 10:00 am PDT / 2:00 pm EDT (UTC-7).

 
LVL 4

Author Comment

by:jatkin
ID: 36493982
The application currently ships a 'default' database that is programmatically updated. I really wanted to remove this and create from scratch...
I have looked for a master database (I normally use MySQL which is simple!) but I cannot locate one.
I know it is possible to use some of the command line tools to create users, but it would be so much more 'graceful' to do this using some sort of connector...
0
 
LVL 5

Expert Comment

by:zvytas
ID: 36494192
Please read the article again - user creation is done with connector, NOT command line tools.
I think the best option for you would be ship completely empty database with a single user (so that app can connect to it). You can then connect to this empty database and initialise it, create users etc.
0
 
LVL 4

Author Comment

by:jatkin
ID: 36494763
Sorry, I wasn't clear...
I didn't mean that the article mentioned command-line, just that this looks like the only option to do what I am after. I wanted to avoid deploying a physical file as we support multiple versions of Interbase for our application.

I have actually just noticed that there is a file "admin.ib" in the root of the interbase installation. I will see if I can use this to connect to... if so, problem solved :-)
0
 
LVL 4

Author Closing Comment

by:jatkin
ID: 36707974
Basically, it looks like it is not possible to do what I am trying to do!
Interbase needs to use the command line tools for user administration.
I will do what you have suggested and ship an 'empty' database with the application and work with this...
Thanks for the help,
James
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…

729 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