compare Data in 2 databases?

Hi All
I am relatively new to coding so please bare with me...
I have a number of SQL 2005 databases I access using an ODBC connection.
What I would like to do is create a code of some kind that will look at the
Client List in one db <<server1>> and compare them to like fields in another
<<server2>>. I would like this to then be a View that I can connect to with
Crystal and build a report around.
This is probably brain dead stuff to you but I am not finding what I need in
the NG's, but I am probably not calling it the correct term.
TIA
ApexSQL has a Diff product that can compare both data and structures. I
believe you can output the results of a compare for use elsewhere.
TheSQLGuru
President
Indicium Resources, Inc.
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
> Hi All
> I am relatively new to coding so please bare with me...
> I have a number of SQL 2005 databases I access using an ODBC connection.
> What I would like to do is create a code of some kind that will look at
> the
> Client List in one db <<server1>> and compare them to like fields in
> another
> <<server2>>. I would like this to then be a View that I can connect to
> with
> Crystal and build a report around.
> This is probably brain dead stuff to you but I am not finding what I need
> in
> the NG's, but I am probably not calling it the correct term.
> TIA
>
|||There is not statement that I can write that will do this? I am in a
non-profit and cannot buy all of these add-ins.
Thanks
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
> Hi All
> I am relatively new to coding so please bare with me...
> I have a number of SQL 2005 databases I access using an ODBC connection.
> What I would like to do is create a code of some kind that will look at
> the
> Client List in one db <<server1>> and compare them to like fields in
> another
> <<server2>>. I would like this to then be a View that I can connect to
> with
> Crystal and build a report around.
> This is probably brain dead stuff to you but I am not finding what I need
> in
> the NG's, but I am probably not calling it the correct term.
> TIA
>
|||John,
If your database is not too big, the free Lite Edition:
http://www.xsqlsoftware.com/LiteEdition.aspx
Advertised as free for SQLExpress:
http://www.teratrax.com/tdc/?gclid=CLGX5YD4-o0CFUtyOAodnRSlOw
Red Gate tools also come with a 14-day trial as do doubtless others.
RLF
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:368D850F-0CC0-4919-8D99-BE1936935556@.microsoft.com...
> There is not statement that I can write that will do this? I am in a
> non-profit and cannot buy all of these add-ins.
> Thanks
> "JOHN HARRIS" <harris1113@.fake.com> wrote in message
> news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
>

compare Data in 2 databases?

Hi All
I am relatively new to coding so please bare with me...
I have a number of SQL 2005 databases I access using an ODBC connection.
What I would like to do is create a code of some kind that will look at the
Client List in one db <<server1>> and compare them to like fields in another
<<server2>>. I would like this to then be a View that I can connect to with
Crystal and build a report around.
This is probably brain dead stuff to you but I am not finding what I need in
the NG's, but I am probably not calling it the correct term.
TIAApexSQL has a Diff product that can compare both data and structures. I
believe you can output the results of a compare for use elsewhere.
--
TheSQLGuru
President
Indicium Resources, Inc.
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
> Hi All
> I am relatively new to coding so please bare with me...
> I have a number of SQL 2005 databases I access using an ODBC connection.
> What I would like to do is create a code of some kind that will look at
> the
> Client List in one db <<server1>> and compare them to like fields in
> another
> <<server2>>. I would like this to then be a View that I can connect to
> with
> Crystal and build a report around.
> This is probably brain dead stuff to you but I am not finding what I need
> in
> the NG's, but I am probably not calling it the correct term.
> TIA
>|||There is not statement that I can write that will do this? I am in a
non-profit and cannot buy all of these add-ins.
Thanks
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
> Hi All
> I am relatively new to coding so please bare with me...
> I have a number of SQL 2005 databases I access using an ODBC connection.
> What I would like to do is create a code of some kind that will look at
> the
> Client List in one db <<server1>> and compare them to like fields in
> another
> <<server2>>. I would like this to then be a View that I can connect to
> with
> Crystal and build a report around.
> This is probably brain dead stuff to you but I am not finding what I need
> in
> the NG's, but I am probably not calling it the correct term.
> TIA
>|||John,
If your database is not too big, the free Lite Edition:
http://www.xsqlsoftware.com/LiteEdition.aspx
Advertised as free for SQLExpress:
http://www.teratrax.com/tdc/?gclid=CLGX5YD4-o0CFUtyOAodnRSlOw
Red Gate tools also come with a 14-day trial as do doubtless others.
RLF
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:368D850F-0CC0-4919-8D99-BE1936935556@.microsoft.com...
> There is not statement that I can write that will do this? I am in a
> non-profit and cannot buy all of these add-ins.
> Thanks
> "JOHN HARRIS" <harris1113@.fake.com> wrote in message
> news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
>> Hi All
>> I am relatively new to coding so please bare with me...
>> I have a number of SQL 2005 databases I access using an ODBC connection.
>> What I would like to do is create a code of some kind that will look at
>> the
>> Client List in one db <<server1>> and compare them to like fields in
>> another
>> <<server2>>. I would like this to then be a View that I can connect to
>> with
>> Crystal and build a report around.
>> This is probably brain dead stuff to you but I am not finding what I need
>> in
>> the NG's, but I am probably not calling it the correct term.
>> TIA
>

