I have been struggling with a problem when connecting to a SQL Server 2005
(Developer Edition) Database from a VB6 application that runs fine with SQL
2000.   The problem seems to be that the time to opan a connection to the SQL
2005 Server takes longer than in SQL 2000.  We use ...

I have a windows 2003 server with sql server 2000
I run daily jobs that delete contents of sql tables an insert data from an
oracle9 database using
    SELECT

Hello, I am trying to retrieve data from an Informix UniData database to SQL
Server.  I am doing all the setup and work from the SQL Server.  I have
created the package in SSIS and the Connection Manager item (which is setup
as a System DSN on the server) tests ok when manually ...

I am using IIS 6.0 and have an ASP.NET where get the following error when
trying to connect from a .NET assembly.
Login failed for user  'NT AUTHORITY\NETWORK SERVICE'.
So I read some info from other forums and understand that I must add

I am having administrative previlages in the SQL Server Machine, but I am
not able to connect to the SQL Server instance. Can you please help. I am
using windows authendication.
Thanks...Safeer

I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this
procedure on three other systems with no problems. What ...

I have a question that is prob. something really quick to solve..... I
am writing a program using C# and VS2005 I have two diff. ms sql
servers set up on one ip using different ports for each. I can connect
to one of the servers using the standard port but I have not been able

Who know how to detect active connection to a particular SQL Server?
Eg: I have a SQL Server named MyServer and there are 3 computers link to
MyServer when my application start, but how do I know which of the 3
computers is linked to MyServer when application is running?

When I try to use telnet to monitor sql2005 connectivity I'm getting an
error says 17836 severity 20, state 1, Length specified in network
packet payload did not match number of bytes read; the connection has
been closed. Plase contact the vendor of the client library. In sql

I am not able to connect on my SQLServer 2k enginge from VB.NET
application.
As part of trouble shooting process, First I tried to ping to SQL Server
(Win2k and SQL2k) from the PC where I have the SQL connection problem.

i have several mdf files for several asp.net applications. How can i reach
such a database with sqlcmd?
Thanks
Bob

this code inserts twice the same record. I thin  it is due to the "Selet
Scope_Identity" in the sqlcommand.
If i remove the Select part, the inserts occurs only once. If i remove the
line "comd.ExecuteNonQuery()", then the inserts also occurs once.

I don't have Security Account Delegation for two SQL server so I cannot
create a linked server. Any other ways to select tables from server A
and insert into server B? (Besides SSIS, DTS, BCP)

I see several older posts on this topic but I can't find a resolution
outside of enable journaling on the as400 which is out of my control.
I have a linked server setup in sql server 2k to an as400 using
Microsoft OLE DB Provider for ODBC and the DSN uses the the iSeries

I want to find out number of SQL Server database engine running in my
network ?
I want to write code in VB but can you just give me idea?
Regards,