I want to try writing something that accesses a SQL database. I have the db on a disc. Its not too big. I need to know if VB.NET with SQLConnectors is smart enough to access the db file or do I actually have to have a SQL server installed and running. With Access dbs I know all you need is the db, you don't need Access installed. Seems to me that you do need SQL 2000 or MSDE, but I thought I would ask before I get into it. I would hate to be frustrated for a week before I realize that I did need it but never installed it.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL db and SQL 2000 (or MSDE) or just SQL db file?
- Thread starter SteveMCSE
- Start date
Umm, where did you get this database?
Chip H.
____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first
Chip H.
____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first
- Thread starter
- #3
ok, so I figured it out. I downloaded and installed MSDE 2000 A on a different computer. I basically figured out how to server a SQL DB so that I can program against it. It works great.
MS has available for free download SQL DBs that are samples. They are used for the purpose of learning SQL or programming.
There are plenty of DBs for download on the web by the way.
MS has available for free download SQL DBs that are samples. They are used for the purpose of learning SQL or programming.
There are plenty of DBs for download on the web by the way.
Glad you got it working!
Chip H.
____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first
Chip H.
____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first
GaryWilsonCPA
Technical User
I am pretty good with access but also want to try some other data. How did you get started with msde?
MSDE is easy to work with -- you change the datatype of your objects from OleDb* to Sql*, and everything else pretty much stays the same.
The only catch to MSDE is that you don't get any administration tools (no EnterpriseManager, Query Analyzer, etc), so you end up writing a lot of one-off queries to find out what's in the database. But it's free, what do you expect, eh?
And before anyone chimes in with "I know where to get those tools", be aware that a MSDE installation is not licensed for them.
Chip H.
____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first
The only catch to MSDE is that you don't get any administration tools (no EnterpriseManager, Query Analyzer, etc), so you end up writing a lot of one-off queries to find out what's in the database. But it's free, what do you expect, eh?
And before anyone chimes in with "I know where to get those tools", be aware that a MSDE installation is not licensed for them.
Chip H.
____________________________________________________________________
Click here to learn Ways to help with Tsunami Relief
If you want to get the best response to a question, please read FAQ222-2244 first
- Thread starter
- #7
You're right about not getting any tools, but if you go to microsoft's web site you can download a free (very cool) web based tool. It has it's own very small web server built right in so you can just run it and open the sql server. You can see all of the DBs and you can administer them right form there. You can add, remove and change user rights and you can modify the DBs as well as view/see/query/change the data.
It's very powerful and very small and best of all.... FREE..
Download it here:
To install MSDE you can't just double click the icon. That would be too easy. At the very least you must set a password on the sa user account. For those of you who don't know, the sa account is the built in SQL administrator account. It's not a windows login id though, just a sql login. To do this, open a command prompt and type the following: (at the minimum)
c:\somepath\setup.exe SAPWD="AStrongPassword"
ok, now obviously you will set AStrongPassword to some password of your choice. All version of SQL come with the pubs database installed. You can download the ever popular Northwinds database from Microsoft. It's a SQL script that you can run with the osql executable built in to the MSDE. Very cool what it does. It builds a DB for you as a sample DB.
To connect to it in VB just use the server explorer. You can create your user with the web admin defined above. When you connect to the server it will ask you for your credentials. Simple stuff. If you're programming in VB (or reading this for that matter) you won't have a problem figuring it out. I didn't.
Good luck to all and thanks for all of the great help in all of the threads!!!!!!
It's very powerful and very small and best of all.... FREE..
Download it here:
To install MSDE you can't just double click the icon. That would be too easy. At the very least you must set a password on the sa user account. For those of you who don't know, the sa account is the built in SQL administrator account. It's not a windows login id though, just a sql login. To do this, open a command prompt and type the following: (at the minimum)
c:\somepath\setup.exe SAPWD="AStrongPassword"
ok, now obviously you will set AStrongPassword to some password of your choice. All version of SQL come with the pubs database installed. You can download the ever popular Northwinds database from Microsoft. It's a SQL script that you can run with the osql executable built in to the MSDE. Very cool what it does. It builds a DB for you as a sample DB.
To connect to it in VB just use the server explorer. You can create your user with the web admin defined above. When you connect to the server it will ask you for your credentials. Simple stuff. If you're programming in VB (or reading this for that matter) you won't have a problem figuring it out. I didn't.
Good luck to all and thanks for all of the great help in all of the threads!!!!!!
If you have Access, then you could also build ADP's which would then give some of the functionalities of the Enterprise Manager, or at this page MSDE 2000 Partners, there's several third party tools. Correct me if I'm wrong, but I get the impression DbaMgr is free to use with MSDE.
Roy-Vidar
Roy-Vidar
- Status
Similar threads
- Locked
- Question
- Locked
- Question