Solved

Can I create an Interbase User with IBProvider

Posted on 2011-09-06
7
368 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
  • 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

This article describes some very basic things about SQL Server filegroups.
Creating and Managing Databases with phpMyAdmin in cPanel.
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…

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now