Could someone highlight any known problems in converting an access 2000 to
access 2002 database....should I expect a painful transition or can I expect
a quick turnaround time to get my existing 2000 apps into 2002 format?
whats the access 2002 connection string?
View Replies View RelatedI am planning to design a database (destined for the web) that will have
between 20000 and 45000 records in it and will receive a lot of reads but
very very few writes (just from me).
Now the question is should I use:
1) The combination of Access 2000 (accessible through ASP or ASP.NET) using
OLEDB Jet
or
2) SQL Server 2000 ?
Of course I know that the SQL Server option is a better one, especially
since it's said that an Access DB can have about 9 users or so accessing it
at the same time. But is that a general rule or is it about many people
writing to the DB? In other words, if an Access DB has hardly any writes
and 99.9% reads can it be used as efficiently as it would be used on SQL
Server 2000?
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?
Does anyone know of a simple (and I stress simple as I'm a beginner with this asp stuff!!) script to allow for basic functionality of Add/Edit/Update/Delete ASP page which works with an Access 200 mdb. Something I may easily adapt for what I have??
I'm running Windows 2000 Professional with IIS 5.0.
What would I have to change in my code to make it work with sql, Just wanna see if its worth changeing to.
View Replies View RelatedI have created an Access database with an Autonumber field and set as promary Key. When I insert a record from my ASP web page it insists on making me add a value to this field.
Is there anyway to set this as an IDENTITY field.
how can i pass a parameter in javascript by referrence.
View Replies View RelatedI have an XML file that gets updated every 4 hours on a web server. I can check the XML modification time in ASP and compare to the databse. If it is newer, I need some ASP code to then import the XML into Access. Been trawling the net for an answer for a while .
View Replies View RelatedI have a database which inputs usernames, passwords, and email addresses into the database. I'm trying to create an asp page that lists the data for a specific user when they are logged in so that they can change details (password, email address etc) any ideas how i can retrieve the data and append the new data to the database???
View Replies View RelatedOur graphic designer is developing our new company website. We have switched
providers and currently she is working on the new website which currently
ressides on the new providers server as they support the ASP development
environment. Their server is a Win2K3 server.
She is writing an ASP module to connect to an MS Access 2000 database and is
having problems connecting. In this database there is only one table.
She has tried many different connection strings all to no avail and then
found from investigating that the best and fastest method is to use the OLE
connection string. However, each time she runs the ASP code she gets the
following error... Code:
what I want to be able to do it take data from one of my Access 2000 queries and automatically export that to an XML file. then that XML file is going to be loaded with Google Maps API for use. What options do I have in exporting the data in access automatically? would it be just implemented everytime i call the function, lets say an ASP page?
to give a little more (hopefully helpful) information, I want users to go to my site which has the Google Maps API implemented, and it will show them the rainfall and lake level data in my area. I figured XML would be best as I have seen someone implement a similar design in Canada using an XML file, however, I need to be able to get the
information from the query in Access so it can be loaded onto the map for people to see recent data. Again, I'm guessing ASP would be the best bet in accessing the data from the database.
I'm using sql server 2000 database and trying to access it using asp. when i installed sql server, i selected the mixed mode of authentication(windows and sql server). Code:
View Replies View Relateddoes anyone know of a free utility that allows you to alter/create tables through the web for access 2000. I'm talking about the table/db structure, not creating records.
View Replies View RelatedI have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error :
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2
The SQL statement is as follows: Code:
I have been doing adodb connections and using Access2000 for several lightweight websites. I have never had any problem with any of the SQL commands to insert, update, delete, etc.
I can insert a record into a memo field just fine ... up to a certain number of characters (nowhere near the 65K limit). After several hundred characters, the insert fails ... nothing happens ... the execute just idles and no insert is done. Anyone help? I have read about data types, etc., but everything I read sounds as if ASP and Access 2000 are suppose to handle the type conversions. They have been doing it up to this certain size.
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={SQL Server}; Server=;Database=pubs;Uid=myUsername;Pwd=myPasswor d;"
Instead of database, how can I set the DSN in this connection string?
DSN is DSNName. I am trying to connect to a SQL Server 2000 database.
Ive been using frontpage 2002 for my databse but would love to know more about ASP. Frontpage can generate asp codes but can anybody help how to use frontpage and at the same time create my own ASP codes for viewing database in ACCESS, add, edit, delete, update database. Also I tried using Frontpage for my database, but the problem is i cannt edit the codes for its so complicated.
what i wold like to perform is view the database in access in my browser, update on it, delete a record, edit it, and when adding new record, a new number for the applicant[its like auto number, i tired using ACCESS to auto number, its nice nice. =) i know there is a a way by using ASP.].
I'm having trouble with webbots in FrontPage 2002. How do I edit the Nav in FP 2002? I can only see the properties when I Right Click. The Nav was auto generated when I ran the Wizard to create a site. But how do I rename them or add to the Nav?
View Replies View RelatedI have a web application built in ASP 3.0 that uses data from SQL Server 2000 to generate Visio 2002 drawings, save the drawings to a file on the webserver and then send that file to the browser. We've successfully installed and ran the application with Windows 2000 server, Windows Server 2003 (Web Edition and Enterprise), Windows 2000 Professional, and Windows XP and with SQL Server 7 and 2000.
Now we've attempted another installation (IIS on Win2K AS and SQL 2K on Win2K AS) and we get no response from Visio. The Visio process is being started on the server, but it appears as if nothing happens after that. The administrator of the web server cannot end the process through the task manager either, which is rather puzzling. The script also does not seem to be timing out, even though we have a script timeout set for 30 seconds in the global.asa file.
I want to run an asp content management system. I was just wondering, does asp run ok on a linux based server with Microsoft FrontPage® extensions 2002?
View Replies View Relatedi'm trying to have excel open up a webpage which basically contains a
table.
in excel 2000 if i specify content type text/csv this works by
displaying an open/save dialog box and clicking open, launches excel
and displays data as a table (desired result ) however in machines with
excel 2002+ excel simply displays the html code.
trying to specify application/excel opens an excel plug-in inside the
browser which poses a problem becouse the excel has links to pdf file
that obscure the plug-in.
How do I set the default browser for VS.NET 2002? I tried setting the
default through windows...did not help. My project in VS.NET does NOT have
the "Always use Internet Explorer for debugging" enabled.
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 want to be able to show prices in £ to UK customers and $ for every one else. Is there a way to do this.
View Replies View RelatedThe following code gets me the day of the month which I use in a query to give me all employees' birthdays for this period. But I have a bug: day variable used in the query must give me todays date(19),it gives me 21 (2 more than I want)
<%
dWeekStart = cDate(month(dWeekStart) & "/" & day(dWeekStart) & "/" & iYearToday)
dWeekEnd = cDate(month(DateAdd("d", 6, dWeekStart)) & "/" & day(DateAdd("d", 6, dWeekStart)) & "/" & year(DateAdd("d", 6, now())) )
sql = "SELECT * FROM bday WHERE maand = "&month(dWeekStart)& " AND dag >="& day(dWeekStart)
%>
I could really do with some guidance. I am currently hosting my website on a Windows Server, and use ASP pages for accessing MS Access database data and also CDONTS for forms to email.I was just wondering if I were to swap to Linux hosting, how easy or hard ( would it be to change these pages from ASP to PHP with the exact same functionality.
View Replies View RelatedI created a form to allow a visitor to add a new record to a database with the recordset object. Is there any conversion that needs to take place from the form input fields the user gives me to the recordset object? One of my form fields that I have is going to contain a money datatype in my SQL database and so far it's giving a 500 error.
My code in short looks like:
strCurrentPrice=Request("currentPrice")
then upon adding to the database the code looks like:
rsAddCards("currentPrice")=strCurrentPrice
I am calling a recordset from sql which happens to contain one column that is a datetime in the format: DD/MM/YYYY HH:MM:SS. So when I call that column from the db, it displays in the same format within my page.
However, I would like to be able to display the datetime as part of my recordset, but in a more aesthetically pleasing format (i.e: Sunday 1st May 2000, 7.23PM)
I have tried using the formatdatetime() function along with my rs, but this causes syntax errors. I know this is probably dead simple, but I don't get it!
I have a money datatype field in a SQL Server database.
I use the following method to take a value passed in the Request.Form collection and convert it to the double datatype:
cmd_AlloUpdateM2__incrdecr = Request("incrdecrA" & a)
cmd_AlloUpdateM2__incrdecr = replace(cmd_AlloUpdateM2__incrdecr,"$","")
cmd_AlloUpdateM2__incrdecr = replace(cmd_AlloUpdateM2__incrdecr,",","")
cmd_AlloUpdateM2__incrdecr = cdbl(cmd_AlloUpdateM2__incrdecr)
I keep getting a type mismatch 'cdbl' error on the line:
cmd_AlloUpdateM2__incrdecr = cdbl(cmd_AlloUpdateM2__incrdecr)
What's weird is I use this in other sections of my code and it works fine...no error. I've checked and re-checked the code and can't find the why this is happening?
How can I convert seconds to hh:mm:ss format? e.g. 123456s = 34:17:36
View Replies View RelatedAnyone have any code handy to convert a binary number to decimal and a decimal to binary? I need server-side code to perform these calculations. For example, I'd like to be able to pass 129 to a function and it will return 10000001. Likewise, I'd like to pass 10000001 to a function and get 129.
I can do this on paper, just not sure where to start on how to pass these numbers into a function to perform the calculation.
I am in UK using XP with date format set to dd/mm/yy. I am running an asp
site from a server in USA, which is returning the date from a database field
retrieved as objrec("todate") in US format mm/dd/yy.
To rectify this so as not to confuse visitors to the site I am trying to get
the date displayed as dd month yy , e.g. 25 January 04 by using the format
function format(objrec("todate"), "d-mmmm-yy"). This returns me a VBScript
runtime error "Type mismatch: 'format' "
The data base field "todate" is stored in short date format, which should be
OK shouldnt it?