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