My sql 2000 server is connecting to as400 using IBM odbc. How can I access
to data of various member of a file db2/as400? What is the syntax of sql
scripts?
Thx,

We have a 64bit SQL Server 16GB Memory running on Windows 2003 x64. This is
one of our main business database servers. At this time we have an issue
where the server will stop allowing new connections in, the client will
receive a timeout (instantly) and from .NET the stack is

I am remotely accessing SQL Server 2005 using an import manager,
through a windows authentication login.
I start the loading, it connects perfectly at first but at the 100
second mark I get the error

I have Sql Server 2005 Std edition installed on a Windows 2003 server and
the client components installed on my machine with Win XP.
The Surface area configuration was configured on the server to allow TCP/IP
and named pipes.

I try to make a connection with the database "test" contained in sql server
express 2005.
This is the connection string in the aspx file:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"

I am receiving this error while trying to connect to a SQL Server 2005
instance.
"An error has occurred while establishing a connection to the server.  When
connecting to SQL Server 2005, this failure may be caused by the fact that

I'm using SQL server 2005 Express Edition in my solution and I've run into a
problem that I can't find any information about.
The application was running OK (for several days) until this happend just
out of the blue.

i'm looking after an equivalent T-sql command as "load data local infile
..." of Mysql, in order to import a textfile into sql server express 2005
containing data and delimited with tabs.
Thanks

We've installed SQL Server 2005 Express on a Windows XP SP2 machine that
will serve as the server.  The configuration is fine and we've enabled all
the protocols.
The client computers are mostly Windows 2000 and one Windows XP machine.

          I am an VC++ programmer. I had written an VC++ application, which
will fetch data from SQL Server. I am doing DB Connectivity by creating a
DSN.
          My application works perfectly. But it lacked with  need some

          I am an VC++ programmer. I had written an VC++ application, which
will fetch data from SQL Server. I am doing DB Connectivity by creating a
DSN.
          My application works perfectly. But it lacked with  need some

I have two servers with the following detail:
Server #1
Server Name: SQL2005WIN2003SERVER
Windows: Win 2003 Server

We installed long horn server build 6001 and then we enabled
IISv7.0.Subsquently We installed SQL Server 2005 enterprise edition (EvAl)
After installation is completed all the SQl related services are up and
running.

hi *
I have some program, written in C, that uses ODBC API to connect to
MSSQL Server 2000/2005. To create a connection with server I use
SQLDriverConnect function with such connection string:

I migrated copies of a database to a test server, but I cannot log on. My
admin account needs to be dropped and readded but every time I run
sp_dropuser in query analyzer I get the error :
Msg 15183, level 16, state 1, ....