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 > november 2005 > threads for november 8 - 14, 2005

Filter by week: 1 2 3 4 5

System.Data error '80131904'
Posted by zeplynne at 11/14/2005 6:35:02 PM
Have a .net assembly, strong named, on an IIS box running Win 2000 Advanced Server (box is in DMZ). Web site connects to a Sql Server box (not in DMZ). The legacy asp app has no problem connecting to Sql Server, but when the dll is invoked in the asp app, and it attempts to connect to Sql Server...more >>


error message in application
Posted by lslmustang at 11/14/2005 11:11:05 AM
We updates the 2000 SQL Server to SP 4 and are getting the following error: Application error: cannot go remote while the sessions is enlisted in a distributed transaction that has an active savepoint source: microsoft OLE DB Provider for Sql Server Error code: -2147217900 Any ideas? Than...more >>

linked server error: OLE DB provider 'SQLOLEDB' reported an error.
Posted by RHI Claims Explorer at 11/14/2005 8:25:12 AM
I set up a linked server between two SQL Server databases. I was able to query the linked database just fine. Then I deleted the linked server using Enterprise Manager. Then I re-created the linked server using Enterprise Manager but the original query (select * from [linked server name].[d...more >>

System.Data and System.Data.SqlClient - Which one should I use ?
Posted by Steven Wilmot at 11/13/2005 10:09:16 PM
I've recently started to convert an old VS2003 project that was using some SQL2000 I now want to convert this project to VS2005 I've currently referenced: D:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.Data.dll (Version = 2.0.0.0) AND: D:\Program Files\Microsoft Visu...more >>

HELP: migrating/learning T-SQL... from SQL woes :S
Posted by KevinGPO at 11/13/2005 6:25:57 PM
Just wondering a few queries about the differences between programming SQL for MS Access, and programming T-SQL for SQL Server. 1. Is it possible to use the same general SQL statements/commands from a ASP page that was used with a MS Access DB, for a SQL Server DB? (Basically can you progra...more >>

Access 2003 and ADP AND sqlserver 2005
Posted by Bruno at 11/13/2005 11:46:14 AM
Is ADP dying? ...more >>

c++ lib
Posted by Abe at 11/13/2005 12:00:00 AM
i am looking for c++ libs so that i may connect to sqlserver..(user does not have client sql installed) thanks ...more >>

SQL server error 233
Posted by Otis Mukinfus at 11/11/2005 5:14:03 PM
Can anyone tell me what the cause of the error below is? I have the client tools installed on XP Pro Svc Pack 2.0. When I try to connect to the server on the remote machine I get the error message below. I have set the logins up correctly for the user id I'm using on the client machine an...more >>



Request for current credentials
Posted by DLS at 11/10/2005 10:04:03 PM
I'm not sure how this issue arose, but suddenly I keep getting an alert that: 'Windows needs your current credentials to ensure network connectivity' and requests to log off and log back on. I successfully establish a VPN connection and this error occurs when I open Enterprise Manager to conne...more >>

Where do I download VS 2005 Express
Posted by Roy Gourgi at 11/10/2005 12:46:22 PM
Hi, Where do I download the free edition of VS 2005 Express? Has anyone experienced problems with VS 2005 Express? TIA Roy ...more >>

SQL Express Edition 2005
Posted by Sara T. at 11/9/2005 12:00:00 AM
Anybody knows the limit of concurrents connection of SQL Express Edition 2005? As I know, MSDE has begun to limit to 10 concurrents and extended to 25 concurrents for the new version, but I read the specification of Express Edition 2005, I cannot find the number of concurrent connection. ...more >>

Querying connection properties
Posted by Jim Trowbridge at 11/8/2005 5:22:02 PM
Is it possible to find connection properties from within SQL Server ? I am interested in running a query (hopefully) that will return all parms used for any individual connection....more >>

VS 2005 - Server Explorer - Diagrams - Invalid DBO User
Posted by Jay Douglas at 11/8/2005 11:07:52 AM
When attempting to edit diagrams in Server Explorer from Visual Studio 2005 I receive the following error: This database does not have a valid dbo user or you do not have permissions to impersonate the dbo user, so database diagramming is not available. Ensure the dbo account is valid and e...more >>


DevelopmentNow Blog