Corel WordPerfect removed odbc -- How can I fix this?

I did the same thing as this poor soul -- I thought I could delete
WordPerfect TryBeforeYouBuy -- and now I cannot connect to my local
instance of SqlServer, nor my remote host.
Can anyone help?
This almost seems like it's worth a lawsuit.
http://groups.google.com/groups?q=wordperfect+group:microsoft.public.sqlserver.*+group:microsoft.public.sqlserver.*+group:microsoft.public.sqlserver.*&hl=en&lr=&ie=UTF-8&oe=UTF-8&group=microsoft.public.sqlserver.*&selm=KoM_8.601693%24352.124358%40sccrnsc02&rnum=2If you use odbc, just register a new (System/User) DSN in your DBC
Adminstrator.
Therefore go under the managment of your PC --> ODBC-Administrator Register
a new DSN with all connection details for your server.
If ODBC Administrator is not available in the menu, go ahead with STart -->
RUN --> ODBCAD32.exe
HTH, Jens Süßmeyer.
"jim corey" <jhcorey@.yahoo.com> schrieb im Newsbeitrag
news:1c4f8dcf.0309070519.63c55ef8@.posting.google.com...
> I did the same thing as this poor soul -- I thought I could delete
> WordPerfect TryBeforeYouBuy -- and now I cannot connect to my local
> instance of SqlServer, nor my remote host.
> Can anyone help?
> This almost seems like it's worth a lawsuit.
>
>
http://groups.google.com/groups?q=wordperfect+group:microsoft.public.sqlserv
er.*+group:microsoft.public.sqlserver.*+group:microsoft.public.sqlserver.*&h
l=en&lr=&ie=UTF-8&oe=UTF-8&group=microsoft.public.sqlserver.*&selm=KoM_8.601
693%24352.124358%40sccrnsc02&rnum=2|||It's worse than that. If I try to do this there are no drivers shown, so
I can't enter a new profile.
I believe the original poster had the same problem.
"Jens Süßmeyer" <jsuessmeyer@.[REJECT_SPAM]web.de> wrote in message news:<e6vrHkUdDHA.2112@.TK2MSFTNGP10.phx.gbl>...
> If you use odbc, just register a new (System/User) DSN in your DBC
> Adminstrator.
> Therefore go under the managment of your PC --> ODBC-Administrator Register
> a new DSN with all connection details for your server.
> If ODBC Administrator is not available in the menu, go ahead with STart -->
> RUN --> ODBCAD32.exe
> HTH, Jens Süßmeyer.
>
> "jim corey" <jhcorey@.yahoo.com> schrieb im Newsbeitrag
> news:1c4f8dcf.0309070519.63c55ef8@.posting.google.com...
> > I did the same thing as this poor soul -- I thought I could delete
> > WordPerfect TryBeforeYouBuy -- and now I cannot connect to my local
> > instance of SqlServer, nor my remote host.
> >
> > Can anyone help?
> >
> > This almost seems like it's worth a lawsuit.
> >
> >
> >
> http://groups.google.com/groups?q=wordperfect+group:microsoft.public.sqlserv
> er.*+group:microsoft.public.sqlserver.*+group:microsoft.public.sqlserver.*&h
> l=en&lr=&ie=UTF-8&oe=UTF-8&group=microsoft.public.sqlserver.*&selm=KoM_8.601
> 693%24352.124358%40sccrnsc02&rnum=2|||As was suggested before try to re-install MDAC... THe directions can be
found at
http://support.microsoft.com/default.aspx?scid=kb;en-us;232060
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"jim corey" <jhcorey@.yahoo.com> wrote in message
news:1c4f8dcf.0309070519.63c55ef8@.posting.google.com...
> I did the same thing as this poor soul -- I thought I could delete
> WordPerfect TryBeforeYouBuy -- and now I cannot connect to my local
> instance of SqlServer, nor my remote host.
> Can anyone help?
> This almost seems like it's worth a lawsuit.
>
>
http://groups.google.com/groups?q=wordperfect+group:microsoft.public.sqlserver.*+group:microsoft.public.sqlserver.*+group:microsoft.public.sqlserver.*&h
l=en&lr=&ie=UTF-8&oe=UTF-8&group=microsoft.public.sqlserver.*&selm=KoM_8.601
693%24352.124358%40sccrnsc02&rnum=2

copying tables from one server to another

