|
|
|
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 |
Filter by week: 1 2 3 4 5 not sure what my connection's name is Posted by middletree at 1/6/2006 2:58:25 PM I'm moving my intranet app from one development server to another. The old
one was Windows 2000 Server with SQL Server 2000. The new one is XP Pro with
SQL 2005 Express.
here is the connection string I have been using on the old machine for
years:
strDBConnection = "Provider=SQLOLEDB;Persi...more >>
More Connect Issues Posted by Trex at 1/5/2006 6:53:49 PM I have an instance of SQL Server 2005 on two different development machines.
At first we could not connect to Machine A until we read about how it comes
locked down. We went to SQL Server Config Mgr and enabled all necessary
protocols and can connect just fine to it. When we did the same to ...more >>
Need to change connection string for SQL 2005? Posted by A1b2c3d4 NO[at]SPAM community.nospam at 1/5/2006 1:40:05 AM Hi,
DevStudio 2003, SQL Server 2005, Windows 2000 Pro SP4
I have been using the Enterprise Library Data Access Application Block to
connect to a local SQL 2000 database. The connection string parameters are:
<connectionStrings>
<connectionString name="Temp Connection String">
<parame...more >>
SQL server 2005 login issue 4 Posted by Shaun R. at 1/4/2006 1:51:04 PM Hello Again All,
Thanks again to Rick Byham for your seggestions.
Ok I started SQL Management Studio and loged in using Windows Authentication
then I ran the query
ALTER LOGIN sa ENABLE ;
GO
ALTER LOGIN sa WITH PASSWORD = '<password>' ;
GO
Then I closed the SQL Management Studio and...more >>
all of a sudden, can't connect Posted by middletree at 1/4/2006 9:57:50 AM I have SQL Server 2000, not sure which SP. A db that I created 3+ years ago
has been running smoothly, but today, I cannot connect. Specifically, in
Enterprise mgr, when I click on the name in the tree on the left, or if I
right-click and select Connect, I get a message box which says:
"A c...more >>
SQL Server and workgroup networks, how? Posted by DotNet at 1/4/2006 8:57:36 AM How to establish connection string for sql server on non-domain network?
...more >>
Problem to pass UID and PWD in SQLConfigDataSource using MFC Posted by Anis Khalife at 1/4/2006 3:23:11 AM hi..
SQLConfigDataSource( NULL , ODBC_ADD_DSN ,
"SQL Server" ,
"DSN=DBVoip\0"
"SERVER=10.11.40.221\0"
"ADDRESS=10.11.40.221\0"
"Trusted_Connection=no\0"
"UID=sa\0"
"PWD=mis\0"
"DATABASE=VOIP\0\0"
);
not working...
without UID and PWD it is working fine...
plz help
...more >>
SQL 2005 login issue 3 Posted by Shaun R. at 1/3/2006 10:40:02 PM Hello All,
I like to say thankyou to Rick Byham for his reply to my previous post
entitled SQL 2005 login issue 2....
Rick I did try what you suggested first I changed my connection string to
"server=p3xp;uid=;pwd=;database=master
I received the message
login failed for user 'sa'...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Single User mode Posted by Morten Snedker at 1/3/2006 2:21:01 PM After coming back from the x-mas holidays an employee says "this
database doesn't work!". "This database" was an Access mdb with ODBC
connection to our SQL-server 2000.
It took me hours to determine the problem: the database was in Single
User mode, restricting access to the database.
Is th...more >>
New Installation can't connect to default database Posted by ChristieD at 1/3/2006 11:11:03 AM I installed SQL Server 2005. Connected to an external dB on a different
server just fine. Now am trying to connect (via SQL Server Management Studio)
to the default local dB. I get the following error:
Cannot connect to <server name in here>
A connection was successfully established with the s...more >>
REPLACE ALL Posted by Preacher Man at 1/3/2006 8:54:09 AM What is the SQL equivalent to a REPLACE ALL command in VFP?
I found this in the help section:
SELECT REPLACE('abcdefghicde','cde','xxx')
GO
Is this the full syntax and where would I use this command, I tried in the
EM but it doesn't seem to work.
...more >>
Single User mode is the solution ? Posted by CSV at 1/3/2006 7:29:05 AM HI All,
I am a developer not a database administrator. I need to figure out a
way that only one user should be using the database from our .net
application. If i start the database instance in single user mode, does that
solve my problem. It might be possible to verify whether someone i...more >>
Microsoft SQL Server Management Studio Express Posted by Nick K at 1/2/2006 8:21:52 AM I am attempting to connect to a SQL Server 2005 database using a Visual
Studio.Net 2003 application.
When I use this connection string, I get a Keyword not supported: 'user
instance'. error.
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;uid=sa;pwd=;User
Instance=True;AttachDBFilena...more >>
SQL server 2005 login issure 2 Posted by Shaun R. at 1/2/2006 6:42:02 AM Hello All,
If by any change you have read my original post titled "SQL Server 2005
login issue and also the post from "Jens"..... This message is in regaurds
to those two posts.
First of all Jens thank you for your reply.
I am still having the same trouble despite the post from "Jens"...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |