I try to import data into my database via the Loader in my base. I want to import CSV data has negative (with a "-" before the number). When I import, I have the following error message:

"Invalid character value for the specification of the case."

It seems that the system does not handle negative data, because when I took the numbers with a "-" before the import went smoothly.

Note that I'm new to SQL.

Thank you in advance for your answers.

Could someone please explain to me how I can use Access as a complex database and can it support complex datatypes? What are the other databases that can be used to complement Access and get a high quality complex database that can deliver on a large scale organization and yet complex data type?

While trying to edit settings in some objects, the response I get is, "the specified procedure could not be found." 

So I thought there must be an issue with the content in the database, however when I created a new database and tried to edit settings once again I received the same response.

Thank you for your help.

While working on a school project I got stuck with a problem, I cannot update my database placed on a remote Windows Server and created in MS Access but published by MS Publisher. I was making some changes on my database (I have a copy of the database on my computer [offline working]) which I want to update on my webpage. I connect to my server remotely, and I open the access database, the update goes to 100% and than occurs an error, It says: "database could not be updated this time due to internet connection failure, please try again later.". I have tried this 10000 times it never works, any ideas???

I've been speaking to developers recently and have been given information that I am not entirely sure of and I'm hoping that someone can assist me.

I'm wondering if it is possible to create a SQL Server stored procedure without T-SQL being necessary. I've been told that it is, but to me, the knowledge of T-SQL would be necessary at least for data access.

Thank you for any input you may have.

From the Data Mining and Warehousing subject I found a process called clustering. Briefly describe me what is clustering and what the advantages of clustering. And also I need some details about these two different approaches to clustering:

·         Partitioning methods

·         Hierarchical methods

Are data mining and data warehousing related? I am totally confused about TGIS.  Please help me with this question.

Hi,

Hello, On my Windows 7 machine, I run PostgreSQL databases, but I can't add a server to create my databases. As an address I use 'localhost'  but can't connect, resulting to the following errors:

pgAdmin III

An error has occurred:

Error connecting to the server: FATAL: database "db" does not exist

pgAdmin III

An error has occurred:

Error connecting to the server: could not connect to server: Connection refused (0x0000274D/10061)

I have a Debian server, that I have installed LAMP.  Everything was running smoothly. I was connecting through konsole to MySQL and through phpmyadmin without any problems until recently.  For the last week, when I'm running 'etc/init.d/mysql start' from the konsole, I get the following message:

"Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld.
Checking for corrupt, not cleanly closed and upgrade needing tables."

Also, when I'm running 'mysql'  from the konsole, I get the following message:

"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)"

Any ideas?