Hi On my local server the physical db path is "C:/Inetpub/wwwroot/StaffDiary/Cal.mdb". I am using the virtual path as conn.Open Server.MapPath("Cal.mdb") but I am getting a; Microsoft JET Database Engine (0x80004005) Unspecified error error. What am I doing wrong? Thanks Regards ...more >>

Hi I am getting an unspecified 0x80004005 error accessing my access db. What steps can I take to find out where the problem lies? Thanks Regards ...more >>

How can I export my access db structure (and query/procedure), and import them to mySQL db? In SQL Server, it has function to 'Generate SQL'. In Sybase Watcom, it has 'Unload database'. ...more >>

Hi I really don't know anymore how to solve this problem. I bought .NET thinking i can debug my way out of it but still no cigar. This very simple piece of code does not work: Now here some things before looking at the code: 1. In .NET and IE and IIS I've set all possible debugging ...more >>

Hi All If this should be in .asp.general rather than db please accept my apols. It is based round a problem with my ASP/MySQL DB so hopefully I've posted correctly. I've created a CMS that allows the user to upload their own company logo gif (to be displayed top left of every page) and thi...more >>

Hi I have a very simple script that seems to work OK inserting into an Access table from a CSV file. The problem I have is that the first column (stored as text) has student ID numbers - some start with 100... others start with a character like K or M. It inserts the 100... IDs but not t...more >>

Applies to: Microsoft FrontPage 2000, Microsoft Access 2000, IIS 5.0 Operating System: Microsoft Windows 2000 Professional I am trying to protect a portion of a web site by allowing users to = register a username and password & then login with those details, but so = far I am having only margi...more >>

I want to take the post data from a form, validate it etc and then post it out to another page.(on a different site) Is there a way in vbscript to post a form automatically i.e. user completes form & submits via post Process data & validate Post data to 3rd party page Thanks in advance ...more >>

I seem to recall reading the SQL Server DE can be used to develop SQL Server DB's, however the information now suggests that that is not the case. I'm looking at using a SQL Server DB for the backend of my website. What do I need to purchase in order to be able to develop the db on my laptop...more >>

I am developing a web based application that will have about 1000 users. It will be hosted on a Windows 2003 Server and written in ASP, ASP.NET. Which database should I use and why? Access 2003? MySQL? Oracle? Microsoft SQL 2000? Thanks, Jerry ...more >>

an app i've written using FP2000 and Access 2000works well enough, but the server, after a few days, slows down and needs to be rebooted to speed things up again. some of the pages i've written use the wizards in FP, but many of the update pages i've used by writing them in just ASP. I *think*...more >>

Hi All I know this is a 'try it yourself' thing, but is it generally true that in-line query (A): strSQLQuery = "update accounts set fred='" & strfred & "',bob='" & strbob & "', etc is not pretty to read as one long string, BUT a lot faster to execute than in-line query (B): strSQLQue...more >>

I am wanting to change the web site for the company i work for into a database driven web site. This isn't a problem as i have created several ASP areas for the web site. What i want to do is re-write the website so it is easier to manage. It needs to use style sheets to make it easier to up...more >>

I'm having the weirdest problem. I have just installed sql server (msde), vs.net on my laptop. I copied all my databases and websites to the IIS directory so I can serve the pages. I'm getting the error below. When I try to view the pages, I get this error. I read the aspfaq and tried...more >>

I know this is an easy script. I used to know it actually, but forget it. Before updating my DB with the new entry... i want it to check the username field, to see if the username that someone is trying to register with already exists. I used to know this if then statement. But just getting bac...more >>

Hi I am not even sure if this is possible, maybe somebody can help. I am making a site for a car dealer, they have some software that they use to store all information about their vehicles. The software has the ability to export the information to a csv file, Is it possible to make an asp p...more >>

Hi! I'm accessing an MS Access database from an ASP server. I just added a new text column (field) to one of my tables. I have not added any data to this new field in any of the rows. I read the field in and compare it to "" and it's coming up as false. How do identify the empty fields?...more >>

I have a stored proc which checks for errors, and returns the error value as a return code/value. how can i 'read' this from my asp code? Should I return it as a recordset instead? Here's how it currently is:- SP snippet: SET @Err = @@ERROR RETURN @Err ASP: Set conn = Server.CreateObjec...more >>

Will the object variables of Connection, - Server.CreateObject("ADODB.Connection") Recordset - Server.CreateObject("ADODB.Recordset") and Command - Server.CreateObject("ADODB.Command") be automatically released after the asp page finished running or error exception (e.g. the database get d...more >>

Hi all, My application is based on old ASP (not .NET). I have a page which should display several DB records and allow inserting/updating/deleting. I'm looking for the best way to enable it. If anybody knows an elegant way and could direct me to some good relevant resources, it will be a great he...more >>

Hello, I need to delete some records and insert new ones right away. Is there any way to do it within the same query string? Set objRecordset = Server.CreateObject("ADODB.Recordset") QueryString = "delete from Tbl_Therapy where proceduredate = 06/02/04; insert into tbl_therapy(caseid, pro...more >>

Dear all, i wornder is some one help me. i want to access the the data from ms-sql-server2000 to xml file using asp so my code is as <%@ Language=VBScript %> <!--#include file="adovbs.inc" --> <% Dim adoCmd 'As ADODB.Command Dim adoConn ' As ADODB.Conne...more >>

Hi, I'm relatively new to .asp, so please forgive the newbie question. I have a few websites I'm responsible for now - and have been laboriously downloading the Access db's, compacting them, then uploading them back to the server on a regular basis. Something I recently read, led me to believ...more >>

Using MS-Access with "myDate" defined as a Date/Time field, how do I use SQL to select only those records (rows) that have have nothing in this field? The following does not work: SELECT myFields FROM myTable WHERE myDate = '' This gives me the opposite of what I want SELECT m...more >>

I have a Windows 2000 server; IIS 5.0; and the Oracle Data Base. The Database has 2 schemas and 2 virtual directories in IIS each one connect to corresponding schema If I try to use both at the same time only one works ok the second one does not return any data into the record set. If ...more >>

I have a table that contains a column with datatype text. I would like to search through every row in the table and find a string of characters in the text column and replace it. Unfortunately, the SQL Server I am working with does not have full-text indexing installed (nor can it be installed)....more >>

Basicly im new to asp. Ive been learning to use it through one of the dummies books. I have the following error: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'...more >>

Hi group, I'm moving to a new Windows Server 2003 and IIS 6 from Windows Server 2000 and IIS 5. I get the error below when I access a asp page with a select statement ONLY if the database(Access 2002) is open. My legacy server allows the database to be open and the pages still post. Ha...more >>

ok. I am trying to write an asp page that will add records to a DB. I am trying to get away from using FP for forms and DB's. This is access DB. Instead of adding the new record to the DB, it just comes back to the register page and doesn't add it. here is the code: <% Dim Conn If Request....more >>