in my sql server database i have a table with the following fields; i am not sure of the fields coz i am not expert username : 'username is email password : ' not rondamly password the user create it i have connected this table to ASP.net... So can anyone give me the code of creating .a...more >>

Hi Guys I know this is a tall order, but I thought you would be the best bet. I developed a simple ecommerce web site for a client so that they could update their price lists in MS Excel, save them as tab-delimited files, they upload them to a folder via FTP and then ASP/ADO kicks in to grab...more >>

Hi, I'm having a problem. I've found that running a recordset with the query: SELECT * FROM user; works fine, but as soon as I add a WHERE clause, I get a Jet error. (too few parameters). I suspect the syntax may be faulty, but I don't know. This is what I've got: 1 .strSQL = "S...more >>

When using an access database, I could retrieve the recordcount with code below For r = 1 to RS.RecordCount When I try the same syntax on a SQL database, the RecordCount always returns -1 Is there another quick way to get the Record Count with SQL so I could run a similiar statemen...more >>

I'm writing a piece about the push toward web enabled applications and databases over the past couple of years and need your comments. My wife was complaining that her company is using a new web enabled version of their industry software and it is slower and less feature rich than the previous, ...more >>

Aloha, I'm learning .asp on the fly while trying to move this project over from access to MySQL. this is my DSN: sDSN = "DSN=****;UID=****;PWD=*****" I am connecting to a MySQL database using .asp. Below is my code: ________________________________________________ Set Conn = Se...more >>

Greetings, I am working with two recordsets and I wish to display the last record from one of those sets in a particular place on a page, and then loop through the other records of the same set at another part of my page. The recordset in question contains 3 records. I have 1 through 2 at o...more >>

Hello there, I have a problem with Adding a NULL Value in a Currency table in an Access database. The problem accurs when i'm trying to Update an empty field. The error message is: Error Type: Provider (0x80020005) Type mismatch. /travel/update_delete_datprijs.asp, line 43 Can some o...more >>

Hi, I'm trying to get a primary key from a table via openSchema method, but it seems that I can do that on Access DB. I only get a error: "ADODB.Connection (0x800A0CB3) Object or provider is not capable of performing requested operation." Code: ************************** set rs = Server....more >>

I'm trying to sort the output of a query.. and I know you can use the "order by" clause, but it doesn't work the way I want it to. I'm trying to sort a list of prices, but when I do it gives me something like this: 1.15 11.25 2.29 205.79 5.99 529.95 How can I make it so it actually ...more >>

I have a database that keeps track of inmates. When an inmate escapes, i have a way to lookup the name of the guard who was supposed to be guarding the escapee. The problem is that when the inmate escapes, his name gets deleted from the database, so I have no way to tie his name a guard. Is the...more >>

I have a bunch of variables, and their values - I wanna save these to a text file as through the adodb. I found the connection string, but I don't quite get how to add the records in this case. Do i Start with an empty Text file , then execute a Create table SQL statement, the way I would d...more >>

Hi All, i need your help, my problem like this, how to get data that will displayed in table rows from store procedure..as example in col 1 row 1 i will display for name, col2 row 1 is nip and etc..can i get solve for this ...? thanks ----------------------------- This message is posted by htt...more >>

win2k adv serv, iis5.0 trying to activate ado constants etc, once in the global.asa file to be efficient about that with <!--METADATA TYPE="TypeLib" NAME="Microsoft ActiveX Data Objects 2.1 Library" UUID="{00000201-0000-0010-8000-00AA006D2EA4}" VERSION="2.5"--> but i've run into the progid ...more >>

I'm really new to the concepts of Data Access Pages and asp, but I have been an Access developer for some time(just not a web/Access developer). I started by trying to convert a userform to a DAP and then tried going to ASP. Both results sucked. I read help at that point and learned that DAP doe...more >>

Hello to everyone I tried to add this ready to use guestbook to my website: http://www.aspkey.net/aspkey/_articles/asp/showarticle.asp?id=91 Yet, it doesn't work, and I can't really understand why I get this error: Microsoft VBScript runtime error '800a01ad' ActiveX component can't create ob...more >>

Hi, I have a Visual FoxPro database named C:\Test\VFP\DB.DBC. This database has a single table in it Address.DBF. The Address.DBF table is also located in C:\Test\VFP. I have an Access 2000 (Office 2000 + SP1) database named C:\Test\A2K\db1.mdb. This database has a linked table entry t...more >>

this is a little long but pretty basic, just trying to open the table 'volunteerPrimary' and read back all the fields in it the code i'm trying to execute at the server is: <script language="vbscript" runat="server"> <!-- open access data base with ado --> const adOpenDynamic =2 const adLoc...more >>

Hello group, How do I define a SQL query that searches for a string in a Memo field in Access. Now I have this statement but it doesn't show up with the results I would like to see SELECT Factuurregel FROM Factuurregels WHERE factuurregel LIKE '"&request.QueryString("woningnr")&"'" Anybo...more >>

A SQL Server 7.0 database table named Table1 has 3 fields - ID (which is unique & the primary key), Quantity & Amount. There is another database table named Table2 which has 2 fields - ID & Taxable (records under the Taxable column can have only 2 values - Yes or No). Table1 & Table2 can be JOIN...more >>

