once in a while, we get an access db that has a .ldb file that can not be deleted. This either creates or is the result of iis not being able to serve anymore asp pages. Only solution is to restart either server or iis. any idea what would cause this? win2k3, iis 6, pached, access 2000....more >>

Hi there, I need some ASP/SQL code that will show the complete structure of a database. That is, all the exisiting table names, and all fields (and filed types) in those tables. Why? Because I am in a situation where I need to make major mods to an existing site that uses a SQL database w...more >>

Assuming the code below, whats the most efficient way to get the actual record count as the full array count doesnt exist :-) I want to keep the paging without the full recordset being opened. Words of wisdom? tia Set objConn = Server.CreateObject("ADODB.Connection") objConn.Open DSN ...more >>

I have tried this on multiple computers - - I get Unspecified error /search1.asp, line 13 here's the very simple code: Set MyConn=Server.CreateObject("ADODB.Connection") MyConn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _ "DATA SOURCE=" & server.mappath("\Webdb.mdb") sql="Select * from Na...more >>

I don't know if someone has faced this.. I have a web site where people register and login. 90% of visitors register with Arabic usernames. When users became so many, MySQL started to do something weird. When users login, I simply perform "select ID from musers where username = '" & username &...more >>

Hey all, One of the guys I work with is fanagling for us to get another box for the Web site we work on. The plan is to relocate all the databases (currently Access, but will eventually be converted to SQL Server) to this new machine. At present all the databases and ASP/HTML files resid...more >>

I'm using the examples set out at aspfaq.com to create an OLEDB = connection (instead of using a DSN you'll be glad to hear!!). The = problem is I keep getting the following error :- a.. Error Type: Microsoft VBScript runtime (0x800A01AD) ActiveX component can't create object: 'ADODB.C...more >>

How do I tell which version of Jet particular Access 2000 database is using? I'm trying to use the proper OLE-DB settings to access it via ASP and according to www.able-consulting.com :- "Note, remember to convert both the MDB and the MDW to the 4.0 database format when using the 4.0 O...more >>

I have error handling in my application and I get this error message immediately after the conn.open call to an Oracle db... The only reason I know of the error is because I have error handling code. But my application doesn't crash. The connect does proceed and the queries are executed etc ...more >>

Hi. I'm trying to enter information from a HTM form and send it to an ASP page. Here's the code that I'm using as a reference. <---begin code---> mySQL= "INSERT INTO Employees " mySQL= mySQL & "(FirstName,LastName,Address,City,Region,PostalCode) " mySQL= mySQL & "VALUES ('...more >>

I have an application where I need to keep the connection open because my application monitors 2 separate databases ever 1 second. Is there a consequence of keeping it open and using recordsets from that connection? Reason why, if I open it and close it after each use, I run into lots ...more >>

