Hi All,
I just installed MSDE Release A. Haven't used it before.
Is there no interface to the database like the Enterprise Manager or isql utility?
How can I execute a query and view the databases?
Thanks
> I just installed MSDE Release A. Haven't used it before.
> Is there no interface to the database like the Enterprise Manager or isql
utility?
> How can I execute a query and view the databases?
There are no tools like EM, or QA.
But there should be a program called "osql". i've never used it before
(command line and all *shudder*). But supposedly it does come with MSDE.
The real answer to the question, "How can I execute a query and view the
databases?" is:
You write a front-end application in VB, C++, or Delphi (yeah Delphi). And
probably using ADO as the database connectivity technology.
Other than that, there are some free and (and some not free) grahical MSDE
management programs.
Google for them "free enterprise manager", or "msde management tool", etc..
|||There are GUI Utils for MSDE 2000 as Ian stated, you can Install Enterprise
manager ie the client tools if you have a full SQL server 2000 Server
version and a SQL License or use OSQL , see below article:
How To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql
Utility
http://support.microsoft.com/default...b;en-us;325003
HTH
Dylan
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:Ogm4v1ZaEHA.2388@.TK2MSFTNGP11.phx.gbl...
> utility?
> There are no tools like EM, or QA.
> But there should be a program called "osql". i've never used it before
> (command line and all *shudder*). But supposedly it does come with MSDE.
> The real answer to the question, "How can I execute a query and view the
> databases?" is:
> You write a front-end application in VB, C++, or Delphi (yeah Delphi). And
> probably using ADO as the database connectivity technology.
>
> Other than that, there are some free and (and some not free) grahical MSDE
> management programs.
> Google for them "free enterprise manager", or "msde management tool",
> etc..
>
|||Sorry i Meant NO GUI tools!
"Dylan kruger" <carmellobear1@.hotmail.com> wrote in message
news:%23bJVcnaaEHA.3752@.TK2MSFTNGP12.phx.gbl...
> There are GUI Utils for MSDE 2000 as Ian stated, you can Install
> Enterprise manager ie the client tools if you have a full SQL server 2000
> Server version and a SQL License or use OSQL , see below article:
> How To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql
> Utility
> http://support.microsoft.com/default...b;en-us;325003
> HTH
> Dylan
>
> "Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
> news:Ogm4v1ZaEHA.2388@.TK2MSFTNGP11.phx.gbl...
>
|||You can even install some free GUI tools for MSDE from web. I use a great tool by Andrea, you can grab it from http://www.asql.biz/DbaMgr/DownLoad2k.shtm
Let us know if you have any more questions.
dev_kh
"Dylan kruger" wrote:
> Sorry i Meant NO GUI tools!
> "Dylan kruger" <carmellobear1@.hotmail.com> wrote in message
> news:%23bJVcnaaEHA.3752@.TK2MSFTNGP12.phx.gbl...
>
>
|||Thank you Dylan and Dev for the links
"dev_kh" wrote:
[vbcol=seagreen]
> You can even install some free GUI tools for MSDE from web. I use a great tool by Andrea, you can grab it from http://www.asql.biz/DbaMgr/DownLoad2k.shtm
> Let us know if you have any more questions.
> dev_kh
> "Dylan kruger" wrote:
|||MSDE does not come with a front-end. Try WinSQL at
http://www.synametrics.com/winsql
sm wrote:
> Hi All,
> I just installed MSDE Release A. Haven't used it before.
> Is there no interface to the database like the Enterprise Manager or isql utility?
> How can I execute a query and view the databases?
> Thanks
Showing posts with label msde. Show all posts
Showing posts with label msde. Show all posts
Friday, March 23, 2012
Monday, March 12, 2012
Interactive Resolver
Error message: "The process failed to get information about the Interactive Resolver from the registry".
I am using MSDE to subscribe to a central 2000 database using a pull subscription and the active X controls. However, the default resolver fails to operate. I have a call in with Product Support and sent them this:
Publication articles are all marked “Use the default resolver” and “Allow Subscribers to resolve conflicts interactively during on-demand synchronizations”. Note we are treating changes to the same column as being a conflict.
On the subscriber, “on demand synchronisations” are marked “Resolve Conflicts interactively…”
In my code to control the ActiveX objects, if I set the “UseInteractiveResolver” property to True, then the error message appears. If I leave this out, the default priority subscription happens.
We ARE NOT using any third party resolver, nor are we using any resolver aside from the interactive one.
However, I still cannot get the interactive resolver to display.
Is there something else. I have tried re-registering all DLLs back on the client after copying them from the 2000 CD ROM (SP3)
Hi Top,
From your descriptoin, I learnt that you the default resolver failed to operate when you subscribed to a
central 2000 database using a pull subscription and the active X controls.
Based on my experience (not 100% sure), the issue would occur if we manually or programmatically
change the Progid of conflict viewer from Wzconflict to CnfViewer. If so, the sync manager is unable to
launch the conflict viewer.
As you have call into Microsoft with Product Support, could you provide us with the Case ID so that we can
handle your post more gracefully and also for community benefits. In this way, we can address your
problem quickly and efficiently making headway to a solution.
We look forward to hearing from you.
Best regards,
Billy Yao
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
|||SRS040408600030
|||Hi Mark,
Thank you for your information! We have looked into the issue and found the causes of this issue as I
mentioned in my previous post.
When you tried to merge the data from your client which had MSDE installed you got following error 'The
process failed to get information about the interactive resolver component from the registry". This error was
due to missing DLL files or registry entries of the conflict viewer on your client system.
To solve the problem, we should check the following Registry Keys
------
HKCR\CLSID\{A2CA91F1-7328-4949-8611-8BEDB4AD503C}\InprocServer32 --> 'C:\Program Files
\Common Files\Microsoft Shared\Database Replication\Conflict Viewer\wzcnf.dll'
Check if the dll exists in the same location.
[INFO]Other Keys Accessed by conflict viewer:
HKCR\CLSID\{00000514-0000-0010-8000-00AA006D2EA4}\InprocServer32 -->'C:\Program Files\Common
Files\system\ado\msado15.dll'
HKCU\CLSID\{0BE35204-8F91-11CE-9DE3-00AA004BB851}\InprocServer32 -->'oleaut32.dll'
HKCR\CLSID\{0BE35204-8F91-11CE-9DE3-00AA004BB851}\InprocServer32 -->'oleaut32.dll'
------
and verify this steps
Steps:
======
1) The Following Files must be in the Directories mentioned for Interactive Conflict resolver to work.
\Program Files\Common Files\Microsoft Shared\Database Replication\Conflict Viewer: wzcnf.dll ,
wzcnfclt.exe
2) The following resource file should be installed in a language specific directory \Program Files\Common
Files\Microsoft Shared\Database Replication\Conflict Viewer\Resources\<LCID>: wzcnfrc.rll
The <LCID> is usually 1033.
IF these files are missing from these directories copy them from the same location on other systems where
the conflict viewer is working fine , or copy them from the Setup CD.Now go to the directory where "Wzcnf.dll
" is located and register it by typing "Regsvr32 wzcnf.dll".
NOTE: If we dont have the Resource file Wzcnfrc.rll, The Conflict viewer will still come up, but the Labels will
be missing from the Buttons on the User Interface.Once we have the Files in place and the Dll file registered,
we'll get the Interactive conflict viwer to come up normally on the MSDE Subscribers.
NOTE: The Conflict Viewer and Interactive Conflict Viewer uses the same exe and Dll.
We appreciated your time and efforts throughout the troubleshooting process. Thank you for posting in
newsgroup.
Best regards,
Billy Yao
Microsoft Online Support
Please reply to newsgroups only. Thanks.
I am using MSDE to subscribe to a central 2000 database using a pull subscription and the active X controls. However, the default resolver fails to operate. I have a call in with Product Support and sent them this:
Publication articles are all marked “Use the default resolver” and “Allow Subscribers to resolve conflicts interactively during on-demand synchronizations”. Note we are treating changes to the same column as being a conflict.
On the subscriber, “on demand synchronisations” are marked “Resolve Conflicts interactively…”
In my code to control the ActiveX objects, if I set the “UseInteractiveResolver” property to True, then the error message appears. If I leave this out, the default priority subscription happens.
We ARE NOT using any third party resolver, nor are we using any resolver aside from the interactive one.
However, I still cannot get the interactive resolver to display.
Is there something else. I have tried re-registering all DLLs back on the client after copying them from the 2000 CD ROM (SP3)
Hi Top,
From your descriptoin, I learnt that you the default resolver failed to operate when you subscribed to a
central 2000 database using a pull subscription and the active X controls.
Based on my experience (not 100% sure), the issue would occur if we manually or programmatically
change the Progid of conflict viewer from Wzconflict to CnfViewer. If so, the sync manager is unable to
launch the conflict viewer.
As you have call into Microsoft with Product Support, could you provide us with the Case ID so that we can
handle your post more gracefully and also for community benefits. In this way, we can address your
problem quickly and efficiently making headway to a solution.
We look forward to hearing from you.
Best regards,
Billy Yao
Microsoft Online Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
|||SRS040408600030
|||Hi Mark,
Thank you for your information! We have looked into the issue and found the causes of this issue as I
mentioned in my previous post.
When you tried to merge the data from your client which had MSDE installed you got following error 'The
process failed to get information about the interactive resolver component from the registry". This error was
due to missing DLL files or registry entries of the conflict viewer on your client system.
To solve the problem, we should check the following Registry Keys
------
HKCR\CLSID\{A2CA91F1-7328-4949-8611-8BEDB4AD503C}\InprocServer32 --> 'C:\Program Files
\Common Files\Microsoft Shared\Database Replication\Conflict Viewer\wzcnf.dll'
Check if the dll exists in the same location.
[INFO]Other Keys Accessed by conflict viewer:
HKCR\CLSID\{00000514-0000-0010-8000-00AA006D2EA4}\InprocServer32 -->'C:\Program Files\Common
Files\system\ado\msado15.dll'
HKCU\CLSID\{0BE35204-8F91-11CE-9DE3-00AA004BB851}\InprocServer32 -->'oleaut32.dll'
HKCR\CLSID\{0BE35204-8F91-11CE-9DE3-00AA004BB851}\InprocServer32 -->'oleaut32.dll'
------
and verify this steps
Steps:
======
1) The Following Files must be in the Directories mentioned for Interactive Conflict resolver to work.
\Program Files\Common Files\Microsoft Shared\Database Replication\Conflict Viewer: wzcnf.dll ,
wzcnfclt.exe
2) The following resource file should be installed in a language specific directory \Program Files\Common
Files\Microsoft Shared\Database Replication\Conflict Viewer\Resources\<LCID>: wzcnfrc.rll
The <LCID> is usually 1033.
IF these files are missing from these directories copy them from the same location on other systems where
the conflict viewer is working fine , or copy them from the Setup CD.Now go to the directory where "Wzcnf.dll
" is located and register it by typing "Regsvr32 wzcnf.dll".
NOTE: If we dont have the Resource file Wzcnfrc.rll, The Conflict viewer will still come up, but the Labels will
be missing from the Buttons on the User Interface.Once we have the Files in place and the Dll file registered,
we'll get the Interactive conflict viwer to come up normally on the MSDE Subscribers.
NOTE: The Conflict Viewer and Interactive Conflict Viewer uses the same exe and Dll.
We appreciated your time and efforts throughout the troubleshooting process. Thank you for posting in
newsgroup.
Best regards,
Billy Yao
Microsoft Online Support
Please reply to newsgroups only. Thanks.
Friday, March 9, 2012
Integrity Violation when syncing with SQL CE, but not MSDE
I'm getting the following error when I do a sync with SQL CE:
Error Code: 80004005 Message : Run
NativeErr.: 28557
Source : Microsoft SQL Server 2000 Windows CE Edition
Err. Par. 0: data source=\Program Files\ThinkShare\Fdm\FdmJournal_eli.sdf; -
Error Code: 80040E2F
Message : The row update or insert cannot be reapplied due to an integrity
violation. [,,,,,]
NativeErr.: 28549 Source : Microsoft SQL Server 2000 Windows CE
We use merge replication and have several join and select filters. What's
interesting is that MSDE will sync just fine using the same publication.
Is it possible to find out what the offending table is and which row(s) is
causing the problem?
Thanks,
Eli
you might look for data types that were automatically converted during the
merge. For instance any nchar types longer tahtn 255 are converted to ntext
(which can't be a key). ther are a few others that I can't remember. they're
listed in online manuals.
Any of the offending columns can be remedied by modifying the article
properties in the publication setup. There you can turn of indexing
.....integrity settings...etc.. for articles in a publication.
i ran into these type of issues a few times and they were very frustrating
to figure out. If the database structure is intact after the faile merge
perhaps you can look at the local sqlce database with the ce query analyzer.
"Eli Tucker" <eli-msdn@.mailinator.com> wrote in message
news:Oz2$3I$gEHA.3320@.TK2MSFTNGP11.phx.gbl...
> I'm getting the following error when I do a sync with SQL CE:
> Error Code: 80004005 Message : Run
> NativeErr.: 28557
> Source : Microsoft SQL Server 2000 Windows CE Edition
> Err. Par. 0: data source=\Program
Files\ThinkShare\Fdm\FdmJournal_eli.sdf; -
> Error Code: 80040E2F
> Message : The row update or insert cannot be reapplied due to an integrity
> violation. [,,,,,]
> NativeErr.: 28549 Source : Microsoft SQL Server 2000 Windows CE
> We use merge replication and have several join and select filters. What's
> interesting is that MSDE will sync just fine using the same publication.
> Is it possible to find out what the offending table is and which row(s) is
> causing the problem?
> Thanks,
> Eli
>
|||I do have several columns that are varchar(256) that get converted to ntext
when syncing with SQL CE, but as far as I can tell none of these columns are
indexed or are keys. In fact, the sync works fine with some instances of
data, but not with others. When you were having the problem, did it happen
the first time you attempted to sync?
Also, could you explain how to turn off indexing/integrity settings of a
publication in more detail? I couldn't quote follow what you wrote below.
Thanks again for your help,
Eli
"mgarner1980" <mgarner@.kbsi.com> wrote in message
news:u34W8jKhEHA.3916@.TK2MSFTNGP11.phx.gbl...
> you might look for data types that were automatically converted during the
> merge. For instance any nchar types longer tahtn 255 are converted to
ntext
> (which can't be a key). ther are a few others that I can't remember.
they're
> listed in online manuals.
> Any of the offending columns can be remedied by modifying the article
> properties in the publication setup. There you can turn of indexing
> ....integrity settings...etc.. for articles in a publication.
> i ran into these type of issues a few times and they were very frustrating
> to figure out. If the database structure is intact after the faile merge
> perhaps you can look at the local sqlce database with the ce query
analyzer.[vbcol=seagreen]
> "Eli Tucker" <eli-msdn@.mailinator.com> wrote in message
> news:Oz2$3I$gEHA.3320@.TK2MSFTNGP11.phx.gbl...
> Files\ThinkShare\Fdm\FdmJournal_eli.sdf; -
integrity[vbcol=seagreen]
What's[vbcol=seagreen]
is
>
Error Code: 80004005 Message : Run
NativeErr.: 28557
Source : Microsoft SQL Server 2000 Windows CE Edition
Err. Par. 0: data source=\Program Files\ThinkShare\Fdm\FdmJournal_eli.sdf; -
Error Code: 80040E2F
Message : The row update or insert cannot be reapplied due to an integrity
violation. [,,,,,]
NativeErr.: 28549 Source : Microsoft SQL Server 2000 Windows CE
We use merge replication and have several join and select filters. What's
interesting is that MSDE will sync just fine using the same publication.
Is it possible to find out what the offending table is and which row(s) is
causing the problem?
Thanks,
Eli
you might look for data types that were automatically converted during the
merge. For instance any nchar types longer tahtn 255 are converted to ntext
(which can't be a key). ther are a few others that I can't remember. they're
listed in online manuals.
Any of the offending columns can be remedied by modifying the article
properties in the publication setup. There you can turn of indexing
.....integrity settings...etc.. for articles in a publication.
i ran into these type of issues a few times and they were very frustrating
to figure out. If the database structure is intact after the faile merge
perhaps you can look at the local sqlce database with the ce query analyzer.
"Eli Tucker" <eli-msdn@.mailinator.com> wrote in message
news:Oz2$3I$gEHA.3320@.TK2MSFTNGP11.phx.gbl...
> I'm getting the following error when I do a sync with SQL CE:
> Error Code: 80004005 Message : Run
> NativeErr.: 28557
> Source : Microsoft SQL Server 2000 Windows CE Edition
> Err. Par. 0: data source=\Program
Files\ThinkShare\Fdm\FdmJournal_eli.sdf; -
> Error Code: 80040E2F
> Message : The row update or insert cannot be reapplied due to an integrity
> violation. [,,,,,]
> NativeErr.: 28549 Source : Microsoft SQL Server 2000 Windows CE
> We use merge replication and have several join and select filters. What's
> interesting is that MSDE will sync just fine using the same publication.
> Is it possible to find out what the offending table is and which row(s) is
> causing the problem?
> Thanks,
> Eli
>
|||I do have several columns that are varchar(256) that get converted to ntext
when syncing with SQL CE, but as far as I can tell none of these columns are
indexed or are keys. In fact, the sync works fine with some instances of
data, but not with others. When you were having the problem, did it happen
the first time you attempted to sync?
Also, could you explain how to turn off indexing/integrity settings of a
publication in more detail? I couldn't quote follow what you wrote below.
Thanks again for your help,
Eli
"mgarner1980" <mgarner@.kbsi.com> wrote in message
news:u34W8jKhEHA.3916@.TK2MSFTNGP11.phx.gbl...
> you might look for data types that were automatically converted during the
> merge. For instance any nchar types longer tahtn 255 are converted to
ntext
> (which can't be a key). ther are a few others that I can't remember.
they're
> listed in online manuals.
> Any of the offending columns can be remedied by modifying the article
> properties in the publication setup. There you can turn of indexing
> ....integrity settings...etc.. for articles in a publication.
> i ran into these type of issues a few times and they were very frustrating
> to figure out. If the database structure is intact after the faile merge
> perhaps you can look at the local sqlce database with the ce query
analyzer.[vbcol=seagreen]
> "Eli Tucker" <eli-msdn@.mailinator.com> wrote in message
> news:Oz2$3I$gEHA.3320@.TK2MSFTNGP11.phx.gbl...
> Files\ThinkShare\Fdm\FdmJournal_eli.sdf; -
integrity[vbcol=seagreen]
What's[vbcol=seagreen]
is
>
Sunday, February 19, 2012
Integrating MSDE 2000 with VB Applications
Hi,
I have VB 6.0 application using MSDE 2000.
I created setup file using Package & Deployment Wizard.
I have included "SQL Server Desktop Engine Merge Modules" and
"sqlredis.exe".
However, when I try to test it on another computer, I get following error.
DBNETLIB[ConnectionOpen(Connect()).] SQL Server does not exists or access is
denied.
clicking OK comes up with
Runtime error -2147467259 (80004005)
Automation Error
Unspecified error.
What am I missing?
Any Idea? Let me know if further info needed.
Shailesh
hi Shailesh,
Shailesh Patel wrote:
> Hi,
> I have VB 6.0 application using MSDE 2000.
> I created setup file using Package & Deployment Wizard.
> I have included "SQL Server Desktop Engine Merge Modules" and
> "sqlredis.exe".
> However, when I try to test it on another computer, I get following
> error. DBNETLIB[ConnectionOpen(Connect()).] SQL Server does not
> exists or access is denied.
> clicking OK comes up with
> Runtime error -2147467259 (80004005)
> Automation Error
> Unspecified error.
> What am I missing?
> Any Idea? Let me know if further info needed.
> Shailesh
please have a look at
http://support.microsoft.com/default...06&Product=sql
if helps
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
I have VB 6.0 application using MSDE 2000.
I created setup file using Package & Deployment Wizard.
I have included "SQL Server Desktop Engine Merge Modules" and
"sqlredis.exe".
However, when I try to test it on another computer, I get following error.
DBNETLIB[ConnectionOpen(Connect()).] SQL Server does not exists or access is
denied.
clicking OK comes up with
Runtime error -2147467259 (80004005)
Automation Error
Unspecified error.
What am I missing?
Any Idea? Let me know if further info needed.
Shailesh
hi Shailesh,
Shailesh Patel wrote:
> Hi,
> I have VB 6.0 application using MSDE 2000.
> I created setup file using Package & Deployment Wizard.
> I have included "SQL Server Desktop Engine Merge Modules" and
> "sqlredis.exe".
> However, when I try to test it on another computer, I get following
> error. DBNETLIB[ConnectionOpen(Connect()).] SQL Server does not
> exists or access is denied.
> clicking OK comes up with
> Runtime error -2147467259 (80004005)
> Automation Error
> Unspecified error.
> What am I missing?
> Any Idea? Let me know if further info needed.
> Shailesh
please have a look at
http://support.microsoft.com/default...06&Product=sql
if helps
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)