What database to use.
What database to use.
What database to use.
What database to use.
What database to use.
What database to use. What database to use. What database to use. What database to use. What database to use. What database to use. What database to use. What database to use.
What database to use. What database to use.
What database to use.
Go Back  Xtreme Visual Basic Talk > > > What database to use.


Reply
 
Thread Tools Display Modes
  #61  
Old 05-02-2012, 11:32 AM
VB_Alien VB_Alien is offline
Senior Contributor
 
Join Date: Apr 2004
Posts: 854
Default


In my version, i don't have an Object Browser but
the VB IDE will attach a database to, so i'm good to
go now.

I'd probably prefer to attach it a the server end but then,
i probably wouldn't have to put in the full path to the database
in my sql connection string.
Reply With Quote
  #62  
Old 05-02-2012, 05:52 PM
hDC_0What database to use. hDC_0 is offline
Contributor

* Expert *
 
Join Date: Feb 2004
Posts: 559
Default L

Quote:
Originally Posted by VB_Alien
In my version, i don't have an Object Browser..
In your version of what--
VB.Net 2010 Express edition or
SQL Server 2012 Express Edition?

The VB.Net 2010 express edition does have an object browser (see attached screenshot).

Things are a little more complicated in the SQL Server 2012 Express Edition.
In older versions of the SQLServer
there used to be an Object Browser in the SQL Query Analyzer
(but I'm not sure that came with one of the Express Editions).

The limitations of the SQL Server 2012 Express edition
can be found by looking at the feature charts on this page.

I believe the closest thing to the SQL Query Analyzer is now called the SQL Profiler.
If you look under the "Management Tools" section of the above limitations page
you'll see that the SQL Profiler is not found in the Express Editions.

There is however a 3rd party SQL Profiler that is designed to work with the SQL Server 2012 Express Edition
called "AnjLab SQLProfiler", which has a google code page here.

Did you know there is a free set of add-ons for the Microsoft SQL Server 2012 Express edition?
It's called the "Microsoft® SQL Server® 2012 Feature Pack".
Here is the download page.

Of course I haven't tried any of these things myself,
(I don't do that much with databases),
but I would be interested in any feedback if anyone else has worked with them..

There is also an MSDN article called "Migrating from Query Analyzer to SQL Server Management Studio",
that has a brief procedure designed to "configure SQL Server Management Studio as closely as possible to Query Analyzer"
(although I don't know if you will get you back the Object browser that used to be part of the Query Analyzer).

Last edited by hDC_0; 05-02-2012 at 05:57 PM.
Reply With Quote
  #63  
Old 05-02-2012, 08:46 PM
VB_Alien VB_Alien is offline
Senior Contributor
 
Join Date: Apr 2004
Posts: 854
Default

Yes. I knew about the object browser in VB Net but we were talking
about SQL Server Configuration Manager.

I think that maybe dr.punk and plausibly damp have the full version of
that program, where-as, i only have the express version. I don't think
they are quite the same program.

Since your so good with links, do you think that you can dig up a free version
of a database creator (mdf)?

I know i can make one in the VB environment but i'd rather have a stand alone
program to make them with.

Also, can anyone answer my last question about adding images in a record?
Reply With Quote
  #64  
Old 05-04-2012, 08:33 AM
PlausiblyDamp's Avatar
PlausiblyDampWhat database to use. PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

The SQl Express Management studio previously mentioned should allow you to create and manage a SQL database with full designer support for tables, views, stored procedures, referential integrity, functions and the creation and management of indexes.
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
  #65  
Old 05-04-2012, 04:38 PM
hDC_0What database to use. hDC_0 is offline
Contributor

* Expert *
 
Join Date: Feb 2004
Posts: 559
Default create mdf file

PlausiblyDamp is correct that the free SQl Express Management studio is really the designated tool for creating database MDFs.

Be aware of a number of things regarding mdf files:
1.) There is also a CD imaging file format (similar to .iso files) that ends with a ".mdf" extension --info here.
2.) The mdf file format used by the SQL Server software is not well documented,
(as regards it's internal file format structure),
and can be easily corrupted, (as noted halfway down in this StackOverFlow thread).
Note: There has been a suggestion on Microsoft Connect to create an "mdfx" file format that would (theoretically)
be a little more open and have an mdf-mdfx interchange tool that also might encourage Microsoft
to document the mdf file format a little better (publically).
I think it's a good idea, but it got the standard Connection suggestions not-a-priority brushoff:
Quote:
Thank you for submitting this suggestion, but given its priority relative to the many other items in our queue,
it is unlikely that we will actually complete it.
As such, we are closing this suggestion as “won’t fix”.
If you feel that this is worth reconsidering,
feel free to respond to this message and we will take another look.
3.) Here is a list of just a few of the software programs out there that promise to try and repair .mdf files
(which is the other reason to think that .mdf files are easily corrupted - otherwise there would be no need for these apps).

However, never let it be said that I am restricting the search for knowledge.
Here's a couple "quick/dirty" how-to articles on alternative approaches:
"Creating a SQL Server database programmatically using VB.NET".
"How to create a SQL Server database programmatically by using ADO.NET and Visual Basic .NET".

Maybe I should add a few misc (but related) links:
Walkthrough: Creating a SQL Server Express Database
That page has an important link to the Visual Database Tools page.
How to: Manage Local Data Files in Your Project..
Some MSDN info on .mdf, .ndf and .ldf files.

Of course most of the .Net database samples use the Northwind bookstore database
(because it has been around since the earliest days of Access programming),
but I sort of wish some of the database newbies would find
(just for varieties sake) some other sample databases to work with.

Here's a link that describes working with the AdventureWorksLT Database:
How to: Connect to the AdventureWorksLT Database using an .MDF File.
More info on the database itself can be found here.

There are several places you can get this free database.
I think the raw database file can be found here.
Other versions can be found off this page.

Finally (and I don't want to overwhelm you since I know you are
still trying to "ease" into working with SQL databases),
but have you ever heard of the "Schema View".
If not you may want to take a look at that section in this long article
(with a long title ):
"Implementing SQL Server solutions using Visual Studio 2010 Database Projects – a compendium of project experiences"

Last edited by hDC_0; 05-04-2012 at 04:51 PM.
Reply With Quote
  #66  
Old 05-05-2012, 02:23 AM
VB_Alien VB_Alien is offline
Senior Contributor
 
Join Date: Apr 2004
Posts: 854
Default

Quote:
Originally Posted by PlausiblyDamp View Post
The SQl Express Management studio previously mentioned should allow you to create and manage a SQL database with full designer support for tables, views, stored procedures, referential integrity, functions and the creation and management of indexes.
And once again, I'm telling you that my SQL Server Management
does not make databases. I've been all through that program and
there is nothing there at all that has anything to do with making databases.
It's a very striped down version of the paid for program of SQL
Server. Mine is the free express version.

The link you provided is for the 2005 version of the same program
that i got and maybe that version does create databases, i don't know.

It's hasn't been recommended for windows 7 64 bit of which i am running on.

What version of windows are you running? 32 or 64 bit?

I only need one server on my computer, if i install the one you linked
to, then VB will be fighting with sql server to see which one it gets
to access.
Reply With Quote
  #67  
Old 05-05-2012, 02:41 AM
VB_Alien VB_Alien is offline
Senior Contributor
 
Join Date: Apr 2004
Posts: 854
Default

hDc_0

I've been checking around about sql databases and i've found out the same
things that you just pointed out. One problem with a mdf file is that they frequently
break down. The company that i used to work for, used an mdf database. It
handled everything the company did, including the payroll. It was always
breaking down, 2 or 3 times a week. They finally got smart and turn to
using oracle. The breakdowns are a lot less frequent now. May twice
a month, if that.....

I was reading an article from a professional database programmer and that is
what he had to say about it. He did say that for businesses, the sql mdf database
is better suited for them but for low end database users, access mdb is the way
to go.

That low end database user, would be me. I only need a database for one program
and then i know it will be a long time before i mess with them again, like you.

So for now, i'm back to using access. I'm getting some much done with access
compared to sql, where i'm just barely able to open an mdf file right now.

I need to sit down and figure out what kind of stuff that i need to put in my
database, and then i need to custom make a database(mdb) creater.

That is why i was asking if anyone knew where i could find a free one.
It would cut down on my programming time.
Reply With Quote
  #68  
Old 05-05-2012, 12:09 PM
PlausiblyDamp's Avatar
PlausiblyDampWhat database to use. PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

I am not sure why you seem to be struggling with the express edition of the management studio, I have used both the 2005 and 2008 versions in the past to create and modify databases. I can't remember if I have ever used the 2005 version on 64 bit windows 7 but but the 2008 version seems to work fine.

Quote:
I only need one server on my computer, if i install the one you linked
to, then VB will be fighting with sql server to see which one it gets
to access.
Not entirely sure what you mean by this, if the database is running under sql then your VB app would simply connect to a SQL Express instance and access the database that way.

Quote:
One problem with a mdf file is that they frequently
break down. The company that i used to work for, used an mdf database. It
handled everything the company did, including the payroll. It was always
breaking down, 2 or 3 times a week.
Do you have any hard information about this as I have never worked on a SQL based system where the physical file itself became corrupted, there can certainly be data inconsistencies but that is often the fault of the database design / code rather than the underlying database engine. The fact the company also had a similar problem with Oracle makes me wonder what the underlying problem was...
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
  #69  
Old 05-05-2012, 07:07 PM
VB_Alien VB_Alien is offline
Senior Contributor
 
Join Date: Apr 2004
Posts: 854
Default

Here is the version that i am using now:

SQL Server Configuration Manager
Microsoft Corporation
Version: 2011.0110.2100.060

When i clicked on the link to download it,
it said that it was the 2012 version but this
looks like 2011 version, it think.

What-ever it is, it does not create or modify
any database. It's only job is to be a server
and that is it.

I can't get much clearer than that.

Now, in VB, i can create a database and
tables but as far as i know, i can't create
records and put data in them from VB.

I looked around in there but i didn't see
anything in there about creating records
but maybe i over looked something.

This is the closest thing i have right now
to making a database, aside from making
a database creator of my own.

I'm not going to explain myself as far as
my old jobs database problems. All i know
is that they were using microsoft databases
and they kept breaking down.

That is why they went to oracle. They has
far less trouble with oracle than they did
microsofts databases.

This wasn't just one company using the database,
it was a corporation with many of it's companies,
all over america and some over-sea's, accessing
that database and it could not handle the huge flow
of information coming in, i guess.
Reply With Quote
  #70  
Old 05-06-2012, 06:58 AM
PlausiblyDamp's Avatar
PlausiblyDampWhat database to use. PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

The SQL Server configuration manager is something entirely different to the Sql Server Management Studio Express.

SQL Server configuration manager is a tool that gives access to the very basic SQL Server configuration (such as port numbers etc.) This tool ships with SQL Server Express which is a Database Engine but doesn't come with any real management tools.

The SQL Server Management Studio however is a separate download which provides management tools for SQL Express, as such it allows you to create, modify, manage, secure and query a SQL server database. Looking back over this thread I can't see a single reference to the Configuration Manager until your previous post - if you want to manage a SQL server then you need the SQL Server Management Studio, I can't think of a clearer way to suggest using the Management studio other than providing a download link to the product and using the product name.
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
  #71  
Old 05-06-2012, 11:20 PM
VB_Alien VB_Alien is offline
Senior Contributor
 
Join Date: Apr 2004
Posts: 854
Default

I did say what i was using, a couple of times but i see now, we both were not
seeing what the other was posting. LOL

You were not seeing the word Configuration in my posts and i was seeing Configuration
in your posts.

I now know that what you are using is a different program from what i am using and i
will try and download it.
Reply With Quote
  #72  
Old 05-06-2012, 11:34 PM
VB_Alien VB_Alien is offline
Senior Contributor
 
Join Date: Apr 2004
Posts: 854
Default

I went to MS to download SQL Server Management Studio but
it's only a trial version. It won't pay for me to buy it, since i won't
be using it a lot.
Reply With Quote
  #73  
Old 05-07-2012, 05:50 AM
PlausiblyDamp's Avatar
PlausiblyDampWhat database to use. PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
What database to use.
What database to use.
What database to use. What database to use.
What database to use.
What database to use.
What database to use. What database to use. What database to use. What database to use. What database to use. What database to use. What database to use.
What database to use.
What database to use.
 
What database to use.
What database to use.
 
-->