connect to distribution server

Need to be able to add data to a mobile with SQL2K
desktop edition and then manually replicate to SQL2K on
server. Can't access the distribution server from the
mobile.
Thoughts suggestions etc?
thanks
Sorry to ask the obvious, but is this when you are connected to the network?
Assuming it is, please can you clarify a few things:
the complete text of the error message,
the type of security configuration of your agents - are you logged onto the
domain, using pass-through security etc
can you 'see' the distribution server - pinging it by name will test this
Regards,
Paul Ibison
|||The distribution server is running on a SQLServer2K SE
machine running W2K OS. The remote is a laptop with
SQLServer2K PE. Both the remote and the server are
registered in EM respectively. They are both part of the
same workgroup but not a domain.
The problem arises when I attempt to use the Configure
Publishing, Subsribers and Distribution Wizard for the
laptop instance (SQLServer2K PE), The Select Distributor
dialogue has the "Use the following server..."
option "grayed-out" as is the "Add Server" button.
The only choice is to use the local machine as the
distributor which I don't want to do.
Is this a limitation of SQLServer2K PE or am I doing
something wrong with my configuration?
In the final anaylsis I need to be able to add data on
the laptop when not conncected to the server and then
manually synchronize when connected.
Thanks for your help
Thanks
>--Original Message--
>Sorry to ask the obvious, but is this when you are
connected to the network?
>Assuming it is, please can you clarify a few things:
>the complete text of the error message,
>the type of security configuration of your agents - are
you logged onto the
>domain, using pass-through security etc
>can you 'see' the distribution server - pinging it by
name will test this
>Regards,
>Paul Ibison
>
>.
>
|||The only restriction I was previously aware of is that SQL Server 2000
Personal Edition cannot be used as publisher for transactional replication.
However if you have a look at this link in BOL :
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\rep
wizrd.chm::/repwizrd_97oi.htm
it seems you are correct. This is a limitation of Personal Edition.
However,
if you are running merge replication, the distinction between publisher and
subscriber in this regard is not so big, so having the mobile as a
subscriber is a posibility.
HTH,
Paul Ibison
|||Thanks. I suppose I will have to work with merge
replication.
>--Original Message--
>The only restriction I was previously aware of is that
SQL Server 2000
>Personal Edition cannot be used as publisher for
transactional replication.
>However if you have a look at this link in BOL :
>mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
20Server\80\Tools\Books\rep
>wizrd.chm::/repwizrd_97oi.htm
>it seems you are correct. This is a limitation of
Personal Edition.
>However,
>if you are running merge replication, the distinction
between publisher and
>subscriber in this regard is not so big, so having the
mobile as a
>subscriber is a posibility.
>HTH,
>Paul Ibison
>
>.
>

:[[DBNETLIB][ConnectionWrite (WrapperWrite())

Hi ,
I am getting below mentioned error.
[dtmdump 2812] DT-03315W: It has to be manually re-created after a restore from this backup.
[dtmdump 2812] (16 hours 7 minutes 55 seconds: 2716 objects remain. Unloading. )
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[jan2004_loans_non_ppm]': [NO PREVIOUS COMMAND] Connection failure
[dtmdump 2812] (16 hours 15 minutes 43 seconds: 2715 objects remain. Unloading. )
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[jan2004_minixref_final]': [ERROR] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[jmh_brg_new_loans]': [ERROR] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[keytables]': [ERROR] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[ll_disc]': [NO PREVIOUS COMMAND] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network error. Check your network documentation.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[llrr]': [NO PREVIOUS COMMAND] Connection failure
[dtmdump 2812] (16 hours 29 minutes 16 seconds: 2710 objects remain. Unloading. )
This error comes when i try to take a logical backup of the database thru SQLBACKTRACK
I was having this problem too. But I think I've fixed it. Now, it may come as no surprise to you (then again it might), but Microsoft has a tendency to release software with some major bugs in it. I mean, how the hell can something like this get past the
testing phase?
Oh well, that being beside the point, the fix is actually in the data access components themselves. There are many reasons this error can happen. It can be any one of the following:
1) SQL Server resides on a Windows 2003 box while clients reside on a server with anything OTHER than 2003 installed.
2) SQL Server is not configured properly (unlikely, but this *is* a possiblity)
3) Client (or server) has resource issues (not enough RAM, or even HD space)
There are more errors than that, but I'm sure you don't really care. Instead, you rather just know what to do about it. Well... All you should have to do is go to the Microsoft download site and download the Microsoft Data Access Components (MDAC) version
2.8. This version has many hotfixes and updates that should resolve this issue.
Download the MDAC 2.8 onto the client machine (NOT THE SERVER (unless the client and server are the same of course)) and install it. You will have to restart the machine once the installation is complete.
If that doesn't fix your problem, then at least you have the latest MDAC with the proper hotfixes and security updates... I found that there was actually a performance upgrade when I installed it too...
- ZE7EN Out
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.
|||I had the same error: Database server
message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General network
error. Check your network documentation.].
It ended up being the NIC card. I changed to a 3com from using the
onboard one (maybe bad driver or something), and errors stopped.
sql

