Showing posts with label client. Show all posts
Showing posts with label client. Show all posts

Tuesday, March 20, 2012

Problems with MSDE

Hi all

I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation
was not the problem, but if i would connect with a client like dbamgr2k
or the MS Enterprise client, the client hangs up. If i try a nonlocal
server, it hangs too. What's the problem?

Markushi Markus,
"Markus Graf" <gurix@.bluewin.ch> ha scritto nel messaggio
news:2uejnbF28p144U1@.uni-berlin.de
> Hi all
> I'v got a Windows XP Pro SP1 Box with MSDE sql2k SP3. The installation
> was not the problem, but if i would connect with a client like
> dbamgr2k or the MS Enterprise client, the client hangs up. If i try a
> nonlocal server, it hangs too. What's the problem?
> Markus

MSDE installs by default disabling the network protocols, thus only local
connections are enabled... in order to allow remote connections, you have to
re-enable them, running the Server Network Utility (svrnetcn.exe)... restart
the service...
to enable network protocols at install time, you have to provide the
DISABLENETWORKPROTOCOLS=0
parameter to the setup.exe bootstrap installer of MSDE

on WinNT platforms MSDE installs by default allowing only truste
connections, thus SQL Server authenticated connections (providing Username
and Password) are not allowed.. in order t change this behaviour, you have
to modify the Windows registry as explained in
http://support.microsoft.com/defaul...kb;en-us;285097
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--- remove DMO to reply

problems with merge replication and server subcriber

