How can you enable connection pooling from an application server that
connects to a SQL server on a different server?

We are using an application that connects to SQL Server 2000 SP4 using ODBC.
During this I noticed several executions for sp_datatype_info stored proc.
Why it is necessary and is there any way to stop or reduce this execution?

Just downloaded & installed SQL Server Management Studio Express on my desktop as part
of SQL Server 2005.
I can see how I can view my database tables, and columns in the tables. But is there a
GUI-type interface to view the data database, like Access has?

In VB 6.0, (sp6), using sql server 2000 (sp2), and ADO 2.8
the following code keeps crashing when I get an error.
    If mconTheConnection.State = 0 Then
       strEmailBody = strEmailBody & "The program was unable to establish a connection to the database " & mstrDataBase

I am a software developer trying to get an application run against SQL
Server 2005. The application once was written to connect to IBM DB2, Sybase
ASA or Oracle via ODBC. Now a new customer wants it to run with SQL Server
2005.

My old MSDE machine died (powersurge).
I bought a new dell with XP home on it.  I downloaded SQLEXPRESS.  I have
enabled TCP/IP and named pipes.
I have uninstalled the firewall software on the PC.  The router (2Wire) has

I just started today at this company.  They have a 2003 SQL server here in
Dallas and twice a day it updates with the main SQL server in NY.  And I
don't know that much about it.  When I look at the SQL Server network
connections..there is only one connection..the LAN connection. ...

   Hi guys - I am not sure if this is the news group I should be writing
to, but I have been having a weird connection problem with an application
that I wrote in SQLDMO when it tries to access the server.
   The server has several databases and my application tries to connect ...

I have a really simple question, I am sure, but I am drawing a huge blank.
All I want to do is go into my table called STATUS_AND_DATES and change the
field called JOB_STATUS.  I want to change all the records in that field
that say 'For Sale/Lease' to 'For Sale'.  How do i do an ...

i am using an OPENROWSET method to import from excel data to sql server. i am getting an error like
ADO error:[OLE/DB provider returned message: Operation wa canceled.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitializ
Initialize returned 0x80040e4e

  I am trying to create a linked server to DB2 using IBM
64 bit OLEDB provider, as Microsoft doesn't have a DB2
OLEDB driver for 64bit.  
When I test the connection to DB2 using the driver, it

trying to use a simple statement "select * from example where fromdate <=
{fn curdate()}" and getting error 242.
The column "fromdate" in table "example" has the "datetime" datatype.
so why the conversion is not possible?