Webmaster Forum / ASP / Database Access / March 2008

I am using Access DB, and want to calculate how many member in my db.
MemberID
Alan
Peter

Using VS 2005, I made a project and successfully connected to an SQL2005 db
using connection string with Initial Catlog=CallMaster (CallMaster is our db).
In trying to run the same app in VS2008, I kept getting error "Exception
Details: System.Data.SqlClient.SqlException: Cannot ...

I'm running Access 2003 on Windows Server 2003, and I'm also running a
asp web application on that server that access my Access server via
Jet.  Unfortunately the .ldb lock file is not being generated when
access my application online, therefore only one user can access it

I am supporting a classic ASP application that uses SQL Server 2000 on the
backend. I now need to contect to a SQL Server 2K5 database. I currently use
conntectionstring: Provider= sqloledb.1;Persist Security Info=False;User
ID='XXX';Password= 'XXXX';Initial Catalog= 'XXXXX';Data ...

I'm trying to create an asp page that will allow users to generate search
results by querying mssql databases.
I inherited these databases and did not build them.  Here's the scenario.
I have two databases:  DB1 and DB2.  School is a table of DB1 that consists

I have these tables with binary data stored in tinyblobs and blobs in MySql.
In my application I sometimes need to copy them to another table. Not all the
data, maybe just a column or two. So I first select the data into a record
set and then loop and insert it (its the only way ...

I am doing some scripting against a sql server database. In the course
of the scripting I update a text field of one of my tables and soon
after that run a select against that same table looking at the text
field.