I have knowledge of programming ASP pages, HTML, Vbscript and making/connecting to MySQL databases with SQL queries. I am prepared to learn new things if they are required, but ideally if it can be done using the above, or slight additions to the above it would be great!
I would like to get data off of the web. What I mean by this is that there might be a site that has a table on it. Is it possible to make a script take data out of the browser window (just thinking about it sounds difficult!).
If not, is there an easy way to get a script to dump the information (i.e. the source code of the page) into a .txt file or something that can be read by a script. Alternatively, would automating the pasting of the table into an excel spreadsheet be possible. Code:
SQLState: IM002 Native Error Code: 0 [INTERSOLV][ODBC lib] Data source name not found and no default driver specified
------------------
strconn ="DSN=dsnname ; UID=username ; PWD=password" set conn = Server.Createobject("adodb.connection") conn.Mode= 3 conn.open strconn the error is in the last line. THANX
Mircosoft OLE DB Provider for ODBC Drivers [0x80004005] [Mircosoft] [ODBC Driver Manager]
Data source name not found and default driver specified
This is the connection string im using and ive install an odbc driver connect_string = "Driver={Mysql}; Server=localhost; Database=Tester; " set dbConn = server.createObject("ADODB.connection")
So i get this error and i have no idea what it means. So if someone could help let me know what this error is coming up for it would be nice. Im just starting asp today because my work has a client who has an asp site. Thank you
Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I have a couple fields in an Access DB that have parenthesis in the name:
EST(Minutes), EST(Seconds)
When I try and populate the dataset and then bind the datagrid it claims there is no field having that name. Can parenthesis be used in fieldnames. If so, can you please tell me the correct syntax please.
We had a web site that works in windows NT very good with a DB in Access. Our clients migrate to Win 2000 and now the connection to the DB doesn't work ... the error is this:
Error: Access is Denied. Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
When I try it on original server, it works, but when I moved everything to a different server it does not work. I have checked the dsn name, userid and passs. But no luck.
Error [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
We hosted our asp based application under windows 2000 server with sql server 2000 as backend. All the asp module works fine with internet explorer version 5 but same application is giving odbc error when we run the application in IE 6.
The exact error is : Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified xxxxxxxx/login.asp, line 27
ID From To Date 1 Tom User1 10.10.2004 3 Tom User1 10.11.2004 4 Tom User3 10.08.2004 5 Tom User2 10.05.2004 6 Tom User2 10.10.2004 7 Tom User2 10.11.2004
Tom sent messages to him friends. He sent messages to User1 for 2 times. to User3 for 1 time to User2 for 3 times..
I want to show to Tom how many messages he have send so far.
the quene is much more important for me.
I need like above.
You sent messages to User2 for 3 times You sent messages to User1 for 2 times You sent messages to User3 for 1 time
the important thing in the quene is that "who Tom sent messages to most?"
I have a query to one table but one of the values in the table is referencing a record from another table... here is the sql Code:
strSql = "SELECT streetdate, barcode, itemname, descrip, vendor, sku, catlog, config, retail_cost, cost FROM blah WHERE (STREETDATE >='"& GSTARTDATE &"') AND (STREETDATE <='"& GENDDATE &"') ORDER BY STREETDATE, CATLOG DESC"
now I have 2 things going on here... 1. vendor is just a number... there is a tblvendor that matches the number with a name (that i need.. i coudl nest another db query but figured that would be more resource intensive as this returns 1000s of records) 2. itemname is also a number that references another tblItem the sam way, I woul dlike to sort alphabetical off this somehow (is it even possable)
I have a blog who created pages this way: article.asp?id=222 and I'm using a sort of asp urlrewrite. It works perfectly with creating the articles etc, but now I have to put a "301 moved permanently" in the old article.asp page.
I have a function which converts the title of the article to a page name, using title and id: Code:
I want to display a kind of two-tier one-to-many relationship, for which, in the olden days, I would have used a series of nested loops and multiple calls to the db. Code:
I am currently using a single list box and select case to carry out a search for resources on my website. I would like to improve my search by adding two or three more drop down menus to achieve a single, more detailed search.
Hopefully this will help the end user find what they are looking for. unfortunately the current search is rather broad and i need to narrow it down. How do i go about achieving this?
I am working on a small project which requires XML data to be read from ASP.
I am successful at using XML/DOM objects. But when the data size goes up, sequential access will tax the web server. I would like to retrieve the data in the xml file like a MSAccess DB.
I read somewhere that XML source can be provided as data stream in ADO. If anyone has knowledge on this, please provide me links. If possible, answer to these queries will also be appreciated. 1. Which version of IIS supports this. 2. Which version of ADO 3. Additional components needed at the server ?
I found the following link at MS. http://support.microsoft.com/default.aspx?scid=KB;en-us;q263247
I am looking for an open source, very simple CMS that allows an administrator to add pages, news articles, and maybe a staff directory. We don't need new users to signup, or comment, or anything along those lines. Maybe a wysiwyg editor included. Just for a homepage, a news section (that may include many sub-cats, pages).
I've got a Windows 2000 server running with about 50 websites on it, all running ASP scripts. I've noticed that the servers CPU usage gets up 100% sometimes, caused by dllhost.exe, which I'm certain is a hanging ASP script somewhere on the box. Probably an on error resume next line that doesn't go anywhere when an error is an encountered. Anyways, I'm not sure if there's a way to isolate the website where its originating, or even the page this problem is originating from. Is there a way to do this?
Does anyone know of any source control software (besides Visual studio) that allows a multi-user environment to be able to check out/in files and keep version control?
I am trying to debug some values in production server.I want to print the value of rRes(10),but I don't want to show it in the screen.I just want to show it in the source code but comment out,so that I can look at the value.Is it possible?
Response.Write("rRes(10) = " & rRes(10)) will show the value in the screen,but i want to hide it in the screen but still see the value in the source code.
i've developed an appliaction that i want to sell it to my client, but dont want him to reseller it, so is there any solfware or techniques that i can used to protect my asp source ?
how do u get somthing from the root directory no matter where abouts you are? say i'm in /folder1/bla/test/foler2 and i wanted to place an image on this page but i don't want to have to backtrack ( ../../../../ ) all the way to get there. is there a peice of code that can go straight to the root directory?
Is there a way of processing an ASP page and placing the resulting HTML source code into a TEXTAREA on another page?
I have a page that will be generated dynamically from database content. However, I want a form on another page to have access to the compiled source code for use in an electronic newsletter.
Manually I would load the dynamic page, view the source and copy it out. I would then paste it into my form field on the relevant page.
This is not really language specific but more of a source code parsing. I have a large ASP source file that I like to split up, resulting in separate ASP files, each containing one function and the filename named after that function. Does anyone know of a tool/script which does this? PS: I am too lazy to learn Perl/AWK/Python to do this, hence why I believe someone has already written a tool/script to do this. Possibly in C++/etc.
how can i load in an adodb.recordset a remote xml file on another http server.
if i use the simple ole-db provider, that work as an admin only. (according to ms, this component mustn't be used for non-interactive users.
So i found serverxmlhttp but ... i can load the remote source in, i can load it in an domdoc, as describe in the msdn, but, as my files are encoded for french, they can't be open by the recordset.
so my question is the following ?
is serverxmlhttp the only way ? if it is, how to make it work properly in this case ?
I Would Like To Be Able To Hide All My Code And Stop Others From Taking My Scripts From The View>source Option. And I Would Like To Be Able To Put A Picture In That Option So That When Other View Source All They Get Is A Picture ?
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")
I have a page which contains a TEXTAREA form field.I want to be able to click a button and have it go off and fetch the source code for a compiled ASP page ie.
what the user would see if they loaded the ASP page into their browser and put the source code into this form field.Is this possible?