bpayne111 Posted March 6, 2003 Posted March 6, 2003 i've studied various books on and off ovr the years and this one has me pretty confused....i'm using the ADO.NET Step by Step book by Microsoft All of the examples use SQL Server connections I don't know what a SQL Server is. One of my teachers said i needed a whole operating system to use that. I'm pretty lost, i've worked with OleDb's a little so i know some basic SQL statements and so on, but don't know what i'm supposed to do to be able to even attempt to do these examples in the book. I hope my solution is free lol thanks for any help Quote i'm not lazy i'm just resting before i get tired.
Heiko Posted March 6, 2003 Posted March 6, 2003 In this context .... SQL Server is Microsoft's Database Product. Quote .nerd
Leaders quwiltw Posted March 6, 2003 Leaders Posted March 6, 2003 MSDE, which you probably do have, will work with those examples. Not sure what version of VS.NET you're running but in mine (Enterprise Architect Edition) their is a Setup\MSDE directory subordinate to the VS.NET directory. Otherwise, it should be simple enough to translate most of the examples to use Access and OleDb. In most cases you can just replace the SQL in front of the object name to OleDb, and obviously change your imports statement to OleDb instead of SqlClient. For example: SqlCommand becomes OleDbCommand Quote --tim
bpayne111 Posted March 6, 2003 Author Posted March 6, 2003 yea i'm aware of that but i like to follow the examples in the book sometimes, and that degree of seperation provides another degree of uncertainty. How much should i pay to get SQL Server? i'm gonna look that up in a minute but i'm going to microsofts site so i may be awhile lol Quote i'm not lazy i'm just resting before i get tired.
Leaders quwiltw Posted March 6, 2003 Leaders Posted March 6, 2003 NOOO.... re-read my post. You probably get MSDE (ie. little SQL Server) for free. All your examples will work with it. Quote --tim
bpayne111 Posted March 6, 2003 Author Posted March 6, 2003 lol ohh.. sorry bout that... i was in class the first time i read it and must have not paid full attention whoops Quote i'm not lazy i'm just resting before i get tired.
bpayne111 Posted March 6, 2003 Author Posted March 6, 2003 ok well i got it set up, i found a file included that walked me through the process... so ok i have this thing showing up in SQL Servers; BNPayne\VSDOTNET it's called nwind. Now i follow in the book and get to the same spot that troubled me before. I drag a SQLDataAdapter to the form, and click New Connection. There i'm asked for a server name. What do i put there? i've tried a couple things but i don't know enough to do it right am i the only one so blind to databases? lol Quote i'm not lazy i'm just resting before i get tired.
Leaders quwiltw Posted March 6, 2003 Leaders Posted March 6, 2003 In the servername box type in BNPayne and it should (if I remember right) populate the databases combobox to let you select nwind. Quote --tim
bpayne111 Posted March 6, 2003 Author Posted March 6, 2003 i tried it the computer locks up and i get an error that says it doesn't exist isn't my computer name supposed to go here? should i turn my firewall off before using it i notice it tries to access the internet for some reason. This is getting aggrevating thanks for your help Quote i'm not lazy i'm just resting before i get tired.
Leaders quwiltw Posted March 6, 2003 Leaders Posted March 6, 2003 Shouldn't access the internet. You could either temporarily stop your firewall or just allow traffic through 1433 (or whatever port you set it up on). You might try to type in localhost instead. Quote --tim
bpayne111 Posted March 7, 2003 Author Posted March 7, 2003 I figured it out... it was because the server name was actually BNPayne\VSDotNET yay thanks for the help Quote i'm not lazy i'm just resting before i get tired.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.