compare Data in 2 databases?

Hi All
I am relatively new to coding so please bare with me...
I have a number of SQL 2005 databases I access using an ODBC connection.
What I would like to do is create a code of some kind that will look at the
Client List in one db <<server1>> and compare them to like fields in another
<<server2>>. I would like this to then be a View that I can connect to with
Crystal and build a report around.
This is probably brain dead stuff to you but I am not finding what I need in
the NG's, but I am probably not calling it the correct term.
TIAApexSQL has a Diff product that can compare both data and structures. I
believe you can output the results of a compare for use elsewhere.
TheSQLGuru
President
Indicium Resources, Inc.
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
> Hi All
> I am relatively new to coding so please bare with me...
> I have a number of SQL 2005 databases I access using an ODBC connection.
> What I would like to do is create a code of some kind that will look at
> the
> Client List in one db <<server1>> and compare them to like fields in
> another
> <<server2>>. I would like this to then be a View that I can connect to
> with
> Crystal and build a report around.
> This is probably brain dead stuff to you but I am not finding what I need
> in
> the NG's, but I am probably not calling it the correct term.
> TIA
>|||There is not statement that I can write that will do this? I am in a
non-profit and cannot buy all of these add-ins.
Thanks
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
> Hi All
> I am relatively new to coding so please bare with me...
> I have a number of SQL 2005 databases I access using an ODBC connection.
> What I would like to do is create a code of some kind that will look at
> the
> Client List in one db <<server1>> and compare them to like fields in
> another
> <<server2>>. I would like this to then be a View that I can connect to
> with
> Crystal and build a report around.
> This is probably brain dead stuff to you but I am not finding what I need
> in
> the NG's, but I am probably not calling it the correct term.
> TIA
>|||John,
If your database is not too big, the free Lite Edition:
http://www.xsqlsoftware.com/LiteEdition.aspx
Advertised as free for SQLExpress:
http://www.teratrax.com/tdc/?gclid=...CFUtyOAodnRSlOw
Red Gate tools also come with a 14-day trial as do doubtless others.
RLF
"JOHN HARRIS" <harris1113@.fake.com> wrote in message
news:368D850F-0CC0-4919-8D99-BE1936935556@.microsoft.com...
> There is not statement that I can write that will do this? I am in a
> non-profit and cannot buy all of these add-ins.
> Thanks
> "JOHN HARRIS" <harris1113@.fake.com> wrote in message
> news:0E38DB96-8599-4021-A7BA-7C325B273F2A@.microsoft.com...
>

