Putting Database On Server
My database and ASPs are currently on my local server and now I want to put it on the company's server.
Any pointers how can I do that? Do I need to keep both the ASP's as well as the database on the server?
My database and ASPs are currently on my local server and now I want to put it on the company's server.
Any pointers how can I do that? Do I need to keep both the ASP's as well as the database on the server?
i am trying to put in images from the database and using something like:
<img src="I:/in_uni/<% response.write rs.fields('Image') %>">
but it isnt working.
also tried in:
<img src="http://cms-stu-iis.gre.ac.uk/ck227/test/in_uni/<% rs.fields('Image') %>">
but it still aint working!
I have a form with '/' in some of the field names, when I pass through to
the next page the field name comes back as though it's been htmlencoded, so
getting the value out of the field I need to convert this back to '/' with
the replace (same problem if I have a ',' in the name)
Is there an easy way to htmldecode or something what it converted to the
encoded versions? (I have written a short function to basically do all my
replaces for me, but I am guessing this isn't the ideal solution)
I have a database table where I managed to add with ASP an extra column which breaks down the previous column "text_data" and counts the number of words: Code:
View Replies View RelatedI have an app that I want to send out an email to each user in our member
list giving them their username & pw, but I don't want to overwhelm my mail
server since there are over 1000 users in my database.
I don't want to overwhelm my web server, either, having this app hog all
resources.
Luckily, I do have two processors running in this web server.
Note: web server and mail server are different boxes.
So... what kind of pause routine would you all put into my VBscript ASP
within the loop that sends out emails to all users?
If you have a href such as this,
href="somepage.asp?home=alpha&street=beta, how would you include a reference to a bookmark on that page, such as <li id="bookmark">Some List Item</li>
Is it possible to put the logoff/shutdown/restart buttons on an ASP page or something similar? If so can anyone point me in the direction of some code or where I can read how to do it?
View Replies View RelatedI 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.
I'm current working on a project which need to upload local data to
live server database.
Meanings that, i'm current having a server in my local mechine. I need
upload data from local database to live database which host at oversea
company. But i really have no idea how to do this in asp.
I have an application which loops through several thousand subscriber
records, compares each subscriber's requirements to a database of
businesses for sale, and then prepares and mails off an email
containing info from the database that the client is interested in.
Problem is that the ASP file exits as soon as it has sent about 50 or
so records to the Mercury/32 mail server on the local Ethernet. No
error message or program execution issues noticed. I then delete the
first 100 or so subscriber records and set the file off again. In the
loop thru the next 100 subscribers it prepares an email for approx
every second subscriber, then seems to hit this 50 max limit and
terminates again. Driving me crazy.
I figure that somewhere there's a queue building up which maxes
something out and causes some low level termination. To test that,
I'd like to build something into the loop thru the subscriber file
that causes a delay of 10 seconds or so before the loop starts again.
Code:
We have two applications for one system. The first application is a vb-app
and the second is a web-app.
From the vb-app users have the possibility to enter right into the web-app.
The vb-app is creating an appropriate url and opens the web-browser with
this. The url contains user-information like user name and password. We
don't want this url-information to be stored in the history-list, because
then advanced users can find passwords etc here and that's not so good.
I am retrieving data from html form, perform some math. calculations on it and now i need to put this data back to some presentable form to display in asp.Earlier I get the data from FORM in text format, convert it into double value, now want to put it back in text format for dispal.
View Replies View RelatedI'm trying to put my data from Access DB into a table, but, where I know how to do it creating one row per record, what I'm wanting to do is essentially extract each record into 1 cell, and then have the next record in the next cell, creating a table 2xn in size.
The data I'm getting for each record is a URL & a file location, to create an image hyperlink for each record, and need the images to appear in a table 2 columns x however many rows required.
Is it possible to put a variable in parameter for a URL? I'm looking to have a page with an input box and a link. When someone puts in a value in the input box and clicks the link it will take the value and pass it through the link to an asp page.
example:
Employee Name <input type="text" name="Tname" size="20">
<a href="emp_info.asp?e_num= Tname.value">Employee Info </a>
How can I get this to work?
I'm practicing making cookies and I've run into a small problem. I'm following this
Response.Cookies("name") = "Suzy Q."
I'm not using a physical, I want to load the information from a variable. all my variables that are not using letters work fine.
i've tried this: Code:
Response.Cookies("attyname")=attyname
and it will not get inserted into the cookie. how do i get the quotes around it like my example?
I know this is Visual basic code, but the response should be global. I one line of code that stretches from here to Mars. Infact, it was used to guide the last probe there. How do I make it go over seperate lines? Code:
View Replies View Relatedi need to put a date of the following format: 14 June 2003 into a text box. i have seen some samples but i can't get what i want. i tried the following: <%=FormatDateTime(todaysDate,0) %> and it only rendered 00:00:00 .
View Replies View RelatedI'm trying to create a VBScript using ASP. However I'm having
problems getting data from session variables into the right places.
The example I have copied below works, however I need to replace
"data1" and "data2" with real data from a session variable. Code:
Is there any way of setting the URL of the current page in a session
variable?
I want to do this so I can create links and redirects back to the page on
which the user invokes a particular procedure.
i need to put the records i'm getting from my query into a string, can someone tell me how to do this.
i've tried GetString, but thats not what i'm looking for, my query pulls up ID's and i need to put these into a string so i can split them up to be used in another query.
im making a simple site where people can add comments into a shoutbox. only ive had experience of people adding in html tags and javascript to redirect people away from my site and display images etc which im not interested in.
how do i stop this from happening? is there a way to intercept the form contents and kick out the code leaving plain text? or changing the code so it displays the real code using < and > ?
I'm new to ASP, I just started learning last week at an internship and I am taking interest to it.But at home I don't have a server to practice on.
My question is do I need to download a server and a database server, or are they both the same thing?Also, what is the best to download?
We have a server for our intranet and one that has this MS Access mdb database we need to use.So basicly we want our intranet asp page to show data from a database located on another computer in the same lan.
For some reason we can not use the database from the intranet computer.
We've tried so far:
-Direct approach with mapped drive
-Direct lan address.
-Linked access database on the intranet computer.
-Modifying user rights.
When one of these solutions are viewed on the intranet server, they work fine. When tried from client computers trough the intranet, we get error of thiskind:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'M:TSTOITProject databasedata.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/intra/db.asp, line 24
my company is having me design a website for them and I did it in ASP (Classic), with the backend database being SQL Server 2000. I open the connection just fine, and everything seems to work but there's just one problem:
It only connects to the database when I'm logged in as Administrator on the machine (or from a remote machine); if I use my own username/password, I get a 500 Internal Server Error. What's funnier is that if I set IIS to allow anonymous access, it won't let ANYONE connect to it.
Any ideas what's the problem? I think it's something with the connection string (I told it to use a Trusted Connection because otherwise it was saying "[Username] is not associated with a trusted SQL Connection), but since I haven't used SQL Server in the past it might be something with that, as well.
I'm trying to add records from the ASP web page to the database using SQL Server..but i'm not able to do it..Can anyone send me the codes related to the database connectivity..
View Replies View RelatedI want to know the structure of SQL server database table using ASP.Is it possible to know?I want know the exact datatypes also.
View Replies View RelatedI try to get data from a database which is on an other server. I can view the files on this server via the directory "t:" from the machine the ASP pages are on.
Constring:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=t:database.mdb"
Error:
't:Database.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
I just started learning ASP.NET and i need to learn to use the database for SQL Server 2000 quickly. First, (forgive me for my ignorance) what is a database? Do you guys know any good sites that teach you how to access the database for SQL Server 2000? and have tutorials, and sample code?
View Replies View RelatedI have an application where I have to import data from excel to SQL Server using ASP. If someone can please give me some piece of code it would be of great help to me as I am new to ASP.
View Replies View RelatedTo connect to the database I need to use the following string
myConnection.open "Maximum", "User", "limit"
where Maximum is the DSN
Instead of using that I have used the config.inc include file to connect to the database
Config.inc contains the script below ...
Im creating my first asp website and am wondering if asp (JS) works well with a MS SQL server. If so how do I connect to it.
View Replies View RelatedI suspect this is a rather easy one however. I recently moved a web site developed by MS Front Page and a SQL Server database to a different computer. Now when I "Submit" field data, it no longer populates the database.
I've checked the main index.asp file and the global.asa file to find out how to repoint the form to the database and I can't figure it out. Can anyone give me any pointers?
currently i m working on a web-based project using asp.net and mysql database. i using MySQL Connector/Net to connect my asp.net page to the to MySQL database server. My database is stored in the ftp server. In short, i m trying to connect my asp.net page to the ftp database server. Code:
View Replies View Related