This is a little complicated, so let me explain what I'm after.
My client runs my app against sql server 2000. I can connect via vpn and
tcp/ip. However, I may need to test from time to time against the current
data. I maintain a copy of the database on my system, but the tables are,
by definition, not up to date. I could of course transfer the database to
my server, but this is practically impossible, as the database is over 3
gigs and via tcp/ip it will take 15 hours.
Is there a way that I can copy individual tables to my server, replacing my
old tables, so I can run tests against current data without having to do so
on the active sql server at my client's location?
Thanks for any help.
Bernie YaegerHi,
You could use either one:-
1. BCP OUT the data, copy the file to destination and in destination use
BCP IN to load it into table
2. USE DTS - Export and Import wizard.
I recommend you to
a. BCP OUT the table data from source server
b. copy the file to your test machine
c. BCP IN the data into your machine
Thanks
Hari
MCDBA
"Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
news:V_QNc.9183$09.1208788@.news4.srv.hcvlny.cv.net...
> This is a little complicated, so let me explain what I'm after.
> My client runs my app against sql server 2000. I can connect via vpn and
> tcp/ip. However, I may need to test from time to time against the current
> data. I maintain a copy of the database on my system, but the tables are,
> by definition, not up to date. I could of course transfer the database to
> my server, but this is practically impossible, as the database is over 3
> gigs and via tcp/ip it will take 15 hours.
> Is there a way that I can copy individual tables to my server, replacing
my
> old tables, so I can run tests against current data without having to do
so
> on the active sql server at my client's location?
> Thanks for any help.
> Bernie Yaeger
>|||Hi Hari,
Tx for your reply. I did try to work with dts, but I got a bit bogged
down - I think I need to understand its features a bit better. But BCP -
good idea! I'll try it.
Thanks,
Bernie
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uynQ5bMdEHA.2408@.tk2msftngp13.phx.gbl...
> Hi,
> You could use either one:-
> 1. BCP OUT the data, copy the file to destination and in destination use
> BCP IN to load it into table
> 2. USE DTS - Export and Import wizard.
> I recommend you to
> a. BCP OUT the table data from source server
> b. copy the file to your test machine
> c. BCP IN the data into your machine
>
> Thanks
> Hari
> MCDBA
> "Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
> news:V_QNc.9183$09.1208788@.news4.srv.hcvlny.cv.net...
> > This is a little complicated, so let me explain what I'm after.
> >
> > My client runs my app against sql server 2000. I can connect via vpn
and
> > tcp/ip. However, I may need to test from time to time against the
current
> > data. I maintain a copy of the database on my system, but the tables
are,
> > by definition, not up to date. I could of course transfer the database
to
> > my server, but this is practically impossible, as the database is over 3
> > gigs and via tcp/ip it will take 15 hours.
> >
> > Is there a way that I can copy individual tables to my server, replacing
> my
> > old tables, so I can run tests against current data without having to do
> so
> > on the active sql server at my client's location?
> >
> > Thanks for any help.
> >
> > Bernie Yaeger
> >
> >
>

copying tables from one server to another

This is a little complicated, so let me explain what I'm after.
My client runs my app against sql server 2000. I can connect via vpn and
tcp/ip. However, I may need to test from time to time against the current
data. I maintain a copy of the database on my system, but the tables are,
by definition, not up to date. I could of course transfer the database to
my server, but this is practically impossible, as the database is over 3
gigs and via tcp/ip it will take 15 hours.
Is there a way that I can copy individual tables to my server, replacing my
old tables, so I can run tests against current data without having to do so
on the active sql server at my client's location?
Thanks for any help.
Bernie YaegerHi,
You could use either one:-
1. BCP OUT the data, copy the file to destination and in destination use
BCP IN to load it into table
2. USE DTS - Export and Import wizard.
I recommend you to
a. BCP OUT the table data from source server
b. copy the file to your test machine
c. BCP IN the data into your machine
Thanks
Hari
MCDBA
"Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
news:V_QNc.9183$09.1208788@.news4.srv.hcvlny.cv.net...
> This is a little complicated, so let me explain what I'm after.
> My client runs my app against sql server 2000. I can connect via vpn and
> tcp/ip. However, I may need to test from time to time against the current
> data. I maintain a copy of the database on my system, but the tables are,
> by definition, not up to date. I could of course transfer the database to
> my server, but this is practically impossible, as the database is over 3
> gigs and via tcp/ip it will take 15 hours.
> Is there a way that I can copy individual tables to my server, replacing
my
> old tables, so I can run tests against current data without having to do
so
> on the active sql server at my client's location?
> Thanks for any help.
> Bernie Yaeger
>|||Hi Hari,
Tx for your reply. I did try to work with dts, but I got a bit bogged
down - I think I need to understand its features a bit better. But BCP -
good idea! I'll try it.
Thanks,
Bernie
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uynQ5bMdEHA.2408@.tk2msftngp13.phx.gbl...
> Hi,
> You could use either one:-
> 1. BCP OUT the data, copy the file to destination and in destination use
> BCP IN to load it into table
> 2. USE DTS - Export and Import wizard.
> I recommend you to
> a. BCP OUT the table data from source server
> b. copy the file to your test machine
> c. BCP IN the data into your machine
>
> Thanks
> Hari
> MCDBA
> "Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
> news:V_QNc.9183$09.1208788@.news4.srv.hcvlny.cv.net...
and[vbcol=seagreen]
current[vbcol=seagreen]
are,[vbcol=seagreen]
to[vbcol=seagreen]
> my
> so
>

