I have been learning ASP stuff and have started to try to get into database connections.
We have Microsoft SBS4.5 (NT 4 packaged product) and it comes with Microsoft Internet Information Server 4.0 & Microsoft SQL Server 7.0 (these are running on the same machine). The server is running the ASP pages ok, and i can do simple ASP things like "the time at the server is xxx" etc.
I have written the following script to check my database connection : Code:
The company I work for is preparing to have our website recoded using .NET. I don't know anything about it and I know that you do, or did at least. So, my first question...is it possible to code .NET for free? For example, ColdFusion server is free to download, and I code it using a plain text editor. Can I do something similar using .NET? I want to learn .NET enough so that I can understand the programmers working on the site.
Any help would be great. I've found some tutorials so I'm good there...I just need the framework before I can start using those tutes.
I'm thinking about learning ASP.NET.
I currently have:
Windows 2000 Pro
Dreamweaver MX 2004
IE 6
NS 7
TextPad. 4.5
I currently code in ASP-Jscrip, server side/ MSSQL
What do I need to beable to learn ASP.NET? What software, what Version
of windows etc.any good URLs to learn sites that I can use to learn?
what books are recommended?
I want to learn ASP. He runs Win2K and I run WinXP HE. He just installed IIS on his computer. I've read that Microsoft doesn't support the installation of IIS on XP Home edition. Is it possible for me to access ASP from my computer?
We are connected to the same cable modem via a router but we aren't sharing files.
On another note, he is not very careful with viruses or firewalls. So he's gotten a LOT of viruses lately. That's the reason why I don't want to share files with him. But, since I need to learn ASP, I'm willing to start sharing files. Is there anything I could do to make our connection safe? I am running NAV and ZA.
i've looked a little at ASP...I think i'm going to learn this first; instead of PHP. It seems pretty easy also, so I might as well learn this now-Seems like more companies (Therefor more jobs) use ASP. A virtual hosting account with MS SQL isn't that much more, so really...Cost doesn't matter..not yet anyway.
In asp you can use a different scripting language like VBscript, JScript, or even perl? Any others?
What are some good Beginner books on asp?
What are some good Intermediate-advanced books on asp?
What are some good beginner books on SQL?
What are some good Intermediate-Advanced books on SQL?
I have been learning PHP for the past six months and am thinking about trying ASP. What exactly the difference between the two languages and what is it used for.
View Replies View RelatedI've been using PHP for my own personal sites for a while. Been using WAMP server so I could develop the site on my own harddrive using PHP and MySQL. Now, it just occurred to me that ASP is probably the better route as far as getting a job.
So what are some good references? I prefer a book over websites so what book should I look for? I've only recently figured out that ASP isnt a language and that you use either JScript or VBScript. While I come from PHP, Jscript should naturally be my choice, but I think I'm going to go with VBScript. Should I look for an ASP book or a VBScript book or both?
I use Dreamweaver to develop ASP sites and am reaching a point where yes it is helpful but I want to know more.
I would like to dive in a hand code things one of these days and was wondering if anyone out there has any good references as to where I could learn the language from the ground up. I figured I'd ask the professionals out there so I can learn from a good reputable source, this way I can learn the right way.
how can i learn client ip who connect my site..
request.ServerVariables("REMOTE_ADDR") with this i learn my server ip..
How hard is it to learn asp?What is the average learning time
View Replies View RelatedPlease tell a site from where I can download the tutorials for learning the ASP ?
View Replies View RelatedI want to create some quizzes with Macromedia Learning Site and everything is working except for one thing. I can't get the text input from a textbox via form input to write into one column in an Access database.
It writes everything that it is supposed to except the columns to the right are filled with text that should be in the previous column. I am pasting the code below. What can I change to make the textbox input stay in one column.
Anytime there is more than one word entered in the textbox, it carries over to the next column. How can I tell it this is a string of data please? The textboxes (in this case) are ReceivedData(6) and ReceivedData(5). Code:
I am tasked with getting and application functional with AICC/SCORM. It is currently an .ASP and XML based web application. I just can't find any real code examples of how people are implementing a AICC "wrapper" to get the basic level of communitaion going between a CMS(LMS) and the course.
I think I understand the concept but really would like to see an example of sorts. Anybody out here actually write their own AICC Courses?
I'm sort of trying to force my way through some manuals and w3schools trying to pick up asp. i'm farmiliar with PHP so i figure it will be a breeze there's just one general theory idea i don't understand. if ASP can be written with either javascript or vbscript. then is ASP just adding the <% %> tags around the code?
something like "Session.Timeout" or "response.write" this doesn't look like VBScript to me. are these elements of ASP, VBScript, or something else?
I hope you can understand my question.I'm sort of confused with the languages / where to look to find information because i dont know what to look for.
My company has developed a Learning and Content Management System (LCMS) using ASP (there is some .NET) and SQL Server 2000.I are currently exploring the idea of releasing the source code to the Microsoft development community under an open source agreement. If you or someone you know would be interested in participating please reply to this post with your contact information and why you are interested. (You may also send an email to URL with the subject "Open Source LCMS")
View Replies View RelatedI'm trying to debug an application that causes ASP to stop responding
while the other IIS services continue to run and the server continues
to serve static HTML pages. I've captured a set of log files using
the IISState utility but I'm not sure what I should be looking for.
Would you be able to point me to some resources to help me to learn
how to interpret these files?
1.
conn.ConnectionTimeout = 60
conn.Open connString
2.
conn.Open connString
conn.ConnectionTimeout = 60
Do both of them give different?
I wanted to know wheather DSN is ok for the connection to a database or direct conection is better?
when i started my web project on dreamweaver i had to make a DSN connection as i have followed the books, but as now as i have also asked several questions on this site, i have aslo implemented a direct connection as well on some pages, now i am wondering
is this going to have any affects when i uplode the complete site on the server.
i have noticed that on my computer when i am testing the site and uploading new records on sections that have DSN connections you can see the new record but on sections that i have implemented direct connection i cannot see it coz it is linked to the local directory database not on the testing server.
i have also never experienced uploading to a IIS server with DB connection so its my first time with dynamic websites. so am i in trouble or its ok the way i have done my site..
I am trying to create a web page that has a drop down menu in which it retrieves data from our SQL server. Maybe this is a bit more simple than I am making it but I am really pulling my hair out trying to get this right. Code:
View Replies View Relatedthis is my error:
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
here is my db connection string:
<%@Language=VBScript%>
<!--#include file="adovbs.inc"-->
<%
dim rs, cn
Set cn = Server.CreateObject("ADODB.Connection")
'with cn
' .Provider="Microsoft.jet.oledb.4.0"
' .ConnectionString=Server.MapPath("home/nfiweb.mdb")
' .Open
'end with
cn.open "nfijobs"
set rs = Server.CreateObject("ADODB.Recordset")
%>
When I click submit after updating the information all of my info gets deleted from the db so I'm guessing that the values that are being submitted are not getting picked up in the sql. I've tried changing the form names, etc, but still have the same prob. My code is below: Code:
View Replies View RelatedI am having trouble connecting to an Access db fro mmy asp page. I get the following error: The page cannot be displayed There is a problem with the page you are trying to reach and it cannot be displayed. Code:
I'm using an SQL2K backend and attempting to connect to it with the following code.
' -- Connection String Value
response.write "Setting strConnection"
strConnection = "DSN=tracktimedb"
' -- Our SQL Statement
response.write "Declaring SQL Statement"
strSQL = "SELECT * FROM TIMES"
' -- Populate our Recordset with data
Set objRS = GetRecordset(strConnection, strSQL)
I have done many searches but all the connection strings I've found seem to be using a DSN to an access DB. Currently I get this error when trying to connect.
Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
I can't seem to find the proper syntax to specify a db login (sa) and password in the connection string.
on 1 page i open
a connection to a database and build a recordset to check
username and password. there are other fields in the db
that i need to access on the next page. how do i reference that
connection and run a new sql query without having to reopen the connection?
i thought it would be as simple as NOT closing it, but thats not working.
I am having problem in my connection to database when running ASP.
It works fine for the first time but if I run it again without a gap of atleast a minute,
it gives me the following error message:
Error Type:
Provider (0x80004005)
Unspecified error
And the line it is showing error is where I am opening my database connection using conn.open.If I wait for couple of minutes and run again,it works fine.
I'm trying to maintain a permanent tcp/ip connection between two
computers using ASP. I need users accessing the ASP pages to be able
to send and receive messages using this connection. I know that I
can't use a Winsock control with ASP so I guess I'm looking at a third
party control. Even if I can get this working I'm not sure that I can
have different users accessing this one permanently open connection.
I've looked all over the Net for ideas on how to do this but I've had
no luck. Has anyone had to do anything like this?
I am trying to establish an ODBC conection to ORACLE 10g and have tried all the following. Please advise:
We are trying to connect to a 10 g server and nearly gone crazy after doing so. tried everythign, DSN, DSN less .... The bottom line the connection is successful when we try it form the control panel-> data source thing but not from ASP. We tried the following things: Code:
I created a master detail page using the wizard in Dreamweaver, however I need to create a DSN-less connection. How do I do that? I am assuming I need to edit this part of my code:
View Replies View RelatedCan anyone help me create a dsn less connection to the sql server 2005 db
from the connection.asp file below please,
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="true"
' Catalog=""
' Schema=""
Dim MM_TobiasNET_STRING
MM_TobiasNET_STRING = "dsn=TobiasNET;uid=sa;pwd=*******;"
%>
Need detailed explanation if poss or even better an example.
Need to implement an online payment facility, which requires SSL
encryption. I have bought the keys and they are installed on the server
(IIS5)
Can anyone point me in the right direction for help in activating the SSL
encryption using asp - tutorials or sample scripts etc?
I am getting 500 Internal Server Error. I have tried disabling the show
friendly error in IE and I have tried it on Firefox. It will not give me the
reason why it will not work, I only get 500 Internal Server Error.
I have tested the code up to the point of Set objConn and it works but when it gets
to the objConn.open dsn that's when I get the error. I wish to find out why
it is not allowing it to get pass this point. I have control of the server
where this is hosted and if there is anything I need to do, I can do it.
I am trying to create a web page on our company intranet.I am using Frontpage 2000.I need to be able to read from and write to databases in this project.I am starting slow since I am just learning, so for now I am trying to read from an existing SQL database on a network server. The server is running SQL Server 2000 and IIS.
I could create a database connection using the Database Results Wizard in FP. The connection would verify OK and I could select the columns from the table I wanted to display. When I published the page to the server, all I got was column headings, no data.
when I try to create a new db connection, it will verify, but it will not show up as an existing db connection.
need to connect DB2 tables on mainframe, using a ASP front end...But I do not know how to... what all things I should enquire & need in the system before doing the same. connection format to connect a databse on mainframe.
View Replies View Related