I use the ASP page to test whether the connection of SQL Server is fine. I use windows authentication. I get fail when I attempt to use hostname of the destination server. Contrary, I get success when I attempt to use IP address of the destination server. Does anyone know how to fix this issue?
View RepliesI have a simple ASP code that i am trying to use in order to get records from a database in SQLserver 2000 and display it in html format.
I named the file index.asp and placed it in the home directrory for IIS. When i type in http://localhost/index.asp, i get 500 errors. On viewing the IIS logs, i am noticing the following errors:
2005-10-31 20:05:16 W3SVC1 127.0.0.1 GET /index.asp |47|80040e4d|Login_failed_for_user_'test'
After searching on the internet, I have already checked "SQL Server and Windows" authentication in SQL Server security.
here is the code that i am using to connect to the database: Code:
When I connect to a MS Access 2000 db with no password using a OLEDB string is no problem but if the db is protected by password I get this message:
"Cannot start your application. The workgroup information file is missing or opened exclusively by another user."
The string used is this:
"Provider=Microsoft.Jet.OLEDB.4.0; Password=xxxxx; Data Source=" & Server.MapPath("xxxxx")
Does anybody have a clue?
Not sure if this is the right place but I need to get this website going and am having problems with the ODBC driver connecting to the SQL server When setting up the driver I am getting a sql error 18452 login failed reason: not associated with a trusted SQL connection I am at a loss as I installed this on another machine and it worked.
View Replies View RelatedI am building a shopping cart where orders are send by email. Even though it says it's sent, I receive nothing. So I did a test script to send an email using CDO since we are using an exchange server for email and it's on the same network as the site. Code:
View Replies View RelatedI have created a quiz with 14 questions that the user can click a yes radiobutton or no radiobutton. In the code-behind I have set a varable to store the selected items.
What I have taking place is if yesRadiobutton is selected the variable is incremented by 1. then after all the radiobuttons have been added up. i check the variable using an if statement. Code:
I'm pretty sure this is possible in ASP, something about making CPU time markers and then taking the difference and switching it into seconds/minutes I just don't recall how to go about doing it.
View Replies View RelatedI've been trying to create a test site - The site uses ASP with VBscript and talks to SQL Server 2000. I was able to complete and test it on my locally on my computer using Microsoft’s IIS 5.1. The website communicated fine with the database on the webserver/network server
However, when I tried to save the site from my local computer to the wwwroot folder in the server’s IIS hoping to make the internal site available to everyone here the resulting error comes up when we try to open a page with a recordset connected to the database: -
Our Error: -
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'AUMBSDDSSIUSR_AUMBCOMP'.
/mysite/htm/test2.asp, line 8
The page calls on an include file
Code: ....
The ASP application uses the "File" active-x control. On windows 2003
IIS(6.0), the download the file fails with the Error: Request object error
'ASP 0104 : 80004005'
The above error is retuned by my asp code: lnBytes =
Request.BinaryRead(lnByteCount)
I did not see this error on windows 2000 server. Is there any solution/workaround available on Windows 2003 IIS(6.0) for this issue.
I've been using Dreamweaver Ultra Dev to create a dynamic page and I've been unable to view the page in a browser once the file extension changes to .asp. If I try to open it (in a browser) outside of an editor then nothing happens.
If I try to open it inside an editor, like in DW then I get HTTP 400 Error. DW also has a feature to let you view live data, when I choose that, it gives me "Bad Request (Invalid HostName)" it also mentions: "An error occurred while requesting the document from the app server." I'm running IIS.
what I need is is when a visitor comes to the site, I need it to check
the host name. if "www.hometowndigest.com" is the host, then check a
folder named "something" and if the folder does not exsist, create
folder "www" and then copy folder "temp" and its contents.
If the folder "www" is there, look in it, check to see if the files in
folder "temp" are in there, if not, copy the files that are not from
folder "temp" into folder "www". Code:
I work with ASP for several weeks now and i really like it! But until now i have just used it in connection with my localhost. I made connections to a SQL Database and to an ACESS Database with using the ODBC Tool from WIndows!!
Now i want to publish my website but i don't know how to handle the connection string kind of thing. My MySQL-Database is on a different server than the website and i need a connection string where i can type in the server, a password and a username and it should then connect.
How do I test a "timeout" error when pulling an .asp page? How do I
raise a "timeout"? How do I "catch" a time out using VBScript with
ASP?
I am familiar with connecting asp pages to sql server when both servers are
on a LAN.
Can anyone advise on how to connect when the servers are remote from each
other?
I was wondering if i can create an if/else statement that checks if my connection string that opens a database ie:
cnnDB.Open Application.Contents.Item("CONNECTION_STRING" )
(the actuall connection string is in my global.asa file incase u were wondering) ...or if the database can't be found or opened, will run some other code... like a message?
hope u get what i mean.
this is just incase a user has the DB opened, or is in the process of overiting the DB or something, the page would not display that Microsoft JET Database Engineerror but display a message i set up in the if/else statement.
I have created a database called "myshop.mdb" Then I create a System DSN connected to that database called "OE1" The following code retrieves attributes and possible errors from the DSN Code:
View Replies View RelatedI have been trying to get an intranet search page to work that looks at an Access database. The database is called database.mdb, and lives in the root of the site, as does the .asp (security is not a problem at the moment). The code was taken from an asp website. I am running .net and Windows server 2000.
Could someone look at the code and tell me if it looks OK for connecting to the database? Then at least I can rule out code as the problem I am having.(receiving error codes)
I am getting this error at all my ASP pages. A sample page which pulls the categories from the Northwind database is enclosed below where I get the error when I am trying to open a recordset with that SQL query and Connection. Code:
View Replies View RelatedI would be glad of some help being new to ASP.
I manage my department information through an Access relational database and an http network model database. Naturally enough I want to combine them.
We have an old NT driven LAN with pc's running Win 9x or XP pro. The file server is nearly up to capacity on storage and bandwidth, the new XP machines have plenty. The network is backed up daily. If possible I want to use the XP m/c as a web server.
I want to use IIS and ASP from an XP m/c to read and write to databases on the file server but can't seem to get the connection string right, I have tried many, with and without DSN's. Having checked up on IIS (installed on XP pro) I suspect that it can only connect locally. Certainly everything runs on a test setup in C:/inetpub/wwwroot which can be accessed across the LAN and ASP runs fine.
i want to open a connection for password protected database but i don't want to write password in code as it can be seen by my host provider and misused is there any way I can read database password without writing it in my code.
Set cN = Server.CreateObject ("ADODB.Connection")
cN.Open "DRIVER={Microsoft Access Driver (*.mdb)}; password=joy; DBQ=" & Server.MapPath("db1.mdb")
above example works fine but i dont want to write password in my code is there any way i can do it.
How do i detect whether the database connection is open or not in a asp page?
View Replies View RelatedIs there any good reason why this shouldn't work?! All I get is the word "venue" and it doesn't display the relevent field value beside it.
Set cn = Server.CreateObject("ADODB.Connection" )
strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("db/db1.mdb" )
cn.open strConn
strSQL2 = "SELECT * from Events where ID = " & intEventID
Set rs = cn.execute(strSQL2)
response.write "venue" & rs("Venue" )
response.end
I have one database, but nine web sites all linking to this database for client input.hen I use the domain web site that the database is atored under, the ASP page updates the database as required. I have been using the following connection:
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:domainsmyweb site domain namedbmy database.mdb"
Now I have saved this ASP page under one of my other domain names and have tried using an ODBC connection as follows:
"DSN=ODBC Connection;Driver={Microsoft Access Driver (*.mdb)};Dbq=my web site database domaindbmy database.mdb;Uid=Admin;Pwd=;"
Unfortunately when I complete the ASP page on this web site, and submit, the database is not being updated with the records.
how to connect to a DSN from ASP without specify a database?in VB6 it's possible and works fine:Code:
Dim myconn as new ADODB.connection
myconn.open "DSN=test"
i have a sign up page it work good when i try it it write the information in the database but if i rewrite the same thing it rewrite it in the database.i need a script that if the name already existe it cannot be recreated.
i want to have a log on page but i dont know how to make the page got verify in the database for the username and password.i need the script for when they login to go get the info about the caracter but i need the script to make the user to stay connected like for there score in the game to be saved in there account. so this is it, if you don't uderstand just specify what you don't understand . by the way my page is in asp and my database is in acess .
set rs=server.createobject("ADODB.recordset")
sql ="SELECT company_name FROM contacts WHERE company_name =" & cStr(sField)
If Len(sql)> 0 Then
rs.open sql,conn,3,3
sql is defined above and conn is defined in another asp page. What I am wondering is what does the ,3,3 do? and Is it necessary to have this in the page?
i have built an Intranet using includes, which is about all the access of the IIS server I have. I really want to have database functionality so that I can use an Access database - but cannot and will not be able to use ASP to connect to it
how I can do this without using ASP? Client-Side, or something similar? Or any other way..? All I have to play with is a standard business-wide build of IE, and a very limited IIS server.
what is the connection string to connect to a excel database.
View Replies View RelatedIs it possible to connect to a database that sits on a webserver using a script that sits on a local machine ?
If so, would the connection string look something like this :
sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("http://www.blah.cm/casinonewsxml.mdb")
The reason I ask, is because I have a vbscript that uses windows scheduling service to run at different stages during the day to update a database on a live server. I was wondering if it was possible to put this script on a local machine and make changes to the connection string.
I am trying to connect to two different database(Oracle and Access) in my ASP page.
I keeps getting the following error message
Error Type:
Provider (0x80004005)
Unspecified error
What would be the best way to do the multiple database connection?
Can someone please help me with this ASp script?
What i am tryiong to do ? Trying to connect to access database
Is DSN set ? Yes
Operationg System ? XP Prof
DSN Name ? NW
<%set cnn = server.createobject("ADODB.Connection")
cnn.open "DSN=NW"%>
<%
cnn.close
set cnn= nothing
%>
I am using the below code to try and connect to An Access Database on the same server. Code:
View Replies View RelatedI have written a asp application whihc uses a number of pages and each page connects to a sql database.
Currently I have the connection script coded on each page however if i need to change the database I have to change every page.
I have been told there is a way to have the connection on one page and each page to referance this one so I only need to change the one page