Communication Link Failure C++ & SQL Server

Hi Guys,

I am using C++ (Ver 6) that connects to a SQL Server 7 DB using ODBC drivers. The apps connects to the database in the start and listens to the users requests and replies with the required data.

The apps is working fine, but once in a while it looses connection and gives "Communication link failure" message.

I just restart the apps and it is able to reconnect and perform as normal without any problems.

I am not able to find the reason as this behaviour as its very much unpredictable!

The error is returned by SQLExecDirect() function.

The question is, since I still have the Connection Handle, is it possible to just reconnect to the database re-using the same handle ? or do I have any other choices ?

Thanks in advance.
Faisal.This is the wrong forum to ask this question. Try one of the SQL forums.|||You might get this error when the server gets restarted. I look for error 0x80004005 and reconnect to the server, it has worked well.

I'll move this thread to the SQL forum for a better answer.
|||

Hi Brian,

I think my question was confusing. I actually meant, how to re-connect to the DB using the same Connection Handle ? I am new to C/C++

Thanks.|||

Thanks for the help. As I mentioned above, I am new to C/C++ and dont know how to reuse the same connection handle. So that I dont need to re instantiate all the other classes that are using a reference to that connection handle

Hope you can help me out here.

Communication Link failure

Hello,
Sometimes my application accessing SQL Server via ODBC is giving an error message "Communication link failure".
The network and server looks fine, but I'am still getting it time to time.
Please recommend possible reasons and solutions.
Thanks indvance.We has some unnoticed unstable connections very difficult to find because NT retried to connect without warning (maybe just some lattency when you tried to access again a lan resource).
We checked with "ping -w5000 -t"
The problem was bad coupling male/female RJ45 connectors in some stations.

Hope this helps,
Csar.

Communication Link Failure

Dear experts~
My client workstation recently receives "ODBC failed -
Connection bluh bluh bluh... SQL Server: Communication
Link Failure" error message while trying to insert/update
a record. This happens on two workstations. This problem
would soon go away in few seconds and come back few hours
latter. What's interesting is when users reported
Communication Link Failure, I am still able to connect to
the SQL Server through other workstations.
I checked my Network Config. Both TCP and Name Pipes are
enabled. My server runs well for a longest time and I
haven't make any changes on Configs recently. I'd like to
know what would cause this problem occurs and Could this
be a result of Bad Network Connection rather than SQL
Server Config. Or, What I can do on SQL Server to get
rid of this problem.
I am running SQL Server 2000 SP2. The client workstion
uses MS Access .mdb file with linked table to connect to
SQL Server 2000.
Thank you soooooo much for your help~~~
Annie
.Annie,
More than likely you have a network error. I say this because the error is confined to 2 workstations and you are able to access the server from your workstation. A couple of things to try:
you can do a simple test of the network connection by using the ping command. Use the -n parameter to send a large number of echo requests. Pay attention to the statistics on lost packets and round-trip time.
If packets are being lost or the returns times are higher check the event logs on the workstations with the problems for network related software or hardware problems.
Make sure you are not having any DNS problems. Check if you can consistently link to the server by specifying the server ip address in the ODBC Datasource defintion
My experience with Named Pipes is that it can be slow on a tcp/ip network. I would configure the ODBC Datasource defintions to use only tcp/ip.
Good Luck
Lewis DiFelice
DBA
-- piyomeme@.yahoo.com wrote: --
Dear experts~
My client workstation recently receives "ODBC failed -
Connection bluh bluh bluh... SQL Server: Communication
Link Failure" error message while trying to insert/update
a record. This happens on two workstations. This problem
would soon go away in few seconds and come back few hours
latter. What's interesting is when users reported
Communication Link Failure, I am still able to connect to
the SQL Server through other workstations.
I checked my Network Config. Both TCP and Name Pipes are
enabled. My server runs well for a longest time and I
haven't make any changes on Configs recently. I'd like to
know what would cause this problem occurs and Could this
be a result of Bad Network Connection rather than SQL
Server Config. Or, What I can do on SQL Server to get
rid of this problem.
I am running SQL Server 2000 SP2. The client workstion
uses MS Access .mdb file with linked table to connect to
SQL Server 2000.
Thank you soooooo much for your help~~~
Annie
..

