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
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
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
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:
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
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:
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
/directory/progs/utils.inc, line 17 ...
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:
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
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?
View Replies View RelatedI 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.
there are any open source for ecommerce site like a one such for 'oscommerce' in php/mysql.
View Replies View Relatedi'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 Relatedhow 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 RelatedI want to open the source code in an iFrame. What's the ASP script for that?
View Replies View RelatedIs 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 ?
How can i get the source code of a web page through asp code?
View Replies View RelatedI 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 RelatedIs 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 RelatedMy 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 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?
I want to read an ASP file and display its source text.But I only get its HTML output. Later on,I will extract that source text to display certain thing.
Here is my code:
Const Filename = "/aspBoard.asp"
Dim FSO
set FSO = server.createObject("Scripting.FileSystemObject")
Dim Filepath
Filepath = server.MapPath(Filename)
Set TextStream = FSO.OpenTextFile(Filepath)
Dim content
content = TextStream.readall
Response.Write content
TextStream.Close
Set TextStream = nothing
My company recently hired a third party to handle phone orders during off hours. The third party wants to be able to update our database through their own interface. We are running SQL Server 2000 on Windows 2000 Server with ASP.NET 1.1. The number one thing that come to mind is security for credit cards. Perhaps some kind of web service, xml, etc.? Does anyone have any suggestions on the best way to handle this?
View Replies View RelatedI was wondering does anyone use any third party tool to encrypt the original ASP source code from dispose.
View Replies View RelatedWhat would be a great open source ASP project which I/we could cut my/our teeth on?
View Replies View RelatedI am in the process of building a web page that allows users to make some resource reservations from the web. I need a source code for a calneder where if the user clicks on a specific day of a specific month a new link will be opened. where can I find this ?
View Replies View RelatedWhere I can find the code source for the function len for study ends. As (LEN) with its code was created script of the function. I tried to look for in google but I did not find nothing! Somebody can indicate me one link, site, script?
View Replies View Related