[Previous entry: "mother nature - a great leveller!"] [Next entry: "The food chain link to ill health is not in your "5 a day""]
07/10/2009: "microsoft - geeks who dont know what they are doing."
its a simple process, set up a database with my host, download microsft server sql 2008, download a csv or xml file, import it to database.
then set up pages using php to call items from said database.... how hard can it be!
with microsoft - damn near impossible!
my server recommends using server sql 2000 to update and upload a database which is nothing more than a basic spreadsheet containing data in rows and columns.
the link to sql 2000 is no longer valid, as microsoft no longer support it.
microsoft recommend using their sql 2005...... the problem is when you try to import this "table" or csv file into your database, constant errors are occurring, and microsoft dont have a clue how to resolve them!
i attempt to upload a csv file and continuously get errors that cause the upload (or import) to fail.
i look at the error message, rectify the problem, sometimes delete the offending column altogether, only to find i have another error when i try again to import the csv file.
its a complete waste of space, unfortunately, my server company will not allow connection via any other program. ive tried to explain to them that if im unable to upload data to a database, then its a complete waste of time paying for server space with a database on it....
first they asked me what i was trying to do - after explaining in a direct question exactly what i was trying to do
next they asked me to state again what i was trying to do - 3rd time of explaining the exact same thing
finally they replied asking me if i was trying to do blahbl;ah blah, which i made perfectly clear, i confirmed this was what i was trying to do, and its been over a week now and still no reply..... like i have nothing better to do.
i went to microsoft as regards this problem, and their forums are littered with people having the same basic error, they cannot upload/import a basic csv or xml file to their database using the microsoft sql 2005 or sql 2008 programs.
there are people like me that have been searching for a "work around" or a solution to this basic problem for weeks!
ive been trying to resolve this via two of us here at hoover towers without success, so the question would be obvious.... why bother having programs that dont do the basic features they are set up to do???
a complete lack of understanding by microsoft staff, about how to use their own products.... add to this a server provider who havent a clue how to configure their own servers to do something so basic as to import a csv or xml (industry standard) file.
those set ups that do work are access, sql server 2000, are either no longer supported by microsoft or cost the individual a lot of money to convert over to the "new" system that doesnt work.
i hate geeks.... why the hell do they over complicate things to the point where the product or program is entirely useless?
im just one of thousands of people who are having this problem, which begs the question, why do i (and many others like me) have to spend literally a 1000 man hours searching around the internet for "work arounds"? why not just fix the damn problem and make life easier for everyone?
