Complex Data-source Question
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:
View Replies
ADVERTISEMENT
i dunno what's the DSN coz it's my friends code and she's using windows2000 so her open database connection code differs from what i use..like
"con.open ...."
what should i do to redirect the the connection to its database?i cant change all the codes coz there's many pages and takes ahellotta time
View Replies
View Related
ADODB.Connection.1 error '80004005'
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
View Replies
View Related
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")
dbConn.open connect_string
View Replies
View Related
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
/class/classView.asp, line 13
View Replies
View Related
i'm trying to use an odbc driver to connect from an asp page to a data source (dbase) on unix sunsolaris. is this poss?
the driver is installed though i cant seem to do it through dreamweaver ultradev - can i do it through the ftp connection?
what would i input as the source on the following to initiate the connection in the asp page?
"Provider= "MSDASQL"; Data Source= server name ?
"Database=test;User ID=sa;Password=blabla"
or how would i do it using the followign as an include file ? Code:
View Replies
View Related
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.
View Replies
View Related
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
/directory/progs/utils.inc, line 17 ...
View Replies
View Related
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
Code:
View Replies
View Related
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
View Replies
View Related
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?"
how can it be with only one sql query?
View Replies
View Related
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)
View Replies
View Related
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:
View Replies
View Related
I am trying to write a regex function that will find all html tags with an id= value and get it to return the tag and value of the id.
i.e. <a href="blah.htm" id="someLink"> would return
a someLink
Any help would be greatly appreciated, this has got me very frustrated.
It will most likley be a very simple thing that I have missed.
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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
View Replies
View Related
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).
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
there are any open source for ecommerce site like a one such for 'oscommerce' in php/mysql.
View Replies
View Related
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 ?
View Replies
View Related
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?
View Replies
View Related
I want to open the source code in an iFrame. What's the ASP script for that?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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 ?
View Replies
View Related
How can i get the source code of a web page through asp code?
View Replies
View Related
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 ?
View Replies
View Related
Is there a code that will deactivate the View Source on a browser? I have people tealing my page content from my client web site.
View Replies
View Related
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 Related
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?
View Replies
View Related