Hi to all,
I have a big performance problem with looping threw rdoresultset.
I made some very complex sql queries. They link like 5 tables and uses a
couple subqueries. The number of returned rows is something like 1000. Query

Two of our servers have a "MYSql OleDB Provider" Datasource. I have no idea
where they came from but I would like to add this Datasource to my own PC. Is
this something someone likely purchased? Does Microsoft provide it?
Thanks

Is it a security risk to have the IUSR account set up as a dbo, or is it
better to give the IUSR account selected authority?  I use the IUSR account
to access SQL Server for ASP web pages.  The connection string uses
IUSR_<machine> with no password, but the password is stored ...

Time to time I get the following exception when creating a new JDBC
connection:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]The
requested instance is either invalid or not running

I'd like to use the messages returned by Sql server 2000.
e.g.
BACKUP DATABASE ... WITH STATS = 10
returns a message to the analyser after every 10 percent completion.

I have installed SQL Server 2005 Beta 2 and attached a database which
was running on SQL Server 2000.  On the local machine using server
management studio I can see all databases including the one I attached.
In SMS I have under Databases System Databases (containing Master tempdb ...

When I do the following:
rs.updateRow
rs.refreshRow
the resultset is not updated as stated in the help files. After

Warning beginner here.
I posted this in the setup news group but haven't received and replies, so
perphaps someone here can help me.
I am developing a small ASP.NET web application that will use an SQL Server

I am trying to link up a SQL Server 2000 SP4 (or SP3a) with a ADAM (Active
Directory Application Mode) on Windows 2003 SP1. Both SQL Server and ADAM
are running on the local machine. The user I am logged on is a local
Administrator account.

Dear gurus,
I’ve created a link between an A server (sql2000k) and an B server
(sql2000k). They belong to different NT domains as well as different
countries.

We are using SQL Server 2000 with ASP.Net. My manager noticed in Enterprise
Manager (under Management | Current Activity | Process Info) that after a
page had rendered, some database connections still show. We figured the code
must not be closing the connections properly. We did ...

I am running Navision 3.10A with SQL Server.
When I go into Navision and try Syncronise to SQL I receive the following:
(Error Message 1)
Click Ok if you want to revoke Windows login DOMAIN\User1 from Server

I have an ASP website that uses SQL Server 2000 as its back end.  It is
running successfully on SBS 2003--all on one machine.  I am moving over to a
new domain which has the web site on one server and SQL Server 2000 on
another.  I have progressed to the point where the web site ...

We are running SQL Server 2000 on Windows Server 2003 (SP1 not installed).  
We are trying to access our databases using Enterprise manager from our
machines in the office using windows authentication.  We have no problems
from windows XP machines (using both TCP/IP and Named ...

my access application links to sqlserver odbc
the form RecordSource is an path-through query limited to max 30 records
1. how can i show the next 30 records?
2. how can i find a spesific record placed out of the shown records?