Migrating Data (MS Access)
if i have 2 datasources with different table names and column headers that i want to merge i.e. "ptitle" and "name" whats the best way of doing this? are there any standard routines or should i use something intermediary like xml?
View Replies
ADVERTISEMENT
i will need to change my current Access backend to MS SQL 2000 Server. I have never done this before and I ve been told some queries change and some operations like JUNCTION etc, change too or at least act a little bit different.
I would like to ask to you people all sorts of suggestions, steps to follow, tutorials, etc,, you know, just all sorts of help to go through this without getting a headache.
View Replies
View Related
I'm now receiving this error:
Microsoft VBScript runtime error '800a01a8'
Object required: ''
login.asp, line 9
Worked fine with Access. Can somebody help me tidy up my code. login.asp below. Code:
View Replies
View Related
I am planning to migrate my exisiting MS Access program that uses yes/no
fields (checkbox). Can ASP identifies checkbox field of ms access? I am
planning to use the same database and use msacess for report generation and
web browser for encoding to the database.
View Replies
View Related
We are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.
THE RESULTS:
(returns a blank page with only HTML Titles)
THE SCRIPT:
(you may notice this is a modified sample script): Code:
View Replies
View Related
We have a huge fat client database enabled application.
It is a MDI app with a very rich graphic interface and hundreds of different
screens and dialog windows.
There is a lot of client side processing, validation, file manipulation even
interaction with 3rd party apps (i.e Microsoft Office).
Is it possible to migrate this type of an app to run as a Web app using ASP
..Net?
Are there any 3rd party frameworks/libraries that could be used to
accomplish this?
View Replies
View Related
have a simple asp program that works fine from IIS. It's made up of 2 asp files and one MS Access database. One asp file execute just fine, it executes its code and dumps the html results onto the asp file I point to in the browser.
But on an ISP's site, after uploading the 3 files, the execution doesn't happen. The asp file I point to using a typical URL, shows only and as expected a couple of lines at the top of the page. The execution below that however, is not happening, and what I see normally locally just isn't there. What gives?
View Replies
View Related
My client has the need to upgrade to Windows 2000 Server from NT4 but are
concerned about whether there existing custom code (ASP,VB6,MTS, etc) will
work correctly once migrated.
Does anyone know where I might be able to find information relating to what
functionality has been deprecated in Windows 2000 Server since NT4 (I know
CDONTS is one of them).
View Replies
View Related
Whats the estimated time frame for an experienced asp/vb developer to get a
handle on asp.net in a comercial environment Im just looking on advice ?
View Replies
View Related
I promised a friend that I'd help him move his site over to a new server. It uses ASP and an MS SQL database and is on a Windows server. I moved his files over and for some reason I'm getting the following error and was wondering if someone could help figure out how to fix it.Code:
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/default.asp, line 86
Here is the code where the error is generated from (the recordset is line 82):Code:
function rs_readonly( sql )
dim rs
set rs = createobject("ADODB.recordset")
' rs.cursorlocation = adUseClient
' response.write( sql & "<br>" )
' response.write( "<p>" & sql & "</p>" )
rs.open sql, connection, adOpenKeyset, adCmdText
set rs_readonly = rs
end function
Also, this is in the global.asa file. Can somebody tell me what this means/does?
View Replies
View Related
what all things to be taken care while migrating asp applications which is currently running under WIndows NT , IIS to Windows 2003 IIS.
View Replies
View Related
this is Aravind from hyderbad. i am working on application which we are migrated asp application from WIN NT to WIN 2003. Here iam facing some problems.
here iam loading .asp file as image on another .asp file to display data in chart. this is working good in WIN NT but it is not loading in WIN 2003.
iam giving html tag which we used to load the image
<img src="abcd.asp"> (this .asp is in the same directory)
but this is not loading.
Is it the problem with WIN 2003
View Replies
View Related
Anyone over here ever Migrated WebWizForum from Access to MSSQL?
View Replies
View Related
Let me first apologize for anything that makes me sound stupid. I'm really not a ASP programmer, but i am the one fixing our glitch.
First, let me explain whats going on. We have a company intranet signout board. And under our IIS4 server, it works just fine, but under IIS 5 its works except for one glitch. The board lets the user choose their name from a databse, and enter a date and time of leaving a arriving.
On the old server, if the user just entered a time, it automatically added the current date followed by the time. Now, if the user just enters a time, that all that is displayed, and for some reason the board will only allow one name to be displayed like that.
So if person A signs out with just a time, he is listed, until person B signsout and overwrites person A
I think i have narrowed the problem down to this
If FormatDateTime(Request("txtReturn" & intIndividualPerson),2) <> "12/30/99" Then
rsUDPerson("OutReturning") = Request("txtReturn" & intIndividualPerson)
Else
rsUDPerson("OutReturning") = Date & " " & Request("txtReturn" & intIndividualPerson)
End If
The idea is, if there is a date, it wil be different then 12/30/99 so nothing is changed, but if no date if there it adds the current one. It almost acts like there is no Else statement.
View Replies
View Related
This is my query.i have a access database, hooked up to dreamweaver mx. inside the database are 3 tables. sun/moons/planets. the planets table is linked to the moons table. In the planets table are the fields:
planet name;
Text_1;
Text_2;
planetID;
Distance;
Pic_1;
Pic_2;
What i wish to do is from my index.asp page click on a link which then displays the planet and EITHER text_1 or Text_2, and seperately Pic_1 or Pic_2.
I have tried using random nos 1 or 2 but i dont know how to pull the number and access the right table/field
View Replies
View Related
i want to display DATA stored in Access DB by using ASP script.i can read data from access so that task is only to display data is a list like.i have a record of some users and i just want to display the users name in a list.how can i do this.
View Replies
View Related
i want 2 asked 2 howwe can acces the data from database using combo box.and how we can save the data to the database from combo box.
View Replies
View Related
i am working on a interanet application for Inventory handling, i have a problem while submitting the data to server, the problem goes like this
Data base : Ms-Access
Front End : ASP
how to comit the data "say Invoice" to main database is two persons tries to make invoice at same time at different computers, How to maintain the series of Invoice unaffected, how to allocat Invoice number to them, and how to put a check that both of them can't make a invoice of same customer at a same time at different computers.
View Replies
View Related
is there anyone use asp to acess data in db2?
i am wondering if there's oledb provider for DB2? and where can i get it ? we use asp, not asp.net , therefore we can't install .NET framework , is there any other solution ?
or i can only do that through ODBC ??
View Replies
View Related
Im trying to write some asp code to copy MS Access Data into an Oracle database. I have one connection open to the access database but when I try and open the oracle connection it says that the ms access tables does not exist.
Basically what Im trying to do is get the data from a row in the Access db and insert it into a row in an oracle db.
View Replies
View Related
I am using winXP pro + IIS5.1 to develop my site offline.
My data is in a folder outside the web, and I am told "my IUSR account needs
to have read/write/modify NTFS permissions to the directory housing the
file"
I can find no info on how actually to do this. Can anyone explain?
View Replies
View Related
I'm attempting a login script where I first authenticate a user's login info for a valid connection. When I use a valid ID/Password everything works. When I use a bad user/password I get an error page stating the login failed.
I would prefer to redirect the user to another page on a failed login. This is the part that doesn't work. I'm new to ASP and JavaScript, but have done this kind of thing with PHP with no problems.
View Replies
View Related
I have a datbase (db2.mdb) on the server
Here is the information:
DB name-Addresses
Input - user
Input - password
Here is the script that I'm using to try to view, unsuccessfully, the user in this database. Does anyone see the error? Code:
View Replies
View Related
I'm using Dreamweaver MX with ASP VBScript and using a MS Access Database. For about the longest time now, I've been trying to make a Mailing List form online and when you submit the data, [data] goes into the Access Database.
The Form is obviously working fine, although sometimes I do get errors, I'm mainly trying to get this data skullduggery working. Is that even possible (with ASP even)? I have to use ASP and I can't use SQL (because I would), but I think my n00b self has tried everything I could think of. Code:
View Replies
View Related
I have an access database with about 5 tables. One of which i want to populate data to. Specially 1000 enties at one time(In this example im adding employee numbers to a database table. Initially i want to add the for the employee name field " Unassigned" and when i ready to append a real employee name to the fields add if through a script(Can this be done?
Or is there a better way to do this?)This way, in my script i can call one of of those 1000 entries or employee numbers from a dropdowlist (ex. 1-1000). This way if go to use one of those entries from the dropdownlist the database would not get the " EOF/BOF error ". What logical suggestions do you guys have ?
View Replies
View Related
My code show no error but the record cannot appear. My code =
if request("tarikh") = "" then
tarikh = Date()
else
tarikh = request("tarikh")
if isdate(tarikh) = false then
ralat = "Sila masukkan tarikh dalam format dd/mm/yyyy"
tarikh = Date()
end if
end if
sql = "select * from audit_trail where cstr(tarikhlogin) = '"&tarikh &"' order by masalogin desc"
set rs = conn.execute(sql)
response.write sql =
select * from audit_trail where cstr(tarikhlogin) = '04/02/2005' order by masalogin desc
Storing record have no problem but this code cant display any data.
View Replies
View Related
I have an Access database containing 10 Tables with a lot data in each Table. I need to copy the database with no data in another directory. Is there an ASP code or object that allows me to clear data in all Table at once? How can I clear all data from Access DB?
View Replies
View Related
I am having a problem with entering long ammounts of information (roughly 400 characters) into a database. The database field is set to memo.
Seems that whenever I want to enter strange characters it gives me an error. (I need to enter strange characters for an important reason).
Also I am having some problems with using ASP on Netscape (not testing...just clients are having problems). Does anybody have an idea of whats going on??
View Replies
View Related
How can I retrieve data from Ms Access Database which is located in another computer over the network.
View Replies
View Related
I am trying to retrieve some data from a table which is the link table from another Ms Access database of my network computer but i got a error message "It is already opened exclusively by another user, or you need permission to view its data."
View Replies
View Related
I have an intranet application written in asp using access as the backend database. My users have requested they be able to download certain data into an excel spreadsheet. I have limited asp experience and could use some help.
Ideally, the user would be prompted to save and name the file (save as dialogue) and then the data would be selected and saved into that file. I know I can use a select statement to select data directly into an excelspreadsheet using:
SELECT * INTO [Excel 8.0;Database=" & lcPathFile & "].[Sheet1] FROM myTable
But I'm not sure that is the right approach.
View Replies
View Related
I have 40 different users. Each user manages a subset of the total database. Currently I have a pull-down menu to let the user select their subset and then manage the data within it. I'd like to use their login info to pre-select the subset so that they have access only to their assigned areas. How do I "send" the subset name from one asp page to another? the db is "2004" the table is "Students" .
View Replies
View Related
I have an MS Access database within the same folder as the web pages on my IIS server. I input data into the forms but the data isn't being saved to Access. Is there a problem with this code?
View Replies
View Related