ADO beginner (go easy on me lol)

B

bpayne111

Well-known member
Joined
Feb 28, 2003
Messages
326
Location
BFE
ive studied various books on and off ovr the years and this one has me pretty confused....im using the ADO.NET Step by Step book by Microsoft
All of the examples use SQL Server connections
I dont know what a SQL Server is. One of my teachers said i needed a whole operating system to use that. Im pretty lost, ive worked with OleDbs a little so i know some basic SQL statements and so on, but dont know what im 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
 
MSDE, which you probably do have, will work with those examples. Not sure what version of VS.NET youre 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
 
yea im 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? im gonna look that up in a minute but im going to microsofts site so i may be awhile lol
 
lol ohh.. sorry bout that... i was in class the first time i read it and must have not paid full attention
whoops
 
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 its 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 im asked for a server name.
What do i put there? ive tried a couple things but i dont know enough to do it right

am i the only one so blind to databases? lol
 
i tried it
the computer locks up and i get an error that says it doesnt exist isnt 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
 
Shouldnt 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.
 
I figured it out... it was because the server name was actually BNPayne\VSDotNET

yay
thanks for the help
 
Back
Top