I have a linked server to Oracle (I have one using MS and one Using Oracle
Driver), both take about 20+mins to return 114k rows using OPENQUERY, is
there any way to speed this up, and why does oracle always ruin my day ?
- David

I have a asp.net application that connects to a SQL Server DB.  I have been
connecting to SQL Server on local machine and now Im trying to test
connecting to another test server.
I have setup my connection string in my web.config file as follows

Dear Group,
I'm using Access 2003 linked to an SQL Server data table via an ODBC
connection.
On one form I have several check boxes which want data mapped to a

     In my VC++ 6.0 application, I have a database with 3 different
tables say Client,Task, and Algorithm. I want to access this three
tables through CRecordset. As far as i know i need to derive three
different classes for each table, from CRecordset. Can anyone please

I have an issue with a number of the Windows XP workstations on my network
not wanting to talk to my SQL server.  I have traced the problem down to the
appropriate protocols not being enabled on those machines (which I can fix
using CLICONFG).  What I am now trying to find out is ...

I have installed two SQL Server 2005. One on Windows XP SP2 and another on
Windows Server 2003 SP1. I have shut down the firewall on both machine, but
I still failed to coonect each other. Both of them can connect to SQL Server
2000.

I've got a very weird ODBC problem and the log file mentions this: DIAG
[IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed (0)
The situation is the following:

We get this meesage if we try to connect to the database from a client
computer. It works fine if we connect locally on the 2003 server.
The MSDE was installed from another maker and we have changed it to use
mixed mode. We log on using SQL server auth.

I am trying to connect to a sql server database that is in another domain
from a vb script (not within ASP, just .vbs file).  I am getting error:
Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server
Driver][SQL Server]Login failed for user '(null)'. Reason: Not ...

We have an instance of oracle on linux and another with sqlserver on
windows.
We need an odbc driver for the linux box to connect to the sql server.
Does anybody have suggestions on what odbc drivers there are out there for

   I am using MFC class with ODBC to connect to SQL Server.  Below is my
partial code, when I do update(), I get an error "Invalid attribute/option
identifier".
--------------------------------------------------------

We have an OpenQuery to an Oracle linked server that was working fine in SQL
2000 SP3.  After upgrading to SQL 2000 SP4 (MDAC 2.8), the query is failing
with "Protocol error in TDS stream".  It seems to be related to sending a
very large query - when I reduce the size of the ...

we are developing a java application, which connects to a MS SQL Server 2000
via the Microsoft JDBC Drive Service Pack 3.
Due to the fact that we have massiv performance problems with MS SQL. I
started profiling our MS SQL Server.

One connection is using a few store proc to do some transactions. It takes a
long time to complete. I want to know if it's possible to show the particular
SQL statement when the connection is running, e.g. the statement "select *
from staff" is bottleneck as it consumes the most ...

If this is not the correct group for my question please point me in the
right direction.
I am using server side VBScript to connect to an MSSQL database, on the
Internet, extract values and serve them up in text, drop downs, etc...