Forum: ASP Database

Hi, Is there a way to connect to an sql server db if it doesn't have an sql server logon, i.e. if the server uses only windows authentication? ...

hi!! This is my problem. Im planing this without success *i have 3 tables table1 table2 and table3... *The tables have some fields with the same...

Hi! I am writing a application using ASP and MSAccess. I create a sql query in order to add or drop a field from my db. However, when I try to...

I'm trying to connect with an Access database with this snip from a sample application originally designed for SQL Server. There is an include file...

Hi gurus, I have 3 tables and their fields as follows: 1) Buyers: BuyerID 2) Sellers: SellerID 3) BuyersSellers: BuyerID, SellerID,...

> rs.Source="SELECT id From User Where upper I asked this before... Try sql = "SELECT id FROM user WHERE UPPER(cLoginID) = '" & vUserID &...

Please help, I want to replace a string within field in a table with a nother string. I am using the replace function but I am doing something...

I am having some difficulties with the function Datediff! I am trying to calculate the number of days between two given date E.G: Number days...

Hi all, I have a table containing an ID (unique, autoincrement) and some other fields including IP. When I try to insert the 'ip' I get a...

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...

Can someone please help me with query. We are using this query in one of our asp pages. As I didn't write this query in the firstplace I am...

I've built a table where each record relates to a meeting. Meetings may be independent or may be linked indicating that they occur sequentially. I...

Mytable has 20 fields.I need select three columns from mytable. My query: ' select columnname1,columnname2,columnname3 from mytable '...

Woops better watch where I send thing. Marni is Doreen's sister and Sam is Marni's pet name for Doreen. Blushing Grant

Hi All: I would like to have certain areas of a site that I am developing password protected but I am not sure how to go about doing this. I know...

I'm trying to to update multiple records with a drop down. My update statment updates all selected records with all selected choices. I get for...

Hi, I'm building an audit trail for a web app using MS-Access. The way I'm doing it now is by adding fields like 'LastUpdated', 'UpdatedBy',...

Hi there, I have recently changed the connection string on a site that was working perfectly. I used an OLE DB connection with this code: var...

Does anyone can tell me what is wrong with my SQL server? My database field size is 3000 with nvarchar. I got an error Microsoft]{ODBC SQL...

Hi, Using this ASP code I get the error Could not find installable ISAM. I always connect to Access databases using ADO and Delphi. I never got...