Webmaster Forum / ASP / Database Access / November 2006

I am building a search page for our HR database. I am struglling to create a
query which will be able to search multiple related tables.
The main database holds the contacts i.e
ContactId,

I placed several SqlDataSource objects on my page which work with the same
database (same connection string).
As I know, connection operation to database is costly in the performance
prespective.

I have problem that DB connection Access file in ASP.NET code just does not
work. Error message likes this:
----------------------------
Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet

I need an example in asp
thanks a lot
Er Lupacchiotto Der Colosseo
Vecchio di It.Sport.Calcio.Roma

Appreciate any input to resolve this problem.
Thank you in advance.
Jack
1) Using a local web server on desktop WinXP-PRO

I have a MS SQL 2000 sp4 db.  IIS on a seperate server running win
2003.  I am trying to use integrated windows authentication but it
keeps failing.  IUSR_ is turned off.  I can connect to the db using
basic authentication but as soon as I turn on windows and off basic I

I am moving a fairly simple .ASP page from a W2000/IIS5 to a W2K3/IIS6 box.
It uses a simple select statement against a SQL2000 Table.  One of the fields
in the table is set a type of DateTime and the value of the field is
01/01/2006.  In the ASP, the code to retireve is as ...

I have a saved or persistent recordset
(http://www.MoneyFlowDS.com/holidays.rst) that I am trying to open with
either ASP or VBScript (using a .wsf file). When the .rst file was on
my Win2000 server, it worked fine, when I moved it to my Win2003 Server

I am using ASP to generate an HTML table
from a database.  I use FSO to output a file
with an XLS extension then open it.
I  can set the column width and row height;

I need an asp query that will group and count keywords in a field, such
as a description field, count them, go to the next row, do the same and
add them together by keyword and the return the list in descending
order.

Inside a classic ASP web application there is only one generic function to
connect to the database. This was verified by commenting the connection
string out and watching the application fail. Provided in the connection
string is the provider, DSN, username, and password. A Valid ...

I've been through a half dozen different suggested solutions for this
problem, but can't seem to find anything that works.
I've got a web server (Windows Server 2003, IIS 6.0, SQL Server 7.0)
and a database server (Windows Server 2003, SQL Server 2000). We're

Ok i have on database with one access page. Today i have stop to have
access to my access page... The security is set right ben when i try to
modified the access page in my db I have an error... it told me that
the connexion string is wrong... but the connexion string is ok. We I

I have a number of pages that various parts of the page are loaded from
an Access DB. The site is very new, only a few people using it per day.
The data is inserted using either Response.Write(rsuser("Variable")) or
<%=rsuser("Variable")%> as required, I'm stating that in case it is

I'm getting ready to build my first ASP.NET/SQL Server website that will be
hosted on some web host out there.  The work I've done in the past
(pre-.NET) was all done on in-house servers.  Since this will be hosted
elsewhere, I wanted to ask some questions to make sure that I'm ...