Hello, I have some rows in a table in a SQLServer database which contain some characters from the greek alphabet. The problem is they are not shown properly by the asp page that recovers that rows from the database and displays them at the web page. Most of that characters are substituted b...more >>

Hello All, I have a web application that has just started to cause applications in what seems like a random cyclic way. :) About every eigth page hit it will choose a ado command and report an error. If it was just execute, I could understand. But it picks things like CreateParameter a...more >>

Hi, I have a web page that displays records from tables in a database. It is designed to store field's value into Session variables before it displays into a text box. This record can be edited and/or deleted. The problem arises when one of the fields contains spaces between the letters. Wh...more >>

Running an ASP.net page, when put a large query through the server, the I get an error connection times out. How can I can I avoid this problem? For connection pooling within Database server i have the value set to 0 ( for unlimited timeout). The actual query I use is used to fill a da...more >>

I want to concatenate the two database collumns.. Any one have any suggestion about how to do this using jet sql.. thanx !!! ...more >>

I'm using a ACCESS database that has a databasepassword. In the connection string I'll provide the password as follows: MM_test_STRING = "dsn=test;pwd=test;" This works fine on IIS 5 but on IIS 6 on Windows Server 2003 I'll get the followwing error: Microsoft OLE DB Provider for ODBC Drivers ...more >>

I'm using W2K server, Access 2K and ASP. Creating website to provide database information to anonymous users. I know Access can support very few online users at a time, so I'm thinking about automating database interaction. The idea is to have ASP call on Access at midnight. Once the connection ...more >>

Sorry for the cross post but hopefully this is the right place to find an answer. I am currently upgrading a Access 97 db to Access XP. No problems there. I am also moving the db from a NT Server to a 2000 Server. Big Problems!! It seems like half of my asp pages will not work for some rea...more >>

Can I kill (set obj = nothing) ALL objects in my asp page? For example I have 5-6 object and I want to kill all together...without knowing their name. something like this... for each myObj in obj.count - 1 set myObj = nothing next any help appreciated. regards -- == fab...more >>

Ok I have this big problem again. I have my IIS Server in one maching and my SQL DB in another. It needs to stay this way. I am connection with windows authentication to IIS <authentication mode="Windows" /> <identity impersonate="true" /> and my connection string looks like this...more >>

ASP Programmers: If You are a reasonably good ASP Programmer, want to earn big money and live near Clearwater, FL, Contact me to discuss a very profitable business idea. -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in...more >>

Hi, At present I have an include file that defines my database connection string. This file is inluded on every page that uses database access. However I would like to ask if a better place for this string would be in an pplication variable. I know it is not a good idea to cache the actual...more >>

We have over 100 asp pages that reference a table (distribution_components). We added a new column and primary key to that table, so now we have to modify the where clause to include that column (we have to make the new column = to a session variable in the page) The table appears 531 ...more >>

Why when I open a recordset with a adOpenForwardOnly cursor it''s allows me to update and add records? I tried to open my query with all types of cursors and all of them allows me to update records. adOpenForwardOnly=0 adOpenKeyset=1 adOpenDynamic=2 adOpenStatic=3 Based on all i hav...more >>

I got soem code from 4GuysfromRolla and am having serios problems getting it to work. I need to be able to use the Reports from an MS Access database by means of ASP. The Code can be seen at http://4guysfromrolla.com/webtech/042600-1.shtml I would really apresiat it if someone can help me out. I ...more >>

Is their a way using JET sql i can merge two columns in an Access DB via my asp script. Any insight or links to some good info would be appreciated!!!! ...more >>

I have need to show a list of areas indented hierarchically on an ASP web page like the following example. The World Europe United Kingdom England Wales Scotland Northern Ireland France Germany The Americas ...more >>

Does someone know the proper connection string for using OLE DB connection to an oracle server ? Jon Spartan...more >>

Hi, does anybody know of any tools (preferably free) that i could use to test my asp code accessing an sql server database under load. what i mean is, if I have a page that accesses a database, i would like to stimulate 100,200,300 ect connections to that page at the same time. The point ...more >>

Does anone know if it is possible to write the code allowing the user to browse directories and files on the server with some kind of window ? I know this could be insecure but can it be done and how? Thanks in Advance ...more >>

hi group, am i stupid or what. I try to rename a column name via asp and getting errors all the time. what would be the right syntax: alter table [name] rename column [old] [new] wvarchar(255) produces error Microsoft OLE DB Provider for SQL Server error '80040e14' Please help, Michae...more >>

I found some asp that uses a session variable for password control. I pass this session variable into my SQL statements so users can just see records that apply to them. BTW, These passwords are not for high security data. Is there a way I can make this script more dynamic in terms of admini...more >>

I am querying a large SQL database table and when the result set is large (over 1000 records), the browser just clocks and I have to wait for the session to time out and then the recordset will be displayed. I''ve tried setting response.flush to get the for next loop to display the data as it''s re...more >>

How can I replace first as well as last "," in a string? Mystring = ",3,2,5,6,1,65,22," I would like CorrectedString = "3,2,5,6,1,65,22" I would like to replace commas on each sides with "". I am new to asp and would be grateful for your help. Thanks in advance....more >>