Hi John,
Can you tell me if the error message says, "Not enough storage is available
TO COMPLETE THIS COMMAND" or "Not enough storage is available TO PROCESS
THIS OPERATION" - both error messages are possible and they mean different
things. Can you also tell me precisely what you were doing at the time of
the error? It's actually not possible to "open" an MDF - you have to
"attach" the MDF in order to have access to the database.
I'm sure I can point you in the right direction, but you'll need to be very
precise about the operations you were performing. Also, can you please tell
me the version of SQL that (i) your ISP has installed on the server; and
(ii) that you are running on your local machine?
I can tell you how to import a FoxPro database, using Microsoft DTS (a
component of SQL Server), but I'd need a little more information.
I suggest going off-list otherwise we'll annoy people that have no interest
in the technical stuff.
Thanks and all the best,
Paul Dodd
Docklands, Melbourne
-----Original Message-----
From:
On Behalf Of John Murray
Penhallurick
Sent: Tuesday, 26 February 2008 10:45 PM
To: 'Birding Aus'
Subject: Help with SQL
Dear Friends,
This is a plea to anyone, particularly in Canberra, who is familiar with
using SQL, and in particular, anyone who uses my web site:
http://worldbirdinfo.net <http://worldbirdinfo.net/>
Originally, this website used an Access database. This was ideal for me as
I could convert my Foxpro database to Access, winzip it, FTP it to the
website, and unzip there. Unfortunately, there was already so much data on
the website that it kep crashing the server. So my web programmer switched
to Microsoft SQL, and designed a web interface to allow me to upload data.
Unfortunately, I find this web interface far too slow. At times, it can
take up to 15 seconds to upload a single synonym, and I spend more time
waiting for things to upload than entering data. My programmer has done a
bunk, attracted by the big money available on Australian Idol, and left me
standing.
I had my ISP provider copy the SQL database from the website and send it to
me. My idea was that it would be quicker to enter data into SQL on my own
computer, and then send the ISP a disk every month to upload into the
website. I believe that for security reasons, it is not possible to FTP an
sSQL database. I have downloaded SQL Server etc from the Microsoft database
and tried to open the database.But when I try to open the mdf I get an error
message ?Not enough storage is available?? Can ayone tell me what this means
and what I can do about it? Also can anyone tell me how to import a Foxpro
database into SQL?
Thanks,
John Penhallurick
86 Bingley Crescent
FRASER, A.C.T. 2615
AUSTRALIA
S 35° 11' 40.2"
E 149° 03' 26.2"
Home Telephone: (61 2) 6258 5428
Mobile 0408 585428
Please visit my website http://worldbirdinfo.net
John Penhallurick
86 Bingley Crescent
FRASER, A.C.T. 2615
AUSTRALIA
S 35° 11' 40.2"
E 149° 03' 26.2"
Home Telephone: (61 2) 6258 5428
Mobile 0408 585428
Please visit my website http://worldbirdinfo.net
==========www.birding-aus.org
birding-aus.blogspot.com
To unsubscribe from this mailing list,
send the message:
unsubscribe
(in the body of the message, with no Subject line)
to:
===========
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.1/1298 - Release Date: 25/02/2008
8:45 PM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.21.1/1298 - Release Date: 25/02/2008
8:45 PM
==============================www.birding-aus.org
birding-aus.blogspot.com
To unsubscribe from this mailing list,
send the message:
unsubscribe
(in the body of the message, with no Subject line)
to:
=============================
|
