Does anyone know of an ODBC or OLEDB driver that supports the use of
Application Roles?
I am looking for one so that the Application Role information could be
specified as part of the connection String and the calling app will not have

Hi, I encounter a problem with a Java application, during performance
tests with many threads.
With Weblogic 8.1 and a driver JDBC type 4, the DB is SQL Server 2000
An exception occured on a RestultSet.next().

I have a VB.NET application which connects to SQL Server using ADO.
The problem I have is that I need the application to detect if SQL Server
has not yet been installed on the local machine and if so give the user the
option to run the MSDE installation.

I was going thru Enterprise Manager and can't see connection count, I can
see User connected, but that doesn't give me an actual connection count.
Is there a way to determine my connection pool count from Enterprise Manager
and/or some other tool?

Hi all...
Environment
OS : Windows 2000 Advanced Server(SP4)
SQL Server : Microsoft SQL Server 2000(SP3)

I have a SQL server running on a Win2k Domain Controller set for Windows Authentication only.
I have a Windows 2003 Web Edition server that is a member of the domain.
When permissions are correct I can open and update databases on the server from the Web Edition server.
I want to ...

Hi, Could you help me modify the SELECT statement below that would
accomplish my final goal.
SELECT col1, col2 FROM table1 WHERE col3 < @V
In col1 rows have many duplicates

Is there any way to get a SQL query using Microsoft's implementation of JDBC
interfaces/classes?
I know using Oracle, I can type cast a Statement into an OracleStatement and
it has a new method which returns the SQL query  associated with that

I'm connecting to an Access DB through ODBC on a windows server from a PHP
page. The problem is the text retrieved from the select (nfo) is truncated
at
4,099 bytes everytime.

We have an application that uses the BDE from borland to connect to a SQL 7
server using TCP/IP. Becuase of changes in the SQL 2000 client driver that
are incompatible with the BDE, we have not beeen able to upgrade to SQL
2000. We are considering upgrading the server and leaving ...

I've been searching the archives for the answer but I have found none,
so I've decided to post. I've written a vb.net app that:
1. creates a SQLConnection object.
2. opens a connection via this object.

Hi, Could you help me modify the SELECT statement below that would
accomplish my final goal.
SELECT col1, col2 FROM table1 WHERE col3 < @V
In col1 rows have many duplicates

   My problem is I have an app that uses MSDE 2000. After the install, it
asks for the name of the local database instance where you would like to
install the app. It only gives me one option, 'localhost'. I can use an
OLEDB provider to specify the actual server name but I ...

My clients are reporting they cannot connect to the msde database using my
application - generic failed to connect message.
My software application installs the MSDE.  Their computer is a brand new
machine with XP-sp2 installed.  The sp2 is not an upgrade.  We have only

I have the following scenario:
MyTable
id number entity(1, 1)
name nvarchar