Communication link failure

Hello
We are using Access 2003 (SP2) to access a remote SQL 2000 database,
using ODBC with MDAC 2.8
This is an intermittent problem and it occurs on all the clients
(mostly winXP Pro)
The problem is that from time to time, the ODBC connection fails and we
get one of several errors:
ODBC--call failed
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (se
nd()).
(#10054) [Microsoft][ODBC SQL Server Driver][DBNETLIB].General n
etwork
error. Check your network documentation.
or
ODBC--call failed
[Microsoft][ODBC SQL Server Driver][Communications link failure
(0#)
We know that sometimes there are network problems (we connect accross a
CDMA mobile network) - the cause of this is not in question.....
Retrying the operation immediatly returns the same error but when we
close and re-open access and re-run the operation, and then it will
work straight away.
So, it seems that the driver enters a "failure state" - which is reset
when access is closed and re-opened.
I desperately need to find a way to "reset' the driver when this
happens so that we don't have to keep restarting access.
Anyway help would be much appreciated.
thanks !
RobHow you address it depends partly on how you are access the
SQL 2000 database, what this operation does that you are
retrying.
Just a guess but if this is linked tables, then you should
create some VBA function in Access to relink (not refresh)
the tables in code. Then you can try executing this function
instead.
-Sue
On 16 May 2006 03:17:49 -0700, saikosounds@.gmail.com wrote:

>Hello
>We are using Access 2003 (SP2) to access a remote SQL 2000 database,
>using ODBC with MDAC 2.8
>This is an intermittent problem and it occurs on all the clients
>(mostly winXP Pro)
>The problem is that from time to time, the ODBC connection fails and we
>get one of several errors:
>ODBC--call failed
>[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (s
end()).
>(#10054) [Microsoft][ODBC SQL Server Driver][DBNETLIB].General
network
>error. Check your network documentation.
>or
>ODBC--call failed
>[Microsoft][ODBC SQL Server Driver][Communications link failure
(0#)
>We know that sometimes there are network problems (we connect accross a
>CDMA mobile network) - the cause of this is not in question.....
>Retrying the operation immediatly returns the same error but when we
>close and re-open access and re-run the operation, and then it will
>work straight away.
>So, it seems that the driver enters a "failure state" - which is reset
>when access is closed and re-opened.
>I desperately need to find a way to "reset' the driver when this
>happens so that we don't have to keep restarting access.
>Anyway help would be much appreciated.
>thanks !
>Rob|||Yes, the tables are linked, but there are lots and lots of tables !
Relinking then through code takes longer than re-starting Access ! !|||Then try a refresh instead - I'm not sure if a restart does
this or not. The issue is more of one related to Access
linked tables so you may want to post this in an Access
newsgroup.
-Sue
On 16 May 2006 17:08:29 -0700, saikosounds@.gmail.com wrote:

>Yes, the tables are linked, but there are lots and lots of tables !
>Relinking then through code takes longer than re-starting Access ! !|||You either need to fix the network connection, relink the tables, or automat
e
a restart. In Access, you can actually reopen the database through VBA, if
I
remember correctly.
--
MeanOldDBA
derrickleggett@.hotmail.com
http://weblogs.sqlteam.com/derrickl
When life gives you a lemon, fire the DBA.
"Sue Hoegemeier" wrote:

> Then try a refresh instead - I'm not sure if a restart does
> this or not. The issue is more of one related to Access
> linked tables so you may want to post this in an Access
> newsgroup.
> -Sue
> On 16 May 2006 17:08:29 -0700, saikosounds@.gmail.com wrote:
>
>