birding-aus

Help with SQL

To: "'John Murray Penhallurick'" <>
Subject: Help with SQL
From: "Paul Dodd" <>
Date: Tue, 26 Feb 2008 23:55:17 +1100
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: 
=============================
<Prev in Thread] Current Thread [Next in Thread>
  • Help with SQL, John Murray Penhallurick
    • Help with SQL, Paul Dodd <=
Admin

The University of NSW School of Computer and Engineering takes no responsibility for the contents of this archive. It is purely a compilation of material sent by many people to the birding-aus mailing list. It has not been checked for accuracy nor its content verified in any way. If you wish to get material removed from the archive or have other queries about the archive e-mail Andrew Taylor at this address: andrewt@cse.unsw.EDU.AU