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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|