-------------------------------------------------------------------
:::: Great Indian Developer Summit 2009 - GIDS .Net ::::
:::: 24 April 2009 ::::
:::: J N Tata Auditorium, IISc, Bangalore ::::
:::: http://www.developersummit.com ::::
-------------------------------------------------------------------
Dear Group members,

The economic downturn will run out of steam trying to outdo the 'ready
and waiting' software professional. Packed with premium knowledge,
action plans and advise from been-there-done-it veterans, creators...

Hi Sqlserver Experts:

I used isql untility to connect to a remote sql server.
The connection was successful. First query was also successful. But
after 30 seconds of idle time. The same query would fail.

Here is my odbc.ini file
[BCM_SLP]
Description = FreeTDS
Driver = /usr/lib/libtdsodbc.so.0
Server = 10.50.5.56
Database = BCM_SLP
UID = user
PWD = password
Port = 1433
TDS_Version = 7.0

Hi,

could someone please help me?

I have a notebook with Windows XP SP 2 and I installed SQLServer Express 2005.

I'm developing a web site using ASP.NET and I'd like to enable caching with
SQL support.

When I run the aspnet_regsql.exe program to create the aspdbnet database and
enable the caching dependency I receive the following error:

An error has ocurred while establishing a connection to the server. When
connection to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connection.
(Provider: named Pipes Provider, error: 40 - Could not open a connection to
SQL Server)

I am able to connect to the server using the sqlcmd program. In addition,
I'm not trying to do a remote connection since I'm trying to connect the SQL
Server localy.

Thanks in advance for your help!

I have SQL Server 2005 Express on my laptop so I can run certain programs
without being connected to our network. I have the ODBC set to the laptops
SQL Server Express databases. I use this to work on Reporting Services and
check for data entry errors.

I have been running this program on my laptop for the last year. I just
detached and deleted the .mdf and .ldf. I created the database new to
replace the one I deleted and then did a restore with a .bak. I can now only
connect to the database when I am connected to our network? If I am not
connected to our network I get a [Microsoft][SQL Native Client]Named Pipes
Provider: Could not open a connection to SQL Server [1231]. I recreated the
ODBC and checked the permissions settings on the database.

Any ideas to correct this problem are greatly appreciated.

Thank you
Frank

I need to rename the host box for a SQL Server 2000 installation (no named
instances).

Can I just stop SQL Server, change the network name, reboot the box and have
the default instance of SQL Server come up and be accessable without any
other action?

Are there any gotcha's for me to be concerned with?

Thanks,
John

have a fresh new install of VS2008 on Vista 64Bit and SQL management studio.
I manage to connect to the sql 2008 from within the management studio but
when I am not able to create a database connection from within VS 2008.

When I launch the wizard in VS, click the "server name" droplist, I can see
the name of the server, but when I try to select a DB, no DB shows up.

I using a login with full admin privileges.

Thanks in advance

Remote connections seem to be quite a complex issue judging from the
voluminous discussions on it. I have been trying to get an ODBC connection
to a remote SQL Server 2008 without success. I have examined the error logs,
used sqlcmd -L, used pipes, including stepwise implementation of
recommendations. All to no avail. What are the best practices to guarantee
success? Is there an approach from microsoft, similar to the ones used for
setting up networks (saving the connection settings that can be used to set
up each station), which can save time? Is there a complete flow chart
detailing the steps from SQL Server installation to complete implementation
that is available?

Recently we migrated our database server to a separate machine.

This machine was on a separate standalone IP (our hosting company
could not allow the two machines to be networked together), which
we can connect via CF datasource.

The website works fine and is actually faster than before when
everything was on one machine.

However, during the course of a day we get about 20 errors such as the
one shown below:

We average about 6000 unique visitors and about 37000 page requests
per day, and except for these errors everything seems fine with the
site.

These errors happen randomly at any page – it is not limited to any
particular page so we cannot even replicate this issue.

Is there something we can do to fix this? Is this look like a JDBC
driver issue or a network issue? Our webserver does have to make an
outgoing requests to the database server through the same network card
– could this be an issue. It does not look like the card is maxed out
though.

Any help would be appreciated.

www online kredite online kredite im sofortkredite kfw kredite sofort kredite online

+
+
+++ GUENSTIGE KREDITE ONLINE +++ KREDITE IM INTERNET OHNE SCHUFA +++
+
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
http://jhku.net/KREDITE-ONLINE-24/
+
+
+
+

i need to change the options on the current DB. the first thing i need to do
is alter database "xx". How do i detect the current database name
programatically with a TSQL-script?

Leon