Solved

Can I create an Interbase User with IBProvider

Posted on 2011-09-06
7
377 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:James Atkin
[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:James Atkin
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
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 4

Author Comment

by:James Atkin
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:James Atkin
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:James Atkin
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

Do you have a plan for Continuity?

It's inevitable. People leave organizations creating a gap in your service. That's where Percona comes in.

See how Pepper.com relies on Percona to:
-Manage their database
-Guarantee data safety and protection
-Provide database expertise that is available for any situation

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
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…

632 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