copying tables from one server to another

This is a little complicated, so let me explain what I'm after.
My client runs my app against sql server 2000. I can connect via vpn and
tcp/ip. However, I may need to test from time to time against the current
data. I maintain a copy of the database on my system, but the tables are,
by definition, not up to date. I could of course transfer the database to
my server, but this is practically impossible, as the database is over 3
gigs and via tcp/ip it will take 15 hours.
Is there a way that I can copy individual tables to my server, replacing my
old tables, so I can run tests against current data without having to do so
on the active sql server at my client's location?
Thanks for any help.
Bernie Yaeger
Hi,
You could use either one:-
1. BCP OUT the data, copy the file to destination and in destination use
BCP IN to load it into table
2. USE DTS - Export and Import wizard.
I recommend you to
a. BCP OUT the table data from source server
b. copy the file to your test machine
c. BCP IN the data into your machine
Thanks
Hari
MCDBA
"Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
news:V_QNc.9183$09.1208788@.news4.srv.hcvlny.cv.net ...
> This is a little complicated, so let me explain what I'm after.
> My client runs my app against sql server 2000. I can connect via vpn and
> tcp/ip. However, I may need to test from time to time against the current
> data. I maintain a copy of the database on my system, but the tables are,
> by definition, not up to date. I could of course transfer the database to
> my server, but this is practically impossible, as the database is over 3
> gigs and via tcp/ip it will take 15 hours.
> Is there a way that I can copy individual tables to my server, replacing
my
> old tables, so I can run tests against current data without having to do
so
> on the active sql server at my client's location?
> Thanks for any help.
> Bernie Yaeger
>
|||Hi Hari,
Tx for your reply. I did try to work with dts, but I got a bit bogged
down - I think I need to understand its features a bit better. But BCP -
good idea! I'll try it.
Thanks,
Bernie
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uynQ5bMdEHA.2408@.tk2msftngp13.phx.gbl...[vbcol=seagreen]
> Hi,
> You could use either one:-
> 1. BCP OUT the data, copy the file to destination and in destination use
> BCP IN to load it into table
> 2. USE DTS - Export and Import wizard.
> I recommend you to
> a. BCP OUT the table data from source server
> b. copy the file to your test machine
> c. BCP IN the data into your machine
>
> Thanks
> Hari
> MCDBA
> "Bernie Yaeger" <berniey@.cherwellinc.com> wrote in message
> news:V_QNc.9183$09.1208788@.news4.srv.hcvlny.cv.net ...
and[vbcol=seagreen]
current[vbcol=seagreen]
are,[vbcol=seagreen]
to
> my
> so
>

Copying Database table to another Database

I am using Visual Studio 2005 to connect to a database on a remote SQL2000 server. I need to copy a table in a database on my local machine up to the server. How can I do that?

Thank you,

Do you have enterprise manager or sql management studio?

If so do use the Import/Export wizard to copy the table from A to B.

|||

no - I have Access 2007 and it is nothing like Access 2000 which made this act easy

|||

Part of my problem is that I am using Vista and it is giving me fits.

|||

This is "long ago at school" kind of knowledge for me. But can't u connect the sql server to your access database and copy the data across from within access?

|||

Finally got it - the adp setup in Access 2007 is completely different but you are correct it does work and actually quite well - now that I learned how to use it. The brain always stops with learning incomplete.

THank you

Copy/Move database