:[[DBNETLIB][ConnectionWrite (WrapperWrite())

Hi ,
I am getting below mentioned error.
[dtmdump 2812] DT-03315W: It has to be manually re-created after a resto
re from this backup.
[dtmdump 2812] (16 hours 7 minutes 55 seconds: 2716 objects remain. Unlo
ading. )
[dtmdump 2812] Database server message:[[DBNETLIB][Connectio
nWrite (WrapperWrite()).]General network error. Check your network documenta
tion.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[jan2004_loans
_non_ppm]': [NO PREVIOUS COMMAND] Connection failure
[dtmdump 2812] (16 hours 15 minutes 43 seconds: 2715 objects remain. Unl
oading. )
[dtmdump 2812] Database server message:[[DBNETLIB][Connectio
nWrite (WrapperWrite()).]General network error. Check your network documenta
tion.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[jan2004_minix
ref_final]': [ERROR] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][Connectio
nWrite (WrapperWrite()).]General network error. Check your network documenta
tion.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[jmh_brg_new_l
oans]': [ERROR] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][Connectio
nWrite (WrapperWrite()).]General network error. Check your network documenta
tion.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[keytables]':
[ERROR] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][Connectio
nWrite (WrapperWrite()).]General network error. Check your network documenta
tion.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[ll_disc]': &#
91;NO PREVIOUS COMMAND] Connection failure
[dtmdump 2812] Database server message:[[DBNETLIB][Connectio
nWrite (WrapperWrite()).]General network error. Check your network documenta
tion.].
[dtmdump 2812] DT-04536E: Error backing up table 'dbo.[llrr]': [
NO PREVIOUS COMMAND] Connection failure
[dtmdump 2812] (16 hours 29 minutes 16 seconds: 2710 objects remain. Unl
oading. )
This error comes when i try to take a logical backup of the database thru SQ
LBACKTRACKI was having this problem too. But I think I've fixed it. Now, it may come a
s no surprise to you (then again it might), but Microsoft has a tendency to
release software with some major bugs in it. I mean, how the hell can someth
ing like this get past the
testing phase?
Oh well, that being beside the point, the fix is actually in the data access
components themselves. There are many reasons this error can happen. It can
be any one of the following:
1) SQL Server resides on a Windows 2003 box while clients reside on a server
with anything OTHER than 2003 installed.
2) SQL Server is not configured properly (unlikely, but this *is* a possibli
ty)
3) Client (or server) has resource issues (not enough RAM, or even HD space)
There are more errors than that, but I'm sure you don't really care. Instead
, you rather just know what to do about it. Well... All you should have to d
o is go to the Microsoft download site and download the Microsoft Data Acces
s Components (MDAC) version
2.8. This version has many hotfixes and updates that should resolve this iss
ue.
Download the MDAC 2.8 onto the client machine (NOT THE SERVER (unless the cl
ient and server are the same of course)) and install it. You will have to re
start the machine once the installation is complete.
If that doesn't fix your problem, then at least you have the latest MDAC wit
h the proper hotfixes and security updates... I found that there was actuall
y a performance upgrade when I installed it too...
- ZE7EN Out
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine sup
ports Post Alerts, Ratings, and Searching.|||I had the same error: Database server
message:[[DBNETLIB][ConnectionWrite (WrapperWrite()).]General ne
twork
error. Check your network documentation.].
It ended up being the NIC card. I changed to a 3com from using the
onboard one (maybe bad driver or something), and errors stopped.