i am a part time student in web design and i am trying to learn asp.net and ado.net at the moment. i do not delve into SQL until a little bit later in my course. [i am using visual studio 2003 and sql server express 2005] i am having integrated security issues. i keep getting this message; "" ! ADO Error: ' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. "" i can vaguely remember somebody mentioning to me, that i must change the security settings within SQL Server to allow visual studio to communicate with it. i dont know whwat to change! and there are so many options and different security folders.. guest, dbo, etc.. any help would be timelessly appreciated many thanks in advance

John Michael Kinsella kinsellajohn@hotmail.com

many thanks for the quick response. i have searched the four folders i have in my framework file to no avail. there are several asp.net reg files in seperate folders, sadly none of them have fixed the problem. any other suggestions.. the software was working fine a few days ago and the only change i can note is that i unplugged my laptop from the power,external hard drive and speakers. i havent installed any new software or anything. computers ay, gotta love em, but sometimes they can be a right pain in the ass. anyhow. any further help would be priceless. cheers.

John Michael Kinsella kinsellajohn@hotmail.com

this problem is bizarre. i have only got it on my laptop. i have tried the obvious like reinstalling visual studio iis and the framework.. all in the correct order. i have posted a screen shot of the error message. http://www.johnsturgess.com/Images/error.JPG i seem to remember a tutor of mine mentioning that this problem can be fixed but i am a bit lost. any help much appreciated. Cheers

John Michael Kinsella kinsellajohn@hotmail.com

this problem is bizarre. i have only got it on my laptop. i have tried the obvious like reinstalling visual studio iis and the framework.. all in the correct order. i have posted a screen shot of the error message. http://www.johnsturgess.com/Images/error.JPG i seem to remember a tutor of mine mentioning that this problem can be fixed but i am a bit lost. any help much appreciated. Cheers

John Michael Kinsella kinsellajohn@hotmail.com

Hi, Dan.. i am having troubles with the same thing. am i supposed to be using both the statements you suggested? the syntax for the second part was functional the way i sent it to you and it doesnt seem to work with your additions.. i brainstormed all the obvious problems, like i have secondName insted of lastName.. and extra/missing quotation marks... but i cant work it out.. i just get error messages when i try to search. see the issue im finding really challenging is that i havent handled much SQL. my course deals with one part at a time.. ie. asp.. then ado.. then sql... but i am having trouble understanding one and not the other.. its a home study course and so help from tutors is limited.. so, any other suggestions would be much appreciated

John Michael Kinsella kinsellajohn@hotmail.com

many thanks for your reply, i will give it a shot.. it sounds perfectly plausible but i am not too familiar with SQL yet.. John

John Michael Kinsella kinsellajohn@hotmail.com

I am trying to create a search for a sql database i have been writing. i have managed to get the search to search "firstName". if i replace this with any of my other column names it also works fine, but i am trying to get it to search multiple columns at once. i have tried searching on google but dont really know what to search for. i thought it might have been an AND or an OR statement but couldnt get these working either. this is my code; Sub BindDataGrid1() Dim CS As String CS = _ "data source=(local)\SQLEXPRESS;" & _ "initial catalog=mus_search_test;" Dim objCN As SqlConnection objCN = New SqlConnection(CS) Dim objDA As SqlDataAdapter objDA = New SqlDataAdapter("Select * from Musician_Search", objCN) Dim DS_SearchMusician_Search As DataSet DS_SearchMusician_Search = New DataSet objDA.Fill(DS_MS11, "Musician_Search") Dim objDV As DataView objDV = DS_MS11.Tables("Musician_Search").DefaultView ' sql statement for row filter MySearch = "firstName LIKE '*" & txtSearch.Text & "*'" objDV.RowFilter = MySearch RecNum = objDV.Count.ToString

John Michael Kinsella kinsellajohn@hotmail.com

i am attempting to write the cookies for a landing page. i have used the following code to analyse the presence of cookies, but dont know how to write the cookie for the page loading. Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Request.Cookies("Landing") Is Nothing Then 'if the name cookie does not exist ask user to enter name Response.Redirect("landing.aspx") Else 'if cookies already exist then show landing page Response.Redirect("tMN_index.aspx") End If this seems to work in terms of directing to the landing page.. just need the cookie help.... i basically want the landing page to appear if the cookie isnt present, and then the landing page to generate the cookie if not present. thank you

John Michael Kinsella kinsellajohn@hotmail.com

<!-- Original: Russ Swift (rswift220@yahoo.com) --> <!-- This script and many more are available free online at --> <!-- The JavaScript Source!! http://javascript.internet.com --> <!-- Begin function validatePwd() { var invalid = " "; // Invalid character is a space var minLength = 6; // Minimum length var pw1 = document.myForm.password.value; var pw2 = document.myForm.password2.value; // check for a value in both fields. if (pw1 == '' || pw2 == '') { alert('Please enter your password twice.'); return false; } // check for minimum length if (document.myForm.password.value.length < minLength) { alert('Your password must be at least ' + minLength + ' characters long. Try again.'); return false; } // check for spaces if (document.myForm.password.value.indexOf(invalid) > -1) { alert("Sorry, spaces are not allowed."); return false; } else { if (pw1 != pw2) { alert ("You did not enter the same new password twice. Please re-enter your password."); return false; } else { alert('Nice job.'); return true; } } } // End -->

