Feeds»SQL Posts

�

tblMashedUp

SQL Blogs on MSDN

SQL Blogs on Technet

SQL Server 2008 @ Facebook

SQL YouTube Videos

SQL Posts

NNTP Connect

cannot create a connection with VisualStudio 2008 and SQLServer 2008

I have sqlserver 2008 installed on a windows xp server. I am trying to
connect to the database in visual studio. When I try to add a connection
the instance of the server is not found. I am able to view the database
using the SQL Server Management Studio.
any help would be much appreciated
john

5/4/2010 7:16:21 PM

NNTP Connect

c code,ado

c++ ado
strcpy(sqlbuf, "select a, b, c, (case when (y=2) then d else null end) as
d
pRS->Open(sqlbuf,vtMissing, AdoNS::adOpenKeyset, AdoNS::adLockBatchOptimistic,
-1);
while(pRS->adoEOF == false)
{
//how do i read the values a, b, c and d?.
//When i try to read the value d , i get the mismatch error.

5/1/2010 12:10:32 PM

Clustering

clustering mirror server

Please let me know if the following scenerio is technically feasible.
There is an active/passive cluster, users databases are mirrored.
Mirror server has its own active/passive cluster.
Thank you.

5/1/2010 12:40:01 AM

NNTP Clustering

clustering mirror server

Please let me know if the following scenerio is technically feasible.
There is an active/passive cluster, users databases are mirrored.
Mirror server has its own active/passive cluster.
Thank you.

5/1/2010 12:40:01 AM

NNTP Connect

Connection Strangeness

We have the following in the hosts file
10.10.9.2 lvac03dmz
10.10.9.20 lvac09dmz
10.10.9.2 dmzserver
We can connect to the database (same on both .2,.20 getting ready for
migrating to new server we want to change the alias dmzserver in the
future to .20) using any of the following in the connection string

4/30/2010 11:08:11 PM

NNTP Replication

2005 sp2 standard edition to 2005 sp2 standard edition replication

hi,
can someone provide information or document to setup replication between two
sql 2005 sp2 standard edition server.
thanks
npatel

4/30/2010 9:12:01 PM

NNTP Connect

Connecting with SQL Server Express 2005 when Wireless is active

Hi all.
I have a strange problem.
On a laptop I installed SQL Server express 2005.
If I'm not connected to a LAN, or if I'm connected via "copper", I can use
SQL Server through MS Access. If I open a connectio to a Wireless LAN, I
can't use my local DB. I use a trusted connection on TCP port 1433. Note

4/29/2010 10:25:17 AM

NNTP Replication

SQL Server 2005 Replication Question

I am looking into possible options for replicating data for reporting
purposes. I have found transactional replication to work best for realtime
reporting, source used for user transactions and target for reporting. I have
come across a large vendor database 50GB on SQL Server 2005 where reports are

4/28/2010 6:32:01 PM

NNTP Replication

Oracle publisher

I have successfully created an Oracle publisher in SQL 2008. woohoo!
It's kind of a groovy thing, being able to set an oracle db to be a
publisher.
The bad part...one of the bad parts, is that I cannot find the objects I
want to publish. In my oracle instance, I have a schema named ZAPHOD (not
really but ...) and it has a user named ZAPHOD. The user is the owner and

4/28/2010 4:02:02 PM

NNTP Replication

Near realtime sync of Sql Server and Sql Compact 3.5 in the real world?

Hi
I'm building a mobile application, whereby 10-15 mobile devices will
be connected via a local Wifi network to an SQL Server 2008
installation on a dedicated server.
Our database contains around 50,000 records in one table (very simple,
just 10 small varchar columns) with a primary key. These records are

4/27/2010 5:55:44 PM

NNTP Connect

Cannot connect to SQL client over VPN

I am running SQL Server 2008 at the office on Windows Server 2003.
This server connects to the internet via a router. I am running SQL
Express 2008 on my laptop on Windows 7. When I am home, I connect
wirelessly to the internet via a router.
When both computers are in the office, there are no connectivity

4/27/2010 2:33:34 PM

NNTP Connect

.Net Studio 2008, SQL Server 2000, Win 7

Hello,
I am new here and I hope that some one can point me in the right direction.
If I am wrong here or my question is not correct I apologise in advance.
I have been using VB6 up to now and I now want to convert my old project to
.Net
For this purpose I have a new workstation with Win 7 Ultimate 64bit, .Net

4/27/2010 8:47:01 AM

NNTP Connect

site not communicating with database

Hello,
I have a website on remote server developed using asp.net. I am using MS SQL
2005. My question is that the remote site was communicating with database
well for few days ago but suddenly it stopped communicating with database and
shows me msg. like Server was not found. However I know that there is

4/27/2010 2:50:31 AM

NNTP Clustering

Install - Instance root directory

On the Instance Configuration screen you can set the Instance Root directory
which appears to default to the C: drive. Should this be a local drive?
peter feakins

4/26/2010 9:45:01 PM

Clustering

Install - Instance root directory

On the Instance Configuration screen you can set the Instance Root directory
which appears to default to the C: drive. Should this be a local drive?
peter feakins

4/26/2010 9:45:01 PM

1 2 3 4 5 6 7 8 9 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50
51 52 53 54 55

pBlogCategories

sys.books