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.
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 View RelatedI'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:
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.
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?
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?
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).
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 ?
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?
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 Relatedthis 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
Anyone over here ever Migrated WebWizForum from Access to MSSQL?
View Replies View RelatedLet 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.
I have one 3 tier architecture application running on Windows 2000 Server.
I have created replica of same machine on another machine where OS is
Windows 2000 Advance Server.
But when I port same running application on new machine i.e. Machine with OS
as Windows 2000 Advance Server, my middle tier (Active-X Dll, COM+
application) fails.
It throws common error
Invalid Procedure Call or argument
What could be the problem? Do I need to change any settings for running
application on Windows 2000 advance Server.
I have a Development server that is running Win2k, IIS 5.0, and ASP enabled. I am trying to gain access to an Access 2000 DB located on a file server within my domain. I'm pretty sure I have all the correct permissions set, but I am having problems when trying to access the DB.
The error is similar to:
The Microsoft Jet Database engine cannot open the file '******'. It is already opened exclusively by another user, or you need permission to view its data.
I'm looking for ways to fix this... Microsoft suggests turning off the ability for IIS to sync passwords. Unfortunately, this is not a viable solution for me.
Is it possible to create a new virtual server that is a share to my file server? Put my ASP and MDB file in there and have it work? Anyone have any other ideas?
I'm working on a site that inserts records into an Access database and Access assigns an auto-incrementing id for the record. How can I quickly figure out what id that was just created? I seem to remember there being a function for this....
View Replies View RelatedI want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
<code>Dim MM_connPang_STRING
'MM_connPang_STRING = "dsn=pangDSN"
MM_connPang_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:clientdatabasepangDB.mdb"</code>
I'm trying to access a table in a MS Access database using ASP but the name of the table is causing me some trouble. The problem is the table name has a space in it eg, "My Table".
If i try and access it using a query "SELECT * FROM My News", it says i cant find table "My". If i remove the space from the name (to MyTable) it works fine. But the trouble is its a customers database and i cant easily rename it because its linked to other tables and db's.
How can i access a table with a space in its name? I've tried "SELECT * FROM My_News" but that doesnt work either.
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
What is this all about? Generally I run against SQL Server but now I have to use access. The query I want to run is a simple double join
SELECT tblArtists.*,tblGenres.name AS genreName,tblPages.pageId
FROM (tblArtists
INNER JOIN tblGenres ON tblArtists.genreId = tblGenres.genreId)
LEFT JOIN tblPages ON tblArtists.artistId = tblPages.artistId
ORDER BY surName ASC, firstName ASC
Now If I run this question in access against the database it accurateley returns two posts. BUT When I paste the same query into an asp document and runs it with a fileDSN against the same database it returns nothing!? Is this some kind of joke from Microsoft?
I have an Access DB which contains couple of link tables. All these tables are from different databases. So each one has it's own database password. Since there is no way to save the password during the DSN creation. Then you need to manually type in the password each first time when open the table.
This causes the problem in ASP code during run a query. Since the table cannot be accessed due to the password protection. Is there any statement than can open a table and meanwhile pass the password in? Does anyone experienced with the similar situation?
I generate my codes using a generator. My problem is that I can not write into my Access database. I had gone to tools to allow access permission . still nothing.
View Replies View RelatedI have a MS Access file that consits of 500 movie titles, I already upload this file onto Brinkster.com, but I don't know to code this into ASP or PHP so I can have an on-line database. Please help me code this Access file into an ASP or PHP file.
View Replies View RelatedI have a field in my Access db which is used to put a category against a company, rather like Yellow Pages. The categories are held in another table in the same db. The Category field in my companies table is a look up field using this syntax
SELECT [categories].[ID], [categories].[Category] FROM categories;
My problem is when I want to list a company and do a response.write rs("Category") I get the ID relating to that category rather the description. How can I get the description instead?
I am using Access and ASP.I am just trying stuff out.I created an access database and put some validation in access on some fields.
I created an ASP program to insert into my database.
When I try to insert a record that validates OK with access rules all is fine.
Then I type input that violates the access rules; I hoped to get a helpful message back.
All I got was my message saying an error had occured and it was Error number 0 and native error 2097228.
As I was testing I know it is due to failing a validation in access.
I am learning I wanted to look up this native error, I cannot find it in access help or internet searches where would I look for native errors please?
I know I need to validate client side that is not the issue it is understanding native errors!
I'm trying to search the Access database using 3 fields and I think there's a problem in my If statement...pls check it out for me.....I'm using ASP...this is what I'm trying to do:
If Request.Form("txtUser_Id") = "User_Id" and Request.Form("txtWeekNo") = "WeekNo" Then
strSQL = "SELECT (MSD + Methods + Analysis + Architectures + Models + Studio + Elective1 + Elective2 + Elective3) AS PersonTotals, FirstName, LastName, WeekNo, Semester, StudioTeamName FROM tblpersons"
strSQL = strSQL & " WHERE Semester=" & Request.Form("DaInBox")
'strSQL = strSQL & "WHERE Semester ='" & strSemester & "'"
End If
I'm planning to change my database from MS Access to an SQL database. So, what do i have to change in my code for that?Is it possible to have multiple tables in SQL which are linked to each other?Are there pro's and contra's ?
View Replies View RelatedI made a little app that selects data from a database depending whether there is a NO, in the YES/NO column. The data is exported to a txt file with aso. What i'm wondering is, is after the data has been downloaded to that txt file, how to write to the database saying all they were marked NO, go to YES.
View Replies View RelatedI have never dealt with XML before, So this is way out of my realms...
I am trying to get a XML feed into an Access Database..
The XML source can be found here:-
but as you can see.. there is another problem.. the file is in a .GZ format.. so i need some way of Un-Zipping it onto my web host, and then importing the XML data into the database..
Ive looked around, and the only information i can find is un-zipping it onto a local machine, and then uploading the XML file.. but that's not practical.. i don't want my web page to be dependant on my PC at home being logged on...
As for the import of the XML to Access... that's another black hole there.. ive never done anything like this before..
I'm still very much on the learning curve when it comes to writing ASPs and have always used Access for my db. A colleague in work has told me that I should never use access on a commercial site where I'm likely to get a lot of traffic. Is this correct, is Access totally unsuitable?
View Replies View RelatedAlright, I am opening an Access XP database via ASP. One of the fields is a numerical field, and I would like to force it to display the number + 1 digit to the right of the decimal. For some reason it is only displaying digits to the left.
In Design View, my Access Table (names 'arlist') looks like this:
Field Name: level, Data Type: Number, Field Size: Integer, Format: Fixed, Deciaml Places: 1
My SQL Statement: SELECT * FROM arlist;
Then the VBScript I'm using to access the table looks like this:
Response.Write"<TD align=""right"" bgcolor=""" & strBG & """ width=""10%""><P class=""body"">" & rsDC.Fields("level") & "</TD>" & vbCRLF
I am opening the table via ADO Statically with a Read-Only pointer because the page just displays the contents of the table. I've tried everything I can think of to preserve the decimal place. If I view the table in Access, the decimal places are correct.
I'm trying to connect an access database to a asp page, but whatever i do, it just doesn't work. Code:
View Replies View Related