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
all groups > sql server connect > march 2007 > threads for march 8 - 14, 2007

Filter by week: 1 2 3 4 5

Permissions issue?
Posted by Nancy at 3/14/2007 4:24:19 PM
I have a SQL Server 2005 Express db on my local machine for testing and I'm using Dreamweaver 8 to connect to it. No problem. However.. when I try out a page on localhost through a browser, I get this message: Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC SQL Se...more >>


Update SQL Server data through Access
Posted by Harold I at 3/14/2007 7:28:13 AM
i am trying to update linked SQL Server tables in Access. i don't receive any error messages. i can open the linked table and view the data, but i cannot update the info. i can update in SQL Server and view the new info in Access. any ideas? Thanks....more >>

SQL Server 2005 Express-Connection Limit?
Posted by Todd C at 3/14/2007 6:46:13 AM
Is there a limit to the number of users that can be connected to a SQL Server 2005 Express instance? If the hardware is beefy enough, could it support 20 or 30 simultaneous connections? TIA -- Todd Chittenden...more >>

SQL2005 & VB6: "SQL Server does not exist or access denied"
Posted by Wimpie van Lingen at 3/14/2007 12:00:00 AM
Hi 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. They connect to the SQL Server via a VB6 applicat...more >>

SQL 64 to Oracle Link
Posted by Chuck P at 3/13/2007 2:58:04 PM
I tried to setup a link from Win03; Sql 05sp1 64 bit (ProLiant dl385 AMD) to Oracle and I get an error. EXEC sp_addlinkedserver 'orp5', 'Oracle', 'MSDAORA', 'orp5' EXEC sp_addlinkedsrvlogin 'orp5', false,null, 'username', 'password' SELECT * FROM orp5..XXSA.XXSA_OID Msg 7403, Lev...more >>

linked server to jet database
Posted by Bart at 3/13/2007 9:18:26 AM
Hi, I have a problem using an jet database as a linked server. when there is no database password on the mdb database everything is working fine. When I put a password an the mdb database I receive the error: Msg 7399, Level 16, State 1, Line 1The OLE DB provider "MSDASQL" for linked server ...more >>

OLE DB Services and SQL Native Client
Posted by Michael Tissington at 3/13/2007 8:40:37 AM
Is the option OLE DB Services = -4 still valid in the connection string with the SQL Native Client ? ...more >>

Surface Area Manager
Posted by Dimitri at 3/13/2007 2:38:56 AM
Bonjour, Voil=E0 , j'ai install=E9 une instance SQL server 2005 SP2 sur un serveur windows 2003 SP1. Lorsque je lance le surface Area manager pour configurer mon instance, j'ai besoin d'activer xp_cmdshell, j'ai le message d'erreur ci dessous : =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3...more >>



SQL Native Client and SMux Provider
Posted by Michael Tissington at 3/12/2007 10:43:48 AM
I have recently changed my application from using SQLOLEDB to SQLNCLI. Occasionally I'm seeing an error "SMux Provider: Physical Connection is not usable" What does this mean and where does it come from ? Thanks. ...more >>

Absolutely no luck connecting
Posted by david.pendleton NO[at]SPAM pattersondental.com at 3/11/2007 1:11:31 PM
Hello all. I have one laptop and one workstation. Both are running: - Windows XP Professional SP2 - Microsoft SQL Server 2005 SP2 (SQLServer2005SP2-KB921896-x86-ENU) - No Domain. Workgroup configuration. Same username and password on both systems. - Each SQL instance is named. - TCP ...more >>

Failed Connection to SQL Srvr 2005
Posted by Carl K. at 3/11/2007 7:45:05 AM
(newbie here) I'm unable to create a DSN to connect to my instance of SQL Server 2005 running on my Domain Server (Windows Srv 2003). I'm running the Developer edition. I can create a DSN on the server itself (so local connections work) but cannot from another machine on the LAN (Windows ...more >>

Connect remotely to sql server
Posted by Ricardo Teixeira at 3/9/2007 6:30:19 PM
I have in my company a server with SQL Server. how do i connect to my server (using a vb6 application made by me) from my home??? thanks for any help ...more >>

MS SQL Server Error 233
Posted by Hang at 3/8/2007 4:22:14 PM
Hi, When I try to login to SQL Server 2005 from Microsoft SQL Server Management Studio, I got following: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other ...more >>


DevelopmentNow Blog