Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
August 2008


all groups > sql server connect > may 2006 > threads for may 15 - 21, 2006

Filter by week: 1 2 3 4 5

Application Performance
Posted by Matt Schwartz at 5/21/2006 1:26:01 PM
I'm not sure if this is the best forum to post this in (if not, if somebody can suggest a good forum to post this question, I would appreciate it!) I have a client with an application setup as follows: (1) Web Server running Windows 2003 Standard Edition Server & IIS. (1) Web Server also ru...more >>

SQL & C++
Posted by E.R. at 5/18/2006 10:16:01 PM
For some reason i want to use visual c++ 6.0 , and i need to connect to sql server! (most probably 2005) can this be done? if yes please provide me with a sample on how to connect (e.g. how to create connection, data adapter , data set.... , the whole deal) thank you in advance, i really a...more >>

SQL Express MDF file moved from 1 computer to another - auth failu
Posted by CommDown at 5/18/2006 7:41:01 AM
I copied a project I am working on from one computer to another computer for work at home. I try to access the mdf file that I have for this project, and now it tells me that authentication has failed for my windows authentication on my system. I am trying to find out how I can change the au...more >>

Specifying program_name in connect string
Posted by Tom at 5/18/2006 6:07:02 AM
Is there a way to specify the sysprocesses.program_name value in the OLE DB connect string? I can't find the syntax anywhere. Thanks, Tom...more >>

Excel 2003 doesn't work with SQL 2005 AS
Posted by Igor A. Chechet at 5/18/2006 12:00:00 AM
Greetings! We have a connectivity problem between Excel 2003 and SQL Server 2005 AS. We created cubes and it works OK on server. Then we installed Excel 2003 on AS server to check connectivity. It works OK. But on any other workstation with Excel installed it could not connect. It shos the ...more >>

Connection via Internet with IP address and cached Windows Authentication?
Posted by John at 5/17/2006 4:38:02 PM
The server I am working on is configured for TCP/IP, Windows Authentication only, the SQLExpress named instance have been configured to use port 1433 and the appropriate changes have been set on the firewall . Q1. Is it possible to remotley connect to SQLExpress 2005 via the internet specifyi...more >>

Problem with Delete On Linked Server
Posted by Neil at 5/16/2006 8:37:14 PM
I am getting time-out errors when I try to perform a simple delete on a linked server. The command is: Delete From MyTable Where PKID=12345 I have tried executing this command directly from Query Analyzer, but it just times out. However, when I run it from QA against the server itself ...more >>

Win XP slow, Win 98 fast
Posted by Jeff at 5/16/2006 1:17:02 PM
We are using a third party app on Win XP SP 2 machines (3.0 Ghz, 1G RAM) that uses SQL Server 7.0 SP4 as the underlying database engine which is running on Win NT 4.0 SP6. All 8 of these XP machines run extremely slow when we use this app to read and especially when we write to the SQL databa...more >>



Databse is lost
Posted by Al Gates at 5/15/2006 10:35:01 PM
Hi, I am using windows server STD 2003, with SP1, with SQL server 2000 with SP1. The database stops working almost every 24 hours. I have to stop/kill services and then start again to get it back up. Kindly advise. Thanks...more >>

Connect to SQL 2005 via Visual Studio application
Posted by Benner at 5/15/2006 5:46:01 PM
I have created a SQL 2005 database with about 100 tables. It was actually mostly created on 2000 and attached. I have started creating a VS VB application. I am able to use any and all the tables in the applications. I have updated individual tables. I have published the appl and have i...more >>

Connecting to SQL Express from C# via connection string
Posted by Steve Wash at 5/15/2006 9:13:02 AM
I created a SQL Express database from within Vistual Studio. It had a property ConnectionString, so I grabbed that value and attempted to use it in code. (I did add an @ at the beginning and doubled the literal double quote symbols.) The code that assigns the connection string and opens the...more >>

Remote connection to SQL Server 2005
Posted by bostonguy NO[at]SPAM gmail.com at 5/15/2006 7:11:13 AM
I am unable to connect to a SQL Server 2005 instance running remotely on a Windows 2003 Server machine behind a router. I can connect to the instance via SQL Server Management Studio Express when I place the server machine in the DMZ, but I cannot connect when I forward traffic on port 1433. Not...more >>

Logging Into Linked Server
Posted by Neil at 5/15/2006 12:00:00 AM
After creating a linked server to a remote server, I needed to log in using sp_addlinkedsrvlogin to get my stored procedure to work. However, I noticed that after stopping SQL Server and the DTC and then restarting both, that my stored procedure worked without having to execute sp_addlinkedsrv...more >>


DevelopmentNow Blog