I have two servers, one running a legacy ERP database on SQL2005 Standard
Edition, and the other server is running an SAP database on SQL2005
Enterprise Edition 64 bit.
Both servers are set to use Windows authentication, not Mixed (SQL and

SQL2K/SQL2K5
Have run into a situation where a record lock has caused a problem for users
. .  .not exactly unheard of.  The lock encountered was on a single record.
The lock persisted for about 14 hours. The SPID causing the lock was not

ISSUE:  Cannot connect to newly installed SQL 2008 server via ODBC from
clients (web servers) in the DMZ.
SQL Server Specs:
SQL Server 2008 Standard

Help,
I am writing a data import application that will import data in to
sql
server database.

I've inherited some code that uses this connection string:
"Driver={SQL Server};Server=sqlsrvr\sql2005;Database=test;UID=user;Pwd=xxxxxx"
However, the SS2005 instance is running on 2789.
How is this working?

What is the best way to get data into my SQL server tables from SAS tables?  
I know that I can export from SAS to .csv and then import .csv to SQL Server
but I would like to directly import from SAS, perhaps thru an ODBC connection.
Suggestions?

-------------------------------------------------------------------

I've developed an app for our company using VB.NET (winforms) and SQL server
express running on our SBS server 2003 Standard
The app works really well within our LAN but I often work remotely and quite
often would benefit from using my custom app.  I've tried the VPN but for

Hello to All,
Our Server Admins applied the Update KB948496 and we've lost connectivity
from a number of clients to our SQL Server 2000 instance.
To connect with 2K5 SSMS we have to provide a port or establish alias.  We

I have a .dll which creates all of my ADO connections.  When used in a
compiled (.exe) application it connects to SQL 2005 just fine via TCP.  But
when I am using it in a application I am developing (ie in Debug Mode VS2005)
it won't connect unless I enable Named Pipes on SQL??

I am using Linked tables in MS Access to retrieve data from SQL Server 2000.
Most of the times I am getting following error message while retrieving the
records.
[microsoft][odbc sql server driver]timeout expired (#0)

Setup...
Physical Windows Server 2008 running DNS and Hyper-V (RTM)
VM1: Running IIS 7
VM2: Running SQL Server 2008 Enterprise

I just installed the full Sql Express 2008 package....
Created new databases etc....
I can't seem to create any ODBC connections.
I am selecting Sql Native Client 10 --- assuming that is the correct driver

I am adding support for Unicode data to our application.   The customer has
the option of using our built-in Apache DBCP connection pool, in which case
we control the URL for the database connection.   They can also configure
their app server with a DataSource connection pool and ...

I am trying to develop a T-SQL script to copy data from our internal to the
SQL server database at our webhost.  This is probably pretty straightforward
and a fairly routine task in the database world, yet I fail to see it in the
documentation.  My hunting on the web has led me ...