Can I create an Interbase User with IBProvider

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
LVL 4
James AtkinSenior Principle Software EngineerAsked:
Who is Participating?
 
zvytasCommented:
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
 
zvytasCommented:
0
 
James AtkinSenior Principle Software EngineerAuthor Commented:
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
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
James AtkinSenior Principle Software EngineerAuthor Commented:
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
 
zvytasCommented:
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
 
James AtkinSenior Principle Software EngineerAuthor Commented:
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
 
James AtkinSenior Principle Software EngineerAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.