I am trying to move a database from a dev machine to my server. I've tried the copy wizard but get an error saying the I cannot connect to the server after selecting it from the dropdown list in the wizard.
I have also tried doing a backup and restore, but run into the problem created by wanting to change the name of the db, if possible.
I am using Windows Auth and have access to the server.
Any suggestions would be greatly appreciated.

Thank you for your help.Hi,

- Create a backup of the database at your dev machine.

- Create a new database with the new name at the server and set the database and the log-file location to the desired path. Record the location of the datafile and the transaction log.

- Copy the backup-file to the new server in a temp-path.

- From the new database select the backup-file to restore and set the following options BEFORE you start the restore: Change the locations to the recorded values. Check Force restore over existing database.

- Start restore

Your database will now be restored at the new server.

Succes.

Copy table to Remote SQL server using DTS

Hi,
I need to copy some tables from my local MsSQL(2000) database to remote MSSQL server.I think I should use DTS for this purpose.
I can Connect to remote server and I cam copy the tables to it.but the problem is getting here Once I copied it Local Table Constraints not applying to the Remote Host SQL Tables. May be I am doing wrong here.
How to transfer my Table(s) with the same structure as my local host sql table(s).

Thanks!If you are copying on a table by table basis, you constraints do not get copied; the server has no way of knowing if the tables referenced by the constraints are the same tables in the destination DB...The table which is referenced by constraints may not even exits!
The only way to preserve all of that information is to backup the database, and restore it on your target machine.|||

Quote:

Originally Posted by Motoma

If you are copying on a table by table basis, you constraints do not get copied; the server has no way of knowing if the tables referenced by the constraints are the same tables in the destination DB...The table which is referenced by constraints may not even exits!
The only way to preserve all of that information is to backup the database, and restore it on your target machine.

Thanks Motoma,
Its correct, but I don't have the access to the Logical drives of the remote server. Its acctully a Hosting package.

I tried this
http://www.intermedia.net/support/k...ult.asp?id=1176

But failed with the Last step with this error.

Failed to copy objects to mssql server to mssql server.|||

Quote:

Originally Posted by ajaxrand

Hi,
I need to copy some tables from my local MsSQL(2000) database to remote MSSQL server.I think I should use DTS for this purpose.
I can Connect to remote server and I cam copy the tables to it.but the problem is getting here Once I copied it Local Table Constraints not applying to the Remote Host SQL Tables. May be I am doing wrong here.
How to transfer my Table(s) with the same structure as my local host sql table(s).

Thanks!

if you do not want to programm in DTS ,then you can use enterprise manager of sql server with the following steps :
1-you should register your remote server in enterprise manager
2-you should register local server and attach the local database in the local server

3-if you have not any database on your remote server.you or your host administrator must create a database for your use.also you must have a user for accessing this database.

4-right click on your local database and click 'Export Data' in 'All Tasks' sub menu .then carry on with the wizard.

5-when wizard asks you the destinition database,introduce your database in your remote server.

6-in this method you replicate your database completly to your remote database server.i think you will not have such a problem for constraints.because you have a copy of data and metadata on your remote server.|||

Quote:

Originally Posted by hoomaniraji

if you do not want to programm in DTS ,then you can use enterprise manager of sql server with the following steps :
1-you should register your remote server in enterprise manager
2-you should register local server and attach the local database in the local server

3-if you have not any database on your remote server.you or your host administrator must create a database for your use.also you must have a user for accessing this database.

4-right click on your local database and click 'Export Data' in 'All Tasks' sub menu .then carry on with the wizard.

5-when wizard asks you the destinition database,introduce your database in your remote server.

6-in this method you replicate your database completly to your remote database server.i think you will not have such a problem for constraints.because you have a copy of data and metadata on your remote server.

The wizard is same as DTS import/export data that I tried already.

If you can remember these steps:

1.Select Local host database.
2. Select remote host database (alread created on the hosting packaged)

On this prompt you will ask to select on of the option.
with 1st option constraints are not copying.(there might be other stuffs also that not appliying to the remote server after exporting)



Once I tried the last option, it will display this.



I tried with deselecting the Options >>> Security option and didnt change the table options, but its giving the same error.

thanks!|||Heya Guys,

It was a permission problem. when creating the user account for me on the SQL server, they've forgotten to assign the dbo. permission on it.The steps that I used, absolutely correct. That stupid error message which came earlier, doesn't tell anything about permissions issues. If so we could figured it out easily.
anyway, Thanks for coming here.