I am using MFC 6.0 CRecordset to access data inside an SQL Server table
TEMPORARY_DATA. The table contains also a BLOB field.
The query I am using is:
SELECT * FROM TEMPORARY_DATA WHERE

I am new to SQL server 2005.
I have a connection problem when I connect from home client to office
server through VPN.
Firstly, I can connect from office client to office server, both

I'm moving my intranet app from one development server to another. The old
one was Windows 2000 Server with SQL Server 2000. The new one is XP Pro with
SQL 2005 Express.
here is the connection string I have been using on the old machine for

I'm wondering how to detect SQL servers on the network, the way Enterprise
Manager locates servers when it populates combo boxes or list boxes with
active servers on the network.  Can anybody give me a hint?  Some C# code
would be a plus.  Thanks!

DevStudio 2003, SQL Server 2005, Windows 2000 Pro SP4
I have been using the Enterprise Library Data Access Application Block to
connect to a local SQL 2000 database.  The connection string parameters are:
<connectionStrings>

I have an instance of SQL Server 2005 on two different development machines.
At first we could not connect to Machine A until we read about how it comes
locked down.  We went to SQL Server Config Mgr and enabled all necessary
protocols and can connect just fine to it.  When we ...

Hello Again All,
Thanks again to Rick Byham for your seggestions.
Ok I started SQL Management Studio and loged in using Windows Authentication
then I ran the query

I have SQL Server 2000, not sure which SP. A db that I created 3+ years ago
has been running smoothly, but today, I cannot connect. Specifically, in
Enterprise mgr, when I click on the name in the tree on the left, or if I
right-click and select Connect, I get a message box which ...

I like to say thankyou to  Rick Byham for his reply to my previous post
entitled SQL 2005 login  issue 2....
Rick I did try what you  suggested first I changed my  connection string to
"server=p3xp;uid=;pwd=;database=master

How to establish connection string for sql server on non-domain network?

I installed SQL Server 2005. Connected to an external dB on a different
server just fine. Now am trying to connect (via SQL Server Management Studio)
to the default local dB. I get the following error:
Cannot connect to <server name in here>

I am using Microsoft SQL Server 2000 Driver for JDBC to connect to SQL Sever 2000. It is just a test application to see if it would connect to the datacase successfully. But I got the following errors. I already set up the classpath and installed all SQL Server 2000 Driver for ...

When creating a system DSN via the ODBC Admistrator dialog....
What is the differecne between "SQL Native Client" and "SQL Server" drivers
listed in the "Create New Data Source" drivers list?
How do they differ?

If by any change you have read my original post titled "SQL Server 2005
login issue and also the post from "Jens".....   This message is in regaurds
to those two posts.
First of all Jens thank you for your reply.

  I am a developer not a database administrator.  I need to figure out a
way that only one user should be using the database from our .net
application.  If i start the database instance in single user mode, does that
solve my problem.  It might be possible to verify whether ...