Hi,
I'm trying to setup a replication topologie with a publisher, a server
subscriber (push-subcription) and a client subscriber (pull-subcription).
First I setup the publication and a push-subscription for the server
subcriber.
This replication works fine. Data and schema changes are replicated and I
can apply new snapshots to the subscriber any time.
Just at the moment, when I define the (re)publication on the server
subscriber every attempt to apply a new snapshot to the Server subscriber,
the merge-agent fails with the error :
Source: Merge replication provider
Number: -2147200965
Message: The merge agent fails to cleanup the subscription for
'GO-ON-DC1\SQL2005ONDC':'TestReplikation:'TestPublikation '
Category:SQLSERVER
Source: ZANDER\GOONDEV2005
Number: 245
Message: Error converting the nvarchar-Value
'MSmerge_view_logical_record_11282001' to int-Datatype.
Above message is not literal, I translated it form german, but I hope it
will help any way. By the way, sorry for my english ;-[
I hope any one can help me, i have no idee whats going wrong.
Regards
Jan
This looks like a bug. Can we get your publication script and table schema
to see if we can repro it?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Jan" <Jan@.discussions.microsoft.com> wrote in message
news:76CD7085-2418-4147-B907-AF94720330D5@.microsoft.com...
> Hi,
> I'm trying to setup a replication topologie with a publisher, a server
> subscriber (push-subcription) and a client subscriber (pull-subcription).
> First I setup the publication and a push-subscription for the server
> subcriber.
> This replication works fine. Data and schema changes are replicated and I
> can apply new snapshots to the subscriber any time.
> Just at the moment, when I define the (re)publication on the server
> subscriber every attempt to apply a new snapshot to the Server
> subscriber,
> the merge-agent fails with the error :
> Source: Merge replication provider
> Number: -2147200965
> Message: The merge agent fails to cleanup the subscription for
> 'GO-ON-DC1\SQL2005ONDC':'TestReplikation:'TestPublikation '
> Category:SQLSERVER
> Source: ZANDER\GOONDEV2005
> Number: 245
> Message: Error converting the nvarchar-Value
> 'MSmerge_view_logical_record_11282001' to int-Datatype.
> Above message is not literal, I translated it form german, but I hope it
> will help any way. By the way, sorry for my english ;-[
> I hope any one can help me, i have no idee whats going wrong.
> Regards
> Jan
|||Jan,
this entry from Raymond Mak looks as though it could be related :
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=55550&SiteID=1
although it applies to a different merge view. Apart from that, I agree with
Hilary - let's see if we can repro.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hi Hilary, hi Paul,
thanks for your immediate response.
I am new to the newsgroup. Do I have a posibility to upload files, except of
pasting it into this message?
I stored the scripts on http://www.go-on-software.de/replication/ .
Thre are 4 scripts:
1-Create-Tables-On-Publisher.sql
2-Setup-Publisher.sql
3-Create-DB-on-ServerSub.sql
4-Setup-Re-Publication-on-ServerSub.sql
the first two scrpts are executed at the publisher
the 3rd script is executed at the server subscriber
after the snapshot-agent and the merge-agent finshed
the 4th script re-publish the new database
At this time I haven't added any client subscriber.
To get the Error I create a new Snapshot (on the publisher) and mark the
server subsriber for reinitialisation. After this the merge-agent fails with
the described error message.
Thanks and
Kindest Regards
Jan
"Hilary Cotter" wrote:

> This looks like a bug. Can we get your publication script and table schema
> to see if we can repro it?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Jan" <Jan@.discussions.microsoft.com> wrote in message
> news:76CD7085-2418-4147-B907-AF94720330D5@.microsoft.com...
>
>
|||Hi Jan - I click on the hyperlinks but there isn't a file behind it.
Cheers,
Paul
|||Hi Paul,
sorry... my web server doesn't support files with .SQL extensions.
I renamed all to ".txt" and added an zip-file including the 4 scripts.
This time I tested it on stage.
Regards
Jan
"Paul Ibison" wrote:

> Hi Jan - I click on the hyperlinks but there isn't a file behind it.
> Cheers,
> Paul
>
>
|||Hi Paul,
have you got the scripts now? (from http://www.go-on-software.de/replication/)
and
have you found time to run the script and could you repro the error?
I would be happy about any feedback.
Kindest Regards
Jan
|||Jan - it is taking me too long to reformat to get the scripts to work
Pls can you post them up in formatted form?
Rgds,
Paul Ibison
|||Hi Paul, I am ashamed, sorry once again.
I now converted the files to ANSI, so the will be displayed in the browser
with CR.
Alternatively you can download the zip-file, which includes the 4 scripts.
Redards Jan
|||Jan,
I now have it set up and working fine. Did you have a problem with the
original setup or was there a subsequent problem caused by a change made?
It may or may not be relevant, but I probably can't mimic your environment
exactly as I am using no sp1 or sp2 at the moment - our servers have just
been rebuilt and will have the sps applied later on this month.
Rgds,
Paul Ibison

Problems with Linked Server to ORACLE (on SQL 2005 64bit)

Hi all

I have a big problem with creating a linked server to ORACLE database!

- I have installed ORACLE Client 10g on my server (Windows Server 2003 64 bit)
- With ORACLE Tools I am able to connect to the ORACLE Server
- When I try to connect in SQL Server I get the following error:
Cannot create an instance of OLE DB provider "OraOLEDB.Oracle" for linked server
"MISPROD.WORLD".

I have tried I guess all combinations of getting data out of ORACLE ... :-(
For example:
- SELECT * FROM OPENQUERY([MISPROD.WORLD], 'SELECT * from ORACLE_TABLE')
- SELECT * FROM [MISPROD.WORLD]...ORACLE_TABLE
I allways get the same error and I dont know what to do ...

Would by very very happy for any comment.

Best regards
Frank Uray


I got the solution:

- Use 64bit ORACLE Client (10.2.0.1)
- Enable "Allow Inprocess"

Frank Uray

Friday, March 9, 2012

Problems with disconnected recordsets i Yukon

We have a VB6 application using ADO 2.8 connecting to SQL Server.

We use disconnected recordset to load data to client-side. The client does updates in the recordset and then sends it back to server-side component that converts the recordset into SQL to update the database. No problems in SQL 2000 but on Yukon we get error when trying to update the disconnected recordset on the client.

Error: -2147217887 Multiple-step operation generated errors. Check each status value.

Error only occurs on recordsets which obviously won't work it was a connected recordset; for example a UNION sql.

Is this the way Yukon is supposed to work? Is there anyway to disable this new functionality to really get a disconnected recordset?

One thing that would work is to create a recordset from scratch based on the loaded recordset and copy all data into this new recordset. But it seems like a lot of work doing this each time.

I suspect that Yukon is more accurately reporting that certain columns are not updatable and ADO is marking the disconnected recordset fields as read only. I'll see if there is a way to disable this. One thing you could do to see if this is the case is save the ADO recordset to XML and compare XML from SQL 2000 and Yukon to see what is different.|||

I have a similar problem, did you find any solution to this? I've tried all ADO recordset properties, but I can't find anything.

I saved ADO recordset to XML from SQL 2000 and SQL 2005. There was one difference that is propably the cause. XML from SQL 2005 was missing rs:writeunknown property from attributes. I just don't want to create a recordset first and copy data from original recordset or save the recordset to xml and modify it.

|||Unfortunately I never found any better solution than the one I described.

Problems with disconnected recordsets i Yukon

We have a VB6 application using ADO 2.8 connecting to SQL Server.

We use disconnected recordset to load data to client-side. The client does updates in the recordset and then sends it back to server-side component that converts the recordset into SQL to update the database. No problems in SQL 2000 but on Yukon we get error when trying to update the disconnected recordset on the client.

Error: -2147217887 Multiple-step operation generated errors. Check each status value.

Error only occurs on recordsets which obviously won't work it was a connected recordset; for example a UNION sql.

Is this the way Yukon is supposed to work? Is there anyway to disable this new functionality to really get a disconnected recordset?

One thing that would work is to create a recordset from scratch based on the loaded recordset and copy all data into this new recordset. But it seems like a lot of work doing this each time.

I suspect that Yukon is more accurately reporting that certain columns are not updatable and ADO is marking the disconnected recordset fields as read only. I'll see if there is a way to disable this. One thing you could do to see if this is the case is save the ADO recordset to XML and compare XML from SQL 2000 and Yukon to see what is different.|||

I have a similar problem, did you find any solution to this? I've tried all ADO recordset properties, but I can't find anything.

I saved ADO recordset to XML from SQL 2000 and SQL 2005. There was one difference that is propably the cause. XML from SQL 2005 was missing rs:writeunknown property from attributes. I just don't want to create a recordset first and copy data from original recordset or save the recordset to xml and modify it.

|||Unfortunately I never found any better solution than the one I described.

Problems with disconnected recordsets i Yukon

We have a VB6 application using ADO 2.8 connecting to SQL Server.

We use disconnected recordset to load data to client-side. The client does updates in the recordset and then sends it back to server-side component that converts the recordset into SQL to update the database. No problems in SQL 2000 but on Yukon we get error when trying to update the disconnected recordset on the client.

Error: -2147217887 Multiple-step operation generated errors. Check each status value.

Error only occurs on recordsets which obviously won't work it was a connected recordset; for example a UNION sql.

Is this the way Yukon is supposed to work? Is there anyway to disable this new functionality to really get a disconnected recordset?

One thing that would work is to create a recordset from scratch based on the loaded recordset and copy all data into this new recordset. But it seems like a lot of work doing this each time.

I suspect that Yukon is more accurately reporting that certain columns are not updatable and ADO is marking the disconnected recordset fields as read only. I'll see if there is a way to disable this. One thing you could do to see if this is the case is save the ADO recordset to XML and compare XML from SQL 2000 and Yukon to see what is different.|||

I have a similar problem, did you find any solution to this? I've tried all ADO recordset properties, but I can't find anything.

I saved ADO recordset to XML from SQL 2000 and SQL 2005. There was one difference that is propably the cause. XML from SQL 2005 was missing rs:writeunknown property from attributes. I just don't want to create a recordset first and copy data from original recordset or save the recordset to xml and modify it.

|||Unfortunately I never found any better solution than the one I described.

Wednesday, March 7, 2012

Problems With Client Connections

I will try to keep this as concise as possible. I am trying to set up a new
SQL Server 2005 Express server.
The OS is Windows XP Pro SP2. SQL Express is SP2.
I am able to connect to the instance locally through shared memory. I am
also able to connect to the instance locally with TCP by selecting browsing
and the network tab.
I have been able to connect through ODBC from one client desktop through MS
Access.
I am unable to establish a connection from any other client. They are all
on the same subnet. I have tried updating the driver to SQL Native Client
but still cannot connect. I receive the very long error message that
essentially states that it doesn't exist or I do not have permission to it.
I hope that this will be enough information for someone to make some
suggestions.
Thanks in advance for reading this post.
Bill
Perhaps these articles will help:
Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"William Downey" <wdowney@.mclean.harvard.edu> wrote in message
news:%23emSqz9FHHA.4588@.TK2MSFTNGP05.phx.gbl...
>I will try to keep this as concise as possible. I am trying to set up a
>new SQL Server 2005 Express server.
> The OS is Windows XP Pro SP2. SQL Express is SP2.
> I am able to connect to the instance locally through shared memory. I am
> also able to connect to the instance locally with TCP by selecting
> browsing and the network tab.
> I have been able to connect through ODBC from one client desktop through
> MS Access.
> I am unable to establish a connection from any other client. They are all
> on the same subnet. I have tried updating the driver to SQL Native Client
> but still cannot connect. I receive the very long error message that
> essentially states that it doesn't exist or I do not have permission to
> it.
> I hope that this will be enough information for someone to make some
> suggestions.
> Thanks in advance for reading this post.
> Bill
>
|||Thanks for the article links.
Unfortunately, it seems I have tried nearly everything I can think of to get
clients to access the instance.
I did notice a previous thread that mentioned a similar issue.
The troubleshooting path I am headed down now is one of network-related
issues.
I wonder if anyone has had similar connectivity issues and had to tweak lan
settings?
Bill Downey
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:%237eThA%23FHHA.4652@.TK2MSFTNGP04.phx.gbl...
> Perhaps these articles will help:
> Configuration -Configure SQL Server 2005 to allow remote connections
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
> Configuration -Connect to SQL Express from "downlevel clients"
> http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to
> the top yourself.
> - H. Norman Schwarzkopf
>
> "William Downey" <wdowney@.mclean.harvard.edu> wrote in message
> news:%23emSqz9FHHA.4588@.TK2MSFTNGP05.phx.gbl...
>
|||You need to enable SQL Browser service (automatic), else the clients do
not know which dynamic TCP-port the should connect to. SQL Browser (UDP
1434) helps with this.
Default instance uses TCP 1433, which works without SQL Browser, but
all instances need SQL Browser.
In the SQL Area configuration guide, I think it should ask if you want
to start SQL Browser when you enable TCP-connections on an instance
other than default instance.
Best regards
Niklas Engfelt
William Downey skrev:
[vbcol=seagreen]
> Thanks for the article links.
> Unfortunately, it seems I have tried nearly everything I can think of to get
> clients to access the instance.
> I did notice a previous thread that mentioned a similar issue.
> The troubleshooting path I am headed down now is one of network-related
> issues.
> I wonder if anyone has had similar connectivity issues and had to tweak lan
> settings?
> Bill Downey
> "Arnie Rowland" <arnie@.1568.com> wrote in message
> news:%237eThA%23FHHA.4652@.TK2MSFTNGP04.phx.gbl...
|||I dont know if it is the same situation but I am having a problem with native
clients also... Essentiallly I CAN NOT INSTALLED SQL Express 2005 because I
keep getting an error almost at the end of the installation that read like
this: "[Microsoft][SQL Native Client]SSL Provider: The certificate's CN name
does not match the passed value" I have no idea what to do. I am practically
new to this. I just wanted to install SQL to follow up with the Visual Studio
C# lessons I am taking. I am stuck in chapter 8 because I need to install SQL
in order to follow up with the lessons and I can not do it... HELP!!!! Can
someone out there tell me what I need to do to install this package? (SQL
Express 2005). I would appreciate if beside posting something that person
would email me at waltersantiago@.msn.com. I just found this group while
looking for answers to my problem and I am afraid I may not get to see the
responses, if any, to my plight... Again... I just want to be able to install
the product. The above mentioned error stop me every time... I cleaned up and
uninstalled both automatically (with the program the SQL people provide) and
manually (by following their instructions) everything they asked to be
uninstalled before trying an installation. I still get the error... What is
CN? and where is lookling for the certificate? Do I need to delete or create
a especial certificate in order to install this product? If yes then how?
Anyway any help would be greatly appreciated. I would like to keep my journey
into becoming a Visual Studio C# programmer. THanks
"William Downey" wrote:

> I will try to keep this as concise as possible. I am trying to set up a new
> SQL Server 2005 Express server.
> The OS is Windows XP Pro SP2. SQL Express is SP2.
> I am able to connect to the instance locally through shared memory. I am
> also able to connect to the instance locally with TCP by selecting browsing
> and the network tab.
> I have been able to connect through ODBC from one client desktop through MS
> Access.
> I am unable to establish a connection from any other client. They are all
> on the same subnet. I have tried updating the driver to SQL Native Client
> but still cannot connect. I receive the very long error message that
> essentially states that it doesn't exist or I do not have permission to it.
> I hope that this will be enough information for someone to make some
> suggestions.
> Thanks in advance for reading this post.
> Bill
>
>
|||I've been having similar issues with regards to connectiong to SQL Server
Express Edition. I've installed it at several locatoins with little to no
problems. But, at a current client site things are not working as they have
at other client sites, which has really frustrated me.
I've made a post in SQL Server Access ADP regarding my problem, but have
decided to search a little more for a solution. My SQL Express has SQL
Browser Started. Initally, my Access application was not able to list my
databases for my server, but after Starting my SQL Browser my application now
lists the databases on my Server, but does not allow my client to connect to
the database. This same client application is installed on the server and
loads just fine, so I kinow my logon credentials are all correct.
Your comments regarding Port 1433. Is this a port that is commonly blocked
by firewalls? If so, could this be causeing a problem with me connecting? I
have little knowledge of TCP/IP and Ports, so I do not know where to work on
this items.
I understand SQL Server and Development against it but am finding connecting
to it to be very frustrating as I'm at the point I have no clue as to what
trouble-shooting to do. Most posts I've ready make it sound like it should be
simple, but I'm still missing something.
So, In my situation, my application can "see" the Server as it lists all of
my current databases, but when I attempt to log on using SQL Authentication
it fails. I'm using Mixes Mode (Win/SQL). And, the SQL Login works fine on my
Server. What has me puzzled is that my application sees all my databases but
will no accept logon credentials that work on my Server at my Client PC.
I'm very frustated. Any suggestions on how I can do further troubleshooting.
This just seems way more complicated that Microsoft claimed when I switched
from Access to SQL Server.
Thanks, Greg
"engfelt@.gmail.com" wrote:

> You need to enable SQL Browser service (automatic), else the clients do
> not know which dynamic TCP-port the should connect to. SQL Browser (UDP
> 1434) helps with this.
> Default instance uses TCP 1433, which works without SQL Browser, but
> all instances need SQL Browser.
> In the SQL Area configuration guide, I think it should ask if you want
> to start SQL Browser when you enable TCP-connections on an instance
> other than default instance.
> Best regards
> Niklas Engfelt
>
> William Downey skrev:
>
>

Saturday, February 25, 2012

Problems with adding subscriptions

Hi, I hope anyone can help me with this problem!
I have installed RS on Win2k Server with all Servicepacks.
From my client in network i can view all Reports but I can't add new
subscriptions.
On the site "SubscriptionProperties.aspx" the "OK" and "Cancel" Button are
not working.
On my client I use IE 6.2800 with all Servicepacks.
When I connect to RS with Mozilla Firefox then I can create subscriptions.
Strange!Very strange. Can you try deleting you IE cache and see if that changes the
behavior.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Moskito" <moskito@.wecomtec.no-ip.com> wrote in message
news:eEQ3fyypEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Hi, I hope anyone can help me with this problem!
> I have installed RS on Win2k Server with all Servicepacks.
> From my client in network i can view all Reports but I can't add new
> subscriptions.
> On the site "SubscriptionProperties.aspx" the "OK" and "Cancel" Button are
> not working.
> On my client I use IE 6.2800 with all Servicepacks.
> When I connect to RS with Mozilla Firefox then I can create subscriptions.
> Strange!
>
>|||I deleted the cache and all tmp files from IE but nothing
hapens. I have the same problem like before.
>--Original Message--
>Very strange. Can you try deleting you IE cache and see
if that changes the
>behavior.
>--
>-Daniel
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Moskito" <moskito@.wecomtec.no-ip.com> wrote in message
>news:eEQ3fyypEHA.2764@.TK2MSFTNGP11.phx.gbl...
>> Hi, I hope anyone can help me with this problem!
>> I have installed RS on Win2k Server with all
Servicepacks.
>> From my client in network i can view all Reports but I
can't add new
>> subscriptions.
>> On the site "SubscriptionProperties.aspx" the "OK"
and "Cancel" Button are
>> not working.
>> On my client I use IE 6.2800 with all Servicepacks.
>> When I connect to RS with Mozilla Firefox then I can
create subscriptions.
>> Strange!
>>
>
>.
>

Problems with a table in a publication

I have a database with two publications, one for SQL CE Clients with filters that send each client its data and keeps it database with "low weight" filtering data not older than a week, and the other publications for SQL Servers.
The publication for SQL CE Clients works excelent, the other one has this problem:

In the publisher i can insert data that should be replicated to subscribers, but subscribers don't receive it. And if I try to insert both in the publisher and the subscriber, the subscriber throws a Primari Key exception.
In the other way, if i insert the data in the subscriber, when it synchronizes, the publisher pulls this data to the table and keeps it, but deletes the subscriber table due to a "conflict". And it never sends the data back to the subscriber, keeping the subscriber's table always clear.

Any Idea?

Thank you.

Omar.Rojaswhat kind of replication are you using is it merge, transaction or snapshot