Showing posts with label delete. Show all posts
Showing posts with label delete. Show all posts

Tuesday, March 27, 2012

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

Tuesday, March 20, 2012

Copying MSDE database to disk - how?

I have my little MSDE on my computer. I can add and delete stuff from it through Web Matrix. My question is, where exactly is the database stored in Windows?? Also, say I wanted to copy it to a disk so I could show it to someone else, what file(s) would I need to copy?

The reason why I ask is because I have been doing a website as a project and we have to hand in all files on a disk. Getting all the .aspx & .ascx and the .config file is easy, but the database & stored procedures is proving tricky to find.

ThanksTry using this tool - http://www.webattack.com/get/dbamgr2.html its a MSDE Manager. Install it then connect to your server. right click the database you want to backup then select 'Backup Database' and bobs your uncle:)|||Actually you shold use that tool, right click your DB then click 'Generate SQL Script'. This will be easier to install on a remote server

Friday, February 24, 2012

Copy, Delete Files, and Transfer via DTS

Hi,
I need to transfer files from another server to my database server (SQL
Server 7).
The job details is:
1. copy the files to backup folder ( d:\ftp\backup_data\ ), the backup
filename added with currentdate and time. I use xp_cmdshell.
2. load the file content to database. I use DTS from text file.
3. delete the source file. (xp_cmdshell).
The problem is xp_cmdshell is denied for accessing a mapping path, so copy
and deletion process will not run. I've try both sql server administrator
level or NT 4 administrator level login, but it still did'nt work.
Is there's anyway to do this?
Thanks in advance
TeguhThe access rights you will need to move, copy are not
yours, instead its the service account of you sql server.
Give the directory that rather than your own user id, and
that should do it.
Peter
"Do not awake the sleeping dragon for you are crunchy and
taste good with ketchup".
>--Original Message--
>Hi,
>I need to transfer files from another server to my
database server (SQL
>Server 7).
>The job details is:
>1. copy the files to backup folder (
d:\ftp\backup_data\ ), the backup
>filename added with currentdate and time. I use
xp_cmdshell.
>2. load the file content to database. I use DTS from text
file.
>3. delete the source file. (xp_cmdshell).
>The problem is xp_cmdshell is denied for accessing a
mapping path, so copy
>and deletion process will not run. I've try both sql
server administrator
>level or NT 4 administrator level login, but it still
did'nt work.
>Is there's anyway to do this?
>Thanks in advance
>Teguh
>
>.
>