Hi, All:
Please help. I use sql server as back end and Access 2003 as front end
(everything is DAO).
A table on SQL server has an identity column as the key.

I've installed Visual Studio 2005 (including SQL Express) on a XP Home
machine. I've currently problems to connect to the SQL-Server getting the
following error message
C:\Dokumente und Einstellungen\Robert>sqlcmd

I have a C++ app that is connecting (ODBC 3) to a MSSQL db.
I am issuing a DELETE statement where a "last update date" is less than the
program begin date/time.
The problem is that all of the rows on the table that are supposed to be

hi, I am running Visual Studio.net 2005 on my laptop, MSDE sql express was
installed during the installation, finally trying to get an sql database to
work, i am a newbie to both Visual studio and SQL, anyway i can see the
database inside server explorer and all its talbles, but ...

I've installed MS SQL Server 2000 Developer edition on Windows XP
professional running on Virtual PC 2004. I am unable to connect to sql server
running on a physical machine or ot the sql server instance on the virtual
machine itself.

I have a SQL Server 2000 database that I can connect to from an ASP.NET web
site quite happily.  Using the same connection string in a Windows Forms
application I get the message "When connecting to SQL Server 2005, this
failure may be caused by the fact that under the default ...

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

Hi, I have a very odd problem:
I CAN connect to a MSsql2000 server on a remote machine with username
and password (i.e. without windows authentication) from a sql quary
like program (its called sqlBuddy). So I know the server is running and

I am trying to rename a column name and it gives me the following error.  Can
any body help please.  Thanks
'MR_STRANS_051005' table
- Unable to rename column from 'ATTR4' to 'GST_AMT'.  

We have 4 instances of SQL running on 4 different servers.  We recently
had to change our administrator password.  After doing that, we cannot
connect from our computers (Windows XP SP2) to any of our SQL servers
(1 Windows Server 2000, 3 Windows Server 2003).  We see the following

I can only get a connection to server with a non-default instance name using
the
jdbc:sqlserver://ITH\SQLSERVER2005:1433;forwardReadOnlyMethod=direct;databaseName=cc;user=sa;password=123
syntax.  This connection succeeds.

I have a working SQL Server 2000.  I use Citrix to run Terminal Server
Apps which work Fine.  If I use RDP instead of ICA (Citrix) using the
same app and the same user, I get
an error as follows:

I need to connect to an Oracle database (8i) running in a UNIX box, with SQL
Server running in AD.
If anyone has done it, kindly let me know since this is new territory for me.
Thanks,

We are getting this error periodically in a large app we are converting
from Access to SQL Server 2000. It uses BDE and ODBC for data access
and TTable/TQuery as well as TwwTable/TwwQuery components (from
woll2woll) under Delphi 6. It appears to happen when we are executing

We have two instances of SQL 2005 installed, with static TCP/IP ports, one
instance on one IP address, port 1433 and the other instance on a different
IP address, port 1433.
Try to create an ODBC System DSN using SQL Native Client and it won't