Enter your password twice.
(At least 6 characters, 12 characters max, and spaces are not allowed.)

Password:
Verify password:

Free JavaScripts provided
by The JavaScript Source

Will the asp code help aswell???

John Michael Kinsella kinsellajohn@hotmail.com

I have been told by many people that javascript is the way forward for validating the amount of characters in a field, however i have tried several snippets of java code (that work in an html document) and i cant seem to get them to function alongside my aspx page. this is proving to be quite a pain as it is putting the breaks on my progression, i need to learn javascript and am doing so bit by bit, but more importantly i need practice with asp.net coding. this is why i am creating an application, but this is a necessary part of it. below is the link to the code i have tried.. i have tried substituting the names in all field and cant really see why it wouldnt work. any help, or code, or anything really would be much appreciate. and if it is easier by viewing my code let me know and i will post it.... http://javascript.internet.com/forms/val-pass.html many thanks, John Kinsella

John Michael Kinsella kinsellajohn@hotmail.com

Thanks for the suggestions guys.. basically i have just taken an asp.net exam and i am trying to put the skills to practical use. unfortunately i am not familiar with javascript but if you could give me more details i am more than willing to research. thanks again for your responses.. John

John Michael Kinsella kinsellajohn@hotmail.com

I am creating a site, and wanted to instigate a basic landing page.. i thought perhaps i could use Response.Redirect to put a 5second delay on the transfer to index.aspx any suggestions would be fantastic.. John

John Michael Kinsella kinsellajohn@hotmail.com

i am creating a basic web application to try and further understand the asp.net that i have been learning in my course.. i have got a month to wait before i get onto the next section of the course and want to get stuck in.. does anyone know.. or could anyone donate some code in the meantime for the following.. i have a basic user sign up webform with ; first name second name email address band name password d.o.b i eventually want the user sign up to be written to my version of sql server express 2005 so i can have a record of the users and so i can enable users to sign in.. greet them with their name and bandname and then further post any gigs that they wish onto a calender.. i dont know where to start or how complicated a task it actually is.. i think i will also have to create some form of admin for the database to manage and delete records etc.. any advice or help would be fantastic.. but for now i will just keep scouring the web cheers...

John Michael Kinsella kinsellajohn@hotmail.com

thank you for your suggestion, could you suggest the javascript that i could use as i dont actually have any experience with it.. just a snippet of code that forces a value of between 6 - 12 characters would be greatly appreciated..

John Michael Kinsella kinsellajohn@hotmail.com

unfortunately i am also a bit of a newbie in asp.net and cant offer a dynamic response, however there is a simple way that you can get your text bold on certain pages that should work through asp.net. presumably you are using external css style sheets.. in which case create a style for you div ie #activeMainPage { font-size:60pt; } in your external page and then if you only wish it to appear on mainpage.aspx / then only refer to it from that page. so for each normal page you could for example name your div "homelink" and for your main page call it "activehomelink". i know this doesnt directly answer your question, but i hope that it offers you a solution, all be it a non-dynamic one. if you already knew this way, good luck in your search for the dynamic way cheers

John Michael Kinsella kinsellajohn@hotmail.com

hi there, i am just learning asp.net myself and from what i have gatered so far, you do not need a database to create a basic blogging forum.. if you want people to sign up to your site, you will need database connectivity.. i would recommend that you use asp.net for this task, and the best way for somebody with little experience is to get hold of visual studio.. i believe visual studio 2005 express edition is available for free on the microsoft website http://msdn.microsoft.com/ along with free versions of SQL Server Express 2005 if you should decide that you do want to use a database.. the other fantastic thing about the msdn website is that there are literally hours of tutorials on visual studio, asp.net and sql server.. its a fantastic resource.. just go to the site and search for any of the above mentioned items. ps. they also provide several free asp.net templates for sites, which can again be useful if webdesign is not your strong point, as it should help you bang up a nice site.. good luck...

John Michael Kinsella kinsellajohn@hotmail.com

hello, on behalf of my sanity i beseach you all... i do not have a seperate server and am running this on my laptop o xp-pro, to learn asp.net and to write some web applications. since i have installed visual studio 2003 i have had a constant problem with the .Net framework. during installation, i installed IIS, then .Net Framework, the Visual Studio... as i was instructed to do.. here's the weird thing.. Visual Studio is very haphazzard about when it decides to work. the interface always loads but when i click on a project, it spawns an error message, instructing me to install the dot net framework.. this happens everytime i restart my computer, i can avoid it via hibernation.. when this problem does occur, i have to restart my computer somewhere in the region of 20-30 times to recover the .net framework.. i have no idea why.. can anybody help me.. as i say i am trying to study web development and this constant issue everytime i have to install updates of new software becomes very tedious. yours faithfully

John Michael Kinsella kinsellajohn@hotmail.com

i am using visual studio 2003 primarily i am experiencing difficulties with the range validator.. i am trying to create a range for a password field ! i have the max value set to 12 and the min set to 6 type = string this was generating an error at compile time. i read on another forum that this could be solved by switching the type to integer.. the code now compiles but generates an error regardless as to what is put in.

also i was trying to validate a D.O.B field with a regular expression validator.. but my mind is blow here. im completely lost as, date doesnt seem to exist as a regular expression. any help much appreciated cheers

John Michael Kinsella kinsellajohn@hotmail.com