Hi, I receive from a hidden field a date (in weekday format) ('dat'). I have a table "day" which has field "monday", tuesday" etc .. <% dat=request.form("myhiddenfield") 'dat contains any weekday (monday or tuesday ..). .... sql="select 'dat' from day" .... In the select statement, i n...more >>

Hi Is anybody using connection pooling? The standard method what I saw is following - on every page: open new connection, make select, close connection. So, if one user visit one by one 10 pages - 10 connections will be created and destroyed. Some bad way, isn't it? A ...more >>

This will probably be considered a newbie question, and guess what: I am indeed a newbie. So please bear with me: I have created a database editor in ASP connecting to an Access DB, and everything works perfect, EXCEPT when a field is left empty while adding or modifying a record. As a resu...more >>

Hi there ! I am trying to rename a column i Access Set Conn1 = Server.CreateObject("ADODB.Connection") Conn1.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\fpdb\currency.mdb") sSQL = "ALTER TABLE DatoCurrency " sSQL = sSQL & " COLUMN " & ucase(retcur) & " RENAME TO "...more >>

I have a table displayed using ASP from an Access dB.......one column has #'s in it and these #'s denote a particular status of the entire record......is there a way to hover over the status codes and have a window display for a few seconds? This window would have a description of the status. I ...more >>

strSQL = "SELECT * FROM list" strSQL = strSQL & " Where date1 > '10/30/2004' and date1 < '11/2/2004'" It returns the result: date1 ----------- 1/1/2004 10/7/2004 10/5/2004 10/4/2004 Why does it not match the range? ...more >>

Hi, I had posted the question yesterday, however I did not get a real answer. PROBLEM: I need to work on a project with a state map with associated counties. On clicking a county, it should give the summary stats of crime for that county on a box on the page. On double clicking a county a n...more >>

Hi, I desperately need a free web-based ftp script/application. Any tips will be highly appriciated /Mali ...more >>

Utilized FrontPage 2003 Database Wizard to create an online feedback form. The Submission form indicates that everything transferred smoothly to the database. BUT. When I ask to see the results online or edit the database content I receive the following error. Database Results Wizard Error T...more >>

Hi, The following statement works in query analyzer but does not work in asp. Specifically, what does not work is that the rfc822 field from mailbox is returned properly in query analyzer but it is returned null in the asp code. This rfc822 field contains the body of an email message which is ...more >>

My page is retrieving recordsets REALLY slowly and it's doing my nut in now! I've attached all the code to this post in the hope that someone might find a problem with it. Because I'm close to giving up! The queries run really quick in Access, and my only idea now is that it's got something to ...more >>

Hi, I have a problem retriving scalar nvarchar value from stProc in MS SQL Server ... Please tell me what am I doing wrong ... thanx, Neven ************************* CREATE PROCEDURE someUser.GetFirstCourse @strEducationName nvarchar(50) AS DECLARE @strCourseName nvarchar(50) S...more >>

Sorry for the cross post, but after three days and no answer, I figured I'd try another board. I have ISA server logging to SQL2K which is installed on the ISA server. Our primary internal website server has a system DSN linked to the ISA SQL Server called ISALogs, which is set to the ISALogs...more >>

Hi, I have a stored procedure which is used in a ASP page. The execution of the procedure from query analyser takes approximately 5 minutes. But, when it is executed thr an ASP page, it takes very long to respond and i get a "Page cannot be displayed" error. I am not able to figure out w...more >>

HI, I'm sorry ,it's me again .Actually i have this questions in my head saying that isn't the provider should already enables the read/write permissions. ...or why is it alwaz that is up to us that have to go and tell them... .. And how do i go about on installing the control panel to my ...more >>

After searching for ways to resolve my problem like "Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only. " I have found one article in http://www.aspfaq.com/show.asp?id=2154 saying that i should ...more >>

Hi, me again! I'm using the following to connect to an MS Access database, and putting Response.Write(Now()) around it. Sometimes it will connect quickly, but other times it takes up to 20 seconds to connect. Any ideas? conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\cl...more >>

I've tried using this connection string which works fine: conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\inetpub\clients\awt326\db\db127\store.mdb" set con = Server.CreateObject("ADODB.Connection") con.open(conString) However, I keep getting an unspecified error on the lin...more >>

Followed FrontPage wizard to create online submission form. Pages were generated automatically. Page coding appears to be correct. DB was also generated by FrontPage. The server is utilizing ODBC for the Access DB Although I can view the pages remotely and I receive a confirmation that info...more >>

I use this string today: Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath ("db/data.mdb") is it possible to use something like Connect_String="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" http:www.another-server.com/db/data.mdb") Maarten. ...more >>

Hi, what is the fastest way to get record sets?? Using ASP to access an MS Access database it takes AGES to open the following two recordsets using this code - a couple of seconds each sometimes!!! The subcats table has 96 entries and the products table around 1,500. Is there a faster way I can ...more >>

Why is this error occurs whenever i try to submit a form which i have created for a website.Where as,i didn't encounter any problem with the process in the local machine (intranet).Im using Asp to connect with Access Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Micro...more >>

Dear All I have 2 SQL tables called STOCK and STOCKDESCS. The common field is STOCKID. In the STOCK table I have all of the rows that I have posted, but my STOCKDESCS table is short of the same rows. Do you know of a quick query I could use that basically lists the following (table ...more >>

Hi all, I got Win2000 and I just developed an intranet solution installed on my web server (IIS). The application worked nicely and there were not any problems. Few days ago I re - installed my OS and I installed the IIS and my intranet solution but there is an error and the application doens't...more >>

Followed FrontPage wizard to create online submission form. Pages were generated automatically. Page coding appears to be correct. DB was also generated by FrontPage. The server is utilizing ODBC for the Access DB Although I can view the pages remotely and I receive a confirmation that i...more >>

I'm trying to connect to a sql server database. I use the same connection string that I have millions of times. The only difference is I'm connection to a different server with sql. Do I need to ensure that the IUSR account has rights on that machine? The webserver and database are on ...more >>

Using Access, is there an easier, or less intensive way of inserting many records into the database at the same time? eg - insead of doing this: objConn.Execute("Insert INTO .....") objConn.Execute("Insert INTO .....") objConn.Execute("Insert INTO .....") objConn.Execute("Insert INTO ........more >>

Is there any way to change a table name with asp code I have a table named unknown in my access database. Looks like "unknown" is a reserved word and there are errors if a create a recordset asking data from this table. I want A SQL statement to change the table name online. (why is unknown...more >>