Using ADO To Query SQL Server
I'm putting this in the ASP section as I think the error is on the ASP side of things. Most of the stuff I've done before has been in Perl so I'm basically winging this ASP stuff!
I'm inserting a row, which works fine and then I'm trying to query the row ID, which is auto incremented (or is an Identity row in Microsoft's terminology.) Unfortunately when I run through the results (I'm looping, even though there should only be one result, as I basically don't know any other way!), I get into an infinite loop and then receive a 'Active Server Pages error 'ASP 0113' Script timed out' error. I've not left out the recordset.MoveNext argument, as you can see: Code:
View Replies
ADVERTISEMENT
I am using classic asp and making a connection to LDAP server using SQL code under IIS 5 on my localhost and it works great. I have a form and form fields that pull from active directory.
Now, once I get the web team to deploy these files to the webserver where all users will be able to run this app.(this server is using IIS 6), my form fields show up blank.
For the life of me I cannot see what is wrong or different except the IIS version. Also, I have gotten the IIS logs and they don't tell me anything. Code:
View Replies
View Related
I have a provider to implement domain name search and another to receive variables from my site and save them on thier site.
PROBLEM
we are using MS ASP scripts on my site.
We want to be able to implement an include file to show the results of the form process from their website.
Currenlty i tried the ASP script below but it fails, complaining of the end if statement, when i remove it, it doesnt show anything. Code:
View Replies
View Related
How to select query according to User Input for a WebPage in C#.Net with SQL Server 2000.I am trying to build a web page in C#.NET with SQL Server 2000 using Visual Web Developer 2005. I want to select and execute the query according to user input.
I have a form which has 2 textboxes which gets start date and end date from the user. Based on start/end date my 1st query runs. Now if user does not enter any start/end date I want to run another query which takes default dates from database(which is in varchar:ex. now()/now()-180) according to logged on user's permisstions.
How to select query ?
View Replies
View Related
My code retrieves a username and a password from a form. Then this information is compared to some usernames and passwords that are stored in a database. The important thing here is that the comparison must be case sensitive meaning that "passWord" is not the same thing as "password"
I have this code, working fine in access 2003
SQL = "SELECT * FROM users WHERE StrComp(username_column,'" & entered_username_in_form & "',0) = 0 AND StrComp(password_column,'" & entered_password_in_form & "',0) = 0"
but get the following error when I run it against my sql 2005 database.
[Microsoft][SQL Native Client][SQL Server]'StrComp' is not a recognized built-in function name.
I don't know the corresponding t-sql for the query.
View Replies
View Related
I am running a querry on an access database and have set the number of records/page displayed at 20. if there are more than 20 records returned, then 1st page will show the first 20, the next page will show next 20 and so on....
The trouble:
the count of total records displayed is correct and the first page is displayed correctly. But when i click on *Next* to go to the next page, all the records of the database get displayed (not the 2nd page of records from the query).
View Replies
View Related
I am using ASP/MS ACCESS to see how I can query the same database, via 2 formfields.
{name: - search}Textfield 1: - Search by Category
AND/OR By
{name: - searchT}Textfield 2: - Location
Currently,
strSearchwords = Trim(Request.QueryString("search")); where "search" is the name of Textfield1
Which is fine, but how can I set it so that on Submit, the string from search, and searchT are somehow joined together into one string?
View Replies
View Related
In Access you use "*" + [passed variable] + "*", + can be replaced with &
Calling a parameterized query in Access requires % be used in place of *,
however, all that I have read show dynamic SQL passed to Access:
WHERE [some column] LIKE '" & ASPvar & "' % ORDER BY ...
However, my call is similar to:
conn.qMyLookup strVar, rs
If I modify the query in Access to:
"%" & [passed variable] & "%"
I get all records. If I only put it at the end, as suggested, I only get
matches at the end, not throughout the column. Code:
View Replies
View Related
I have sql server express at my PC-windows xp professional, I try to connect to a table via asp (queryString :"Driver={SQL Server};" &"Server=localhost;" & _
"Database=local;" & "Uid=nikos;" & "Pwd=nikos;" but there is an error
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver][DBNETLIB]"The SQL server does not exist or there is no permission.
I can login with EMS lite both with sql server Auth. and windows auth.What is fault?
View Replies
View Related
I'm trying to install a simple e-mail form to my webpage; which takes some info from user (like name, phone, e-mail,etc...) and when user pushes submit button e-mails them to me immediately. I've tried to do so with ASP Formmail but I couldn't succeed. . it gives me: Server object error " 'ASP 0177 : 800401f3' Server.CreateObject Failed " error. Can anyone please help me to install my form? Because I need to install it immediately;
View Replies
View Related
I'm getting the error,
Server object error 'ASP 0177 : 800401f3'
Server.CreateObject Failed
/pdf_project/form1.asp, line 19
Invalid class string
I'm trying to submit the data in my pdf form to the web server.I've written the .asp code for it but it has been giving me this error.
View Replies
View Related
I need to read a SQL Server table into a Web Page and within the Web
Page to permit my users to make changes to the records, delete or add
new records and then save the entire contents back to the SQL Server
table back.
The functionality I am looking is almost the same as In the SQL
Enterprise Manager whereby I can choose a table open the table and
then return all rows and I can maintain the same and save it back to
the SQL Server table. I want almost a similar web interface to such a
functionality.
Even if not a generic functionality as the SQL Enterprise Manager
table maintenance appreciate if somebody can share the code with a
sample how I can do it in ASP pages + T-SQL if need be.
View Replies
View Related
What do I need to do to enable CDONTS om my macine to make it working
I'm testing the code:
Dim objCDO
Set objCDO = Server.CreateObject("CDONTS.NewMail")
objCDO.To = "xyz@xxxxx.com"
objCDO.From = "zyx@zzzzz.com"
objCDO.Subject = "TESST CDONTS MAIL"
objCDO.Body = "SOME TEXT TO SEND OVER"
objCDO.Send
Set objCDO = Nothing
It gives me an error after Set objCDO =
Server.CreateObject("CDONTS.NewMail")
Server object, ASP 0177 (0x800401F3)
Invalid class string
View Replies
View Related
I have created a form that sends email thru my local server. What I want to do is send the email thru our corporate Exchange server. Does anyone know how I can accomplish this task? Please advise. Thanks.
P.S. I’m using Dreamweaver MX2004.
The code that sends email is shown below ....
View Replies
View Related
Real quick, please refresh my memory which one of the following preserves the information that was posted from a form?
server.execute
server.transfer
response.redirect
I need to have a page execute if an error occurs while processing a page that a form was submitted to and have the data preserved.
View Replies
View Related
I have made a site in ASP and I can navigate the site fine locally. However once I get to the product page I get:
"HTTP 500 - Internal server error Internet Explorer"
Does anyone have any idea as to why this may be? ....
View Replies
View Related
If I have multiple websites on the same server,can I use the #include directive to reference include files elsewhere on the server? I tried this -
<!--#include file="C:InetpubvhostsATRAMEMBER.COMhttpdocsheader.asp" -->
But no dice...
View Replies
View Related
I'm just about to start a project that needs to combine the results of a SQL
Server query with the results of an Index Server query. The basic idea is
that the user enters/selects a bunch of search criteria on a form.
Most of
the criteria selected by the user will be used to select records from the
database - standard WHERE clause stuff - but the user can also enter
free-text that should be searched for in associated uploaded documents.
The
documents are sitting in the file-system with file-name pointers only stored
in the database (not the document). Only records where the associated
free-text is found in the documents should be returned. I'm new to Index
Server and am wondering how is this done. Any good references/tutes?
View Replies
View Related
I have an application that needs to pull files from an internal server. This
is the setup. The web server is external facing, meaning exposed to the
internet. I then have a file server that sits inside our domain. I created a
COM object that can impersonate a user to retrieve files from that server.
However, I cannot get the application to pull files from the internal server.
I first tried a domain account that could reach both servers. This did not
work. I then had the network team create the same account on both machines.
This is not working either. I can impersonate the user (I am able to get the
user/users authenticated), but the script keeps coming back with and access
denied. Code:
View Replies
View Related
I'm stumped by one single thing when using Msxml2.ServerXMLHTTP.4.0. I'm sending an XML-formatted text string to a foreign server and getting a response back (using Windows 2000 Server and IIS). The problem is, when they send any special characters in the response string, my application chokes. Code:
View Replies
View Related
I'm incharge of updating the stats on a chl hockey teams Web Site. I
would like to know if there is a way to be able to save
the content of the CHL Statistics WebPage on our Server and using it
to update our Microsoft Access 2000 database.
If it possible, then I would take the content of that page. Execute
some code that will take this information an place it in our
database on our server. By doing this, our Team WebSite would be
update automaticaly at a time that I specify on our server.
At this time, I have to open the CHL Statistics WebPage. Then Save the
HTML page as a txt file, upload it on our server via FTP, then execute
my my code that places it in our database.
Could you send your suggestions to Join Bytes!?
View Replies
View Related
I want to copy or upload a file from server say some lanserver to ftp server through ftp. Is it possible.
View Replies
View Related
I have a server that we installed a Web Application (ASP) and It works with
a few clients that we tested, IE 5.5, and it does not work on the server
machine itself. So we've tested a few thing.
Created a simple file with the contents of <html> <body> Hello World </body>
</html> Made one with .HTM extension and one with .ASP.
I can see the HTM file from all machines. I can only see the .ASP file on the machine running IE 5.5 The server itself cannot see the .ASP page. We places the files in the root of the server web and in the Application folder with the same results.
View Replies
View Related
Any one has Idea, How to use Server.Transfer and Server.Execute, When I tried to use these methods I got an eror:
Server object error 'ASP 0230 : 80004005'
Server.Transfer Error
/SISWeb/portal_logon.asp, line 40
The call to Server.Transfer failed while loading the page.
anybody is there who can respond to this problem. Do I need to change any setting at IIS?
View Replies
View Related
How do you use server.mappath to update a access database on a completely different computer? One of my websites needs to update a database on a completely different website. Code:
View Replies
View Related
I've recently uploaded a site to a new ISP, which is on a Win2003 platform. I've had a problem in that the existing ASP scripts handling email form submissions all experience the following error:
Microsoft VBScript runtime error '800a0046' Permission denied
From what I can gather this is due to moving from Win2000 to Win2003, and specifically the problem lies in this line of code: ....
View Replies
View Related
I fire the following code on Index Server (different obj) and it returns a PDFs no problem, but when I change the object to use the MSSearch for Site Server I don't get any PDFs. Anything in the code that would cause this? I can see the PDFs getting crawled in Site Server, but when I try and search I don't get any pdfs .....
View Replies
View Related
Previously I have canvassed a few way to get a registration code from one server to another - checking the results of the search and returning a function in a string tro be executed at the end. Well that worked until one of my beta testers decided that he would fiffle and get around the syste mmm...
View Replies
View Related
How can i transfer files from one web server to another web server. Is it possible?
View Replies
View Related
i'm using a model, view, control architecture for a group of .asp pages.
i can't decide whether to use Server.Transfer or Server.Execute to pass posted data from my control to my model. are there security implications for using Server.Execute?
just wanting some advice on pros/cons to each of these since this is the first time i'm attempting to use these methods.
View Replies
View Related
I accept a few user inputs and a file from the user, post it to my ASP page.
I'm able to receive the data as well as the file properly in Receiver.asp.
In my receiver.asp, I need to process the user inputs and subsequently POST
this data and the file again to a different server. I would like to use
ServerXMLHttp. Now, how do I simulate Form creation in receiver.asp.
I use the following code to post to the second server
MyXmlHttp.open "post", myTargetURL,false
MyXmlHttp.setRequestHeader "Content-Type", "multipart/form-data"
Now here's where I get stuck.
1) How do I construct the form data? How can I put together the data i
received (which is text) as well as the received file (which is Binary) in
the same Send statement for the Post? -- I assume that if HTML forms do it in
some format, I should be able to simulate the same through ASP, but how???
2) The received file will not be stored anywhere in my server. It has to
be forwarded in memory.
Should it look somewhat like the following?
MyXmlHttp.send ("userId=" & someUserId & "&privateLabelID=" & someLabel &
"&File=" & receivedBinaryFileInMemory)
View Replies
View Related
my prob is i have 2 different computers, one that runs my asp pages and the other my database server (mySQL). im working on my local and trying to connect my remote database with my remote webserver using DSNless connection string as more advisable. Code:
View Replies
View Related
I have a website and use server.execute quite extensively. The website was put into production and at first all worked great.
but some users were getting to my site but an error message would pop up stating page was not loaded properly. TO many users it looks like the website simply does not exsist.
What happens is that when the web page (www.cheapbatterypacks.com/main.asp) gets executed it will fail for "some" people at the server.execute point.
Here is a good example of the problem. In my shop I have 3 computers on the same network. connected to a dsl connection etc. All have internet access all run IE6 etc. 2 will pull up www.cheapbatterypacks.com just fine. but 1 will not. maybe some of you will see the same error.
if you type www.cheapbatterypacks.com/loosecells.asp it will pull up fine but that file is supposed to be loaded by the server.execute function and not run on its own.
so now I am pulling my hair out to try and get these other folks on board and working.
How would something be so selective like this. COuld it be me webserver settings? And even if it was how come it appears to only affect some people.
This is a public website so there are no logins/passwords etc meaning they come in a anonymous and have only read/execute permissions.
I am still running windows 2000 server with all Sp's patches etc. IIS 5.0.
View Replies
View Related
