Hi..
I try to connect sql server. I have installed a sql server
1. SELFPACEDSQL
2. an instance with name MyNamedInstance

I am repeating this question here from the MSDE topic
I have found a problem when linking a SQL Server 2000 table that contains an
auto incrementing integer into Access 2002 via ODBC. Access identifies this
field correctly as an "autonumber" field. However, when I add a record to ...

I'm using SQL Server 2000. I often use the UPDATE ... SET ... statements to
change data in my database, affecting up to 3 million rows of data. If I
issue the statements from Enterprise Manager I get a "timeout expired" error
on large queries, whereas if I execute the queries ...

I'm using the .NET Framework 2.0.40903 ... I had some interoperability
issues between SQL Express and the Framework 2.0.40607, so I'm reluctant to
do anything drastic with 2.0.50215.
Has anyone taken the plunge?

I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much

I am wrting a vb application that connects to an MSDE database. I am using
ADO for the data objects and an OBDC DSN entry for connecting to the
database. Is there a way to store the username and password in the DSN entry
so that I do not need to supply this in code?

i want to filter a table by a view using a defind function
for example:
select * from person
where dbo.person.company like case CmpName()

I have the following problem.
I know that MSSQL resides under given IP adress but I do not know under
which port. Who konows how to determine this port number?
Best wihses,

hai all,
  This is manju, I am not able to execute views and stored procedures
but able to excute tables. Back end is SQL SERVER. I am accesing
database tables , views and stored procedures from ASP.

I'm getting an error message I've never seen before when I installed my
application on a client's machine.
I've got seven machines at this location that all work fine, when I install
on a new machine, I can connect through ODBC Administrator; but, when I try

       I have a Windows 2000 machine running sql server 2000 at office.
Recently, my sql server has become painfully slow. To give an idea, entering
Query Analyzer takes 1 min just to establish a connection with the database.
Choosing a database from the drop down takes a long ...

I'm having problems with VC++ 6.0 reading an Access 2000 database.
CRecordset::Close() throws an exception. I've created a simple test
dialog which does an open and close of a CRecordset. The database has
one table called 'Addresses' in it. The CAddressSet was created by the

I'm running a SQL server 2000  (recently upgraded to SP4, MDAC 2.81) on
Win2k box with 1GB memory. I've two huge denormalized tables:  one Master
table with 70 columns and 5million rows and another Summary table with fewer
columns and 2 million rows.

I am facing a problem similar to the problem here.
http://www.linuxquestions.org/questions/showthread.php?threadid=74955
Basically, I am using MS Sql Server JDBC driver. After running my
servlet for a while, I got a "Too many open files" error. Then I

Is this correct..
Microsoft JDBC driver doesn't support 'DIRECT' select mode for XADatasources
(XA database connections). So we have to use cursor method.
When I tried to switch to Direct, App didn't start with the error that