Im changing from Access to SQL Server and had a few questions:
What is the Equivalent in SQL:
Access: Memo Field
Also, for my Autonumber field, which is Identity in SQL Server, why can I only go up to (int) 4 in Length for SQL Server?
I want to do one of two things and I not sure which until I know the difficulty level (knowing a little asp but not alot) of each. I am helping in the office and we will have several small access dbs using the FrontPage forms methodology.
So, now that I have some data bases, I will want my users to be able to 1)copy the database to their own machine where they can massage and do whatever they need to with the data, or 2) perform a query against my data bases, and have that result sent in db form to their machines to do whatever.
I've seen somewhere that asp has some file system components but am not sure how that
works. I am willing to read and figure it out if I can get a push in the right direction.
Is it poss to move records from one table to another using ms access db to arcive records and how would i do that.
View Replies View RelatedI'm currently migrating an ASP/SQL 7.0 site that runs on Windows NT 4 server to an ASP/SQL 2000 platform running on Windows 2003. The current server resides in Orlando, FL. The new server will reside in Miami, FL. Here's a recap.
Old Location/Server:
Orlando, Florida
SQL 7/ASP/Windows NT 4
New Location/Server:
Miami, Florida
SQL 2000/ASP/Windows 2003
Along the way, many apps are breaking (which was expected). I've successfully recoded CDONTS to CDO and I'm slowly working my way through 1999 code.
I also found out the hard way that you need to explicitly tell Windows 2003 to run ASP pages or it will ignore all calls. I also performed the User migration steps from SQL 7 to SQL 2000 which was a breeze with the help of the Microsoft knowledge base. Code:
this is the code I am using for MS Access
Code:
mydb="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("database.mdb") & ";"
set conn= server.createobject("adodb.connection")
conn.open mydb
I want to know what code I can use to connect via MS SQL,
I tried this one,: but no luck
Code:
mydb="driver={SQL Server};server=YOURSERVER; UID=YOURUSERID; PWD=YOURPASSWORD; database=YOURDATABASE"
set conn= server.createobject("adodb.connection")
conn.open mydb
Looking for the best resource (book, online article, etc) for moving from ASP 2.0 to ASP.NET. I'm ready to make the jump. What do you think?
View Replies View RelatedDoes anyone know how to code a button that when hovered over moves. Then maybe on the 3rd roll over it will not move and actually allow the user to select it?????
View Replies View Relatedi have this in the database section of devshed - but noone seems to know... so i'll put it in here now
View Replies View RelatedIs it possible to moves files to and from other servers in ASP?
I'm in the process of incorporating a VBS script into ASP that used to
do this job for me. However the VBS script was setup to run through
Task Scheduler as a domain user, which allowed it to connect to remote
hidden shares.Or alternatively, could I leave the VBS script as it is and have the
ASP page execute it on demand somehow?
How would I go about reordering records in a database? Say for example, I wanted to change the output of something, and I could just click a link which would move the record up
View Replies View RelatedI have to move a file(Excel file) to a folder that resides in
a different server using asp. how do i that. I tried using
move file method in file system object, it says
file path not found.
i have 2 rows in the table... and i wan to do a response.write("REMARKS")
the remarks sumtimes can be longer then the width of the table...
how to i make it such tat when the max width in row 1 has been reached then it will carry on writing onto the second row of the table???
<table border="1" width="100%" id="table1">
<tr>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
</tr>
</table>
where to place the response.write or how to add in additional codes to achieve this function?
I have a web site and database is on SQL server,now I need to move it from this server onto another one that is on a different location as well.This process is completely new to me,would somebody have an advice or a link where I could read some info about doing this, as I am not sure where to begin.
View Replies View RelatedI have a freind who wants to convert his ASP site (with a HUGE MSAccess database) to MySQL etc. so he can move to a Linux server.What all would be involved in the conversion? I have redone an ASP site to .xhtml and .php but there was no database to deal with.
View Replies View RelatedI don't know anything about the ASP language. One of my client's would like me to host their website, already created with ASP. Down the road, I need to re-design the site and convert the back-end to PHP. However, suggest the best method of moving the entire site to my Windows 2000 server?
View Replies View RelatedI currently have the below working they are testimonials, displaying 1 every day and therefore i would like be able to page through them from clicking a next> or more> link also
if WeekDayName(weekday(now)) = "Monday" then
Response.write("")
else
if WeekDayName(weekday(now)) = "Tuesday" then
REsponse.write("")
I need to move some SQL tables from one unresponsive ISP to our new mo bettah one. Naturally the current host is not being quick about getting a cd of our tables to us. I was going to write code to move them from one place to another but it is not so easy. If it runs on the old server it can't access the SQL on the new server and vice versa.
The alternative that I see, is to download them into text files and rebuild them on the new server but that is a lot of work. Any quicker fixes out there that anyone knows about?
If I have a page. And I want to move this. What is the best way to do this while preserving the rankings in Google (and other search engines)? From what I've read, I want to send HTTP 301 (Moved Permanently) when the old URL is accessed. But I believe Response.Redirect sends HTTP 302 (Moved Temporarily).
View Replies View RelatedI have an asp page that has 12 tables, 3 tables per row, . Im trying to get my query to fill each table with 6 records and then move to the next table with 6 records...etc then after the 3rd table start a new row. I know I have seen an example of this before, can someone point me in the right direction?
View Replies View RelatedI'm trying to build a quiz site. The page would show 1 question at a time. Basically the questio and the 4 options are being shown in tabular format. Now I want to use the same table to fetch the next set of records.
how to reuse the existing table to wipe out the previous record and to display the next record without losing the page variables.
hen administrator logs into the system, they can view all of the members' details. So they search for a member by id/name and the members details are brought up. From THIS page I have a button "Get members records" which is to display the records in the system for that member.
The button at present calls the getRecords.asp file which shows the date and has a change date calender js function. (this works fine) What I want is for the administrator to choose a date from the calender and to see the users record for this date without having to go to another page.
It would be easy to have them choose the date on the previous page and then see that record, but is it possible to have them choose the date and then automatically get the figures displayed in the text boxes, all on the same page
i try to move an entry to another table.
Microsoft JET Database Engine error '80040e57'
The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.
/searchsrv/searchsrv.asp, line 315
Any ideas on how to solve this?
I'm moving a ASP-site that my brother has done from a Linux server running ChiliASP to a Win2003 IIS server. Almost everything works fine, but one page doesn't load. Calls to the function datum_6_siffror doesn't work. Code:
View Replies View RelatedI have created a recordset with cursortype 'adOpenDynamic'. i have used "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=abc;Initial Catalog=myDB"
connectionString to open connection.
The problem is that ASP renders Operation is not allowed in this context' error when i call the moveprevious methord of that recordset. I have discovered that it doesnt move previous when i used a joined query. and it works perfectly when i use single table query. the recordset code is:
Set client = Server.CreateObject("ADODB.Recordset")
client.ActiveConnection = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=abc;Initial Catalog=myDB"
client.Source = "SELECT * FROM customer c inner join business b on c.id=b.cid"
client.CursorType = 2
client.CursorLocation = 2
client.LockType = 3
client.Open()
I have a table that's holding 'open data' until it needs to be moved to another table where it is then 'closed'. I think I have my SQL statement correct to do this, but I keep getting the error below.
Quote: Originally Posted by Error Message
[Microsoft][ODBC Microsoft Access Driver] Number of query values and destination fields are not the same.
I have verified that I have the same number of fields in each table, but I think the problem is both tables have an Autonumber field and obviously you cannot move one autonumber field overtop another one. What is the easist way to exclude my autonumber field from being inserted into my other table without having to call every single field by name in the SQL statement? Code:
i have a formular using two text field. i want , when i finish writnig , moving to the next using " Enter " key.
View Replies View Relatedok i have a number lets say its 36 and i want to divid it by 150.... 0.24 returns... i want to change 0.24 and make it a percent to it would be 24% how would i do that...
View Replies View RelatedI have an Access DB connected to an IIS via ODBC, and use ASP pages to get info to/from the DB. My guys in IT now want to migrate the Access DB to SQL Server. Can anybody tell me what this implies in terms of :
a) syntax of my ASP pages
b) syntax of my SQL statements
c) other problems I may not have thought of.
I am told it is really easy, however, I just cannot get is to work. BTW, I have activated the "SQL Syntax" option in Access, in case that helps any.
This might be more of a database question than ASP. But when you create a database and then create relationships with the database, once you open an asp page say to create a new record; once the record is saved, shouldn't it also update the relationship with the table involved?
Unless I am doing something wrong, it is not updating the second table; for example:
rs.AddNew
rs("username") = Request.Form("txtUserName")
rs("password") = Request.Form("txtPassword")
rs("firstname") = Request.Form("txtFirstName")
rs("lastname") = Request.Form("txtLastName")
rs("email") = Request.Form("txtEmail")
rs.Update
Response.Write("Record has been added!")
Say the information is entered, because of the UserID field is "autonumber", that would be my primary key: so "1" would be related with the second table where I have:
upload.id (PK)
userID
Upload1
date1
Upload2
date2
Upload3
date3
If on the other table I have number of uploads to generate, whenever it adds a document, it would have the relationship of the username, and the upload:
But when I do that, even adding the code, it does not update the code. So what am I doing wrong? Do I have to do another Add.New at the same time for the second table?
I ask this here because as ASP Developers I figure you have more experience with windows Webhosts. I know Phpmyadmin is usually provided on Apache platforms to manipulate MySQL databases. What interface is usually provided by webhost to access and manipulate your Microsoft SQL databases?
View Replies View RelatedI have a database with the columns:
id
name
phone
I have a web form with three textboxes and a button. How do I move through the records by clicking on the button. e.g, the page loads with the first record in the textboxes, if the button is clicked it displayes the second record, if it is pressed again it moves to the third record and so on.
I have used ASP code to load data into two select boxes. The code below is used to move the selected data back and forth between the boxes.
I am having problems retreving the data from the boxes after the user has moved any of the data:
If the data has been moved by the below code; when i try and load the data back into the database i cannot retrieve the data using:
request.form("Clients1").item(1) and it will not show up using
request.form("Clients1").count
If i dont move the data i can retrieve it using: Code:
Is there a way to force a sub or a function to be executed before the
user to move to another ASP page?
In fact I want to update a basket (table) if the user wrote a quantity
for a product in the page. I want to avoid them to click for every
single product they add.