Database interface question

[taylor34]

Hey--

Some of you probably saw my question yesterday about sql, and after doing some more research today I figured out that I had a misunderstanding on what the current database products do. I was thinking that products like sql server 2005 were an all in one solution, that allowed you to create the database and then make the forms to interface with it. Seems like that's not true, it's just the database (as far as I can tell). In any case, that's why my questions seemed way off base yesterday. 🙂 So I guess now I need to know, what's a recommended windows interface for making an application with forms to attach to the database? I thought I read that you could use visual C or Basic to do it, but I'm guessing that there's probably a better or easier way to do it. Thanks for sticking with me, I'm trying to figure this out but when you only can work on it late at night it's slow goin', lol.

Taylor34

 

[WildHorse]

I'm not EXACTLY sure about your question.

There's preactically a whole mini-industry worth of companies making GUIs that you can use with various database brands, to design and manage your DB. Too many to list. Some make a single product that works across several database brands, and others make different varations to interface with particular DB brands. Then there are the tools packaged with the database systems themselves.

Just a few from a much larger constellation are:

Quest Software's TOAD
MySQL Query Browser
DBManager
Navicat
SQLyog
EMS Hitech
DBDesigner4
DbVisualizer
MaxDB
DBTools Manager
phpMyAdmin
SYBASE Power Designer

There are a lot more, many are free. Check out TOAD.

 

[KLin]

Microsoft Access
.NET programming languages (C#, VBA.NET, ASP.NET)
PHP
etc. etc. etc.

 

[taylor34]

Originally posted by: scott
I'm not EXACTLY sure about your question.

There's preactically a whole mini-industry worth of companies making GUIs that you can use with various database brands, to design and manage your DB. Too many to list. Some make a single product that works across several database brands, and others make different varations to interface with particular DB brands. Then there are the tools packaged with the database systems themselves.

Just a few from a much larger constellation are:

Quest Software's TOAD
MySQL Query Browser
DBManager
Navicat
SQLyog
EMS Hitech
DBDesigner4
DbVisualizer
MaxDB
DBTools Manager
phpMyAdmin
SYBASE Power Designer

There are a lot more, many are free. Check out TOAD.

Yep, that's exactly what I was looking for--recommendations on a good product to use for someone that's inexperienced with database interfacing. I've used QT before at work, but that's more for C++ gui development than database stuff. You're right, there are tons of them out there, but trying to find out which one is the best is difficult. Thanks

Taylor34

 

[taylor34]

Originally posted by: scott
I'm not EXACTLY sure about your question.

There's preactically a whole mini-industry worth of companies making GUIs that you can use with various database brands, to design and manage your DB. Too many to list. Some make a single product that works across several database brands, and others make different varations to interface with particular DB brands. Then there are the tools packaged with the database systems themselves.

Just a few from a much larger constellation are:

Quest Software's TOAD
MySQL Query Browser
DBManager
Navicat
SQLyog
EMS Hitech
DBDesigner4
DbVisualizer
MaxDB
DBTools Manager
phpMyAdmin
SYBASE Power Designer

There are a lot more, many are free. Check out TOAD.

Actually, now that I've looked through some of those, I think I gave off the wrong idea. I believe the stuff you have listed above is to make edits to the database's structure and tables--what I'm looking for a something to design forms and menu's that can then access the database (probably as a separate .exe). Sorry if I didn't make my request before very clear. Thanks for all of your help--being unfamiliar with this area it's nice to have help from some people who have used a lot of the products around and know which ones are the best to use.

Taylor34