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

Can I create an Interbase User with IBProvider

Posted on 2011-09-06
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,

Question by:jatkin
  • 4
  • 3

Expert Comment

ID: 36489413

Author Comment

ID: 36493819

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?)


Accepted Solution

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).
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.


Author Comment

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...

Expert Comment

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.

Author Comment

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 :-)

Author Closing Comment

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,

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

808 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