I need help getting the right SQL statement . I would like to grab the first record of the day (records have a date entry and a time entry associated with them. I know it is going to be a select statement, but the right syntax eludes me (these late nights and early mornings makes the brai...more >>

Does anyone know why the " - quote presents a problem when updating to a Access DB. I know the single quote ' does. Shimon...more >>

Hi, I got a ASP problem wanna ask.... Sql_check = "select * from user_table where user_id =' " & user & " ' " Set Rs_check = Conn.Execute(Sql_check) In the user_table , there is an attribute called password, I wanna display the password of the specified user name, what should I do?? Is that ...more >>

I'm returning a SQL recordset that uses "With Rollup" to render totals as the last record. Normally I simply loop through recordset and response.write each record adding HTML tags. However, I'd like to make the last record bold to show it's a total. How can I determine that a particular record...more >>

Hi There, can someone tell me if this error relates to the MDAC version installed on a particular machine? '--- Error message Unspecified error provider -2147467259 'connection string cst = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("cart.mdb") ...more >>

Hi. I'm using the example from FP2000: How to Send Form Results to a Database and E-mail Address at the Same Time at http://support.microsoft.com/default.aspx?scid=kb;en-us;275251&Product=fpw and all data is getting into the database fine. But the E-mail never gets sent and gives this error ...more >>

Is there an advantage of one of these over the other, other than not having to know the physical path? strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/_db/my.mdb") & ";" strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Date Source="d:\inetpub\wwwroot\_db\my...more >>

Hello, I am in desperate need of some help here. I need to pass my username (uName) value from this authorization code to my client page. When the clients username and password are authorized as valid they are being sent to the client page with this line of code: Response.write("<SCRIPT Langu...more >>

I want to know if the PostBack concept applies to HTML web-based forms, regardless of what programming technologies we use: For example, ASP, ASP.NET, Java, CGI, etc... PostBack means to send the HTML form to the web server? Since most of the time I heard this term in ASP.NET circle, thats why...more >>

Im trying to call a stored procedure in SQL Server 2000 in ASP.. Heres my code.. ############################################################################# <%@Language=VBScript %> <!-- #INCLUDE FILE = "include\adovbs.inc" --> <% dim empid, password, Conn, Cmd, checker, firstname,...more >>

Hi everybody, I am trying to create a workgroup information file for Access but having problems determining how do I set up a username and password for it. The reason that I am doing this is so that I can avoid receiving this error when running an asp application that accesses a MS Access Datab...more >>

Hello: I have a web service that uses a ACCESS 2000 db and it works fine if no other app has the DB open. However, if another app on the server is using the DB, I get an exception: Could not use ''; file already in use.. (verbatim) I am using the same connect string in both the Web Se...more >>

Hello, I am using NT4 I move a web site code form one server to another server. but appear below error. the web page use access please help and thank you for your time alex Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Microsoft Access Driver] Opera...more >>

We have a SQL Database that uses DTS to import customer data from an ODBC database into a few tables. We also have created a related table in SQL from scratch. The ODBC data updates every half hour. We want the customers to be able to update data from the Internet for just the SQL table we cre...more >>

We are hosting a clients site on our web server. A part of their page allows customers to login to access a FoxPro database. My problem is at the login. We partnered with a web developer to help us design an access to a Visual FoxPro database. Since we were already there we set up the usern...more >>

Hello I have windows 2000 professional, MS Access 2002 installed on my system. When I execute a simple query from an asp page it works well but when I execute a query with inner join, it displays: Error Type: (0x80004005) Unspecified error Can some one help to resolve this problem. ...more >>

I have a web site, bentelhalal.com, for matchmaking services (ASP + MySQL). I have currently like 83,000 members. "musers" table consists of 65 fields containing all info. Fields are mostly varchar and indices are made for like 8 fields. I have an average of 30 concurrent users at any time. Th...more >>

Hi everbody: I am getting an error (message to follow) when using the following code within ASP: cst= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _ Server.MapPath(".") & "\shopping500.mdb;" & _ "User Id=admin;" & _ "Password=" The error message is: The...more >>

Hi again, I finally got to using saved parameter queries in my application (a big thank you to Bob Barrows for helping me with this). Currently I need to pass dates as a parameter to my saved query in Access. My question is : what date format should be used for the parameter ? Just so...more >>

I am getting an error message while trying to connect to an Access database within ASP. This error only occurs on my notebook computer and not on my desktop computer. I am running from within the same environment. That is, the same versions of Access and IIS. If anyone could help me I would rea...more >>

We have an server (w2k) which amongst other things hosts out intranet. The intranet site is partially DB-driven, but the DB was hosted on a different server (w2k/w2k3). We had to do some maintenance on the SQL Server machine, so we temporarily copied the DB to a 3rd server (w2k), which is at ...more >>

I have a guestbook form that inserts the fields into an Access Database. The database is residing in the "fpdb" folder that was created by FrontPage. The ASP page that writes the data into the databse uses the "recordset.addnew" method. The code was working fine a couple of weeks ago, and now ...more >>

Hi Folks. Trying to use ASP to submit data to both an access database and to an e-mail address at the same time. After downloading the example cdonts from microsoft I pasted the following into my email.asp. Set myCDONTSMail = CreateObject("CDONTS.NewMail") When data is submitted it goes in...more >>

Hi Folks. Trying to use ASP to submit data to both an access database and to an e-mail address at the same time. After downloading the example cdonts from microsoft I pasted the following into my email.asp. Set myCDONTSMail = CreateObject("CDONTS.NewMail") When data is submitted it goes in...more >>

Is there any difference, performance-wise, between these two methods? Method 1: szSQL = "SELECT fld1, fld2, fld3 FROM tbl1" Set objRS = objConn.Execute(szSQL) .... szFld1 = objRS("fld1") szFld2 = objRS("fld2") szFld3 = objRS("fld3") Method 2: Const cFld1 = 0 Const cFld2 = 1 ...more >>

Hi All This is a belter that my little brain can't handle. Basically I have 1 SQL table that contains the following fields: Stock Code Stock Desc Reference Transaction Date Qty Cost Price Basically this table stores all the transaction lines of when a user books stock items into st...more >>

I have created an FSO object on my server to allow me to access data on a harddrive from a remote location. This works fine, except that the data is pulled from another server on the network and not the webserver. So when I use the command objFSO.GetAbsolutePathName("\\ehc-sr-001\rmweb") it...more >>