MySQL 4.1.21 errors installing table en data

[mirandam]

Hai

I?ö£?¡m trying tot instal the database setting

but i am getting errors, help!!

this are the errors table:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[usd_graphSet] (
[graphSetID][int] IDENTITY (1, 1) NOT NULL,
[graphSetName] ' at line 1

this are the errors with data:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO usd_pollUser(username, pword) VALUES ('admin','admin')

DELETE usd' at line 3

What to do?

Greetings Miranda

[administrator]

Miranda,

I am confused by the MySQL error message you are coming up with. Ultimate Poll ships with both an MSSQL and MS Access database, either one of which can be used with the application. Are you attempting to use the application with a MySQL back-end?

[mirandam]

Hai

i have tried both this files:
UltimatePollASPData.sql
and
UltimatePollASPTables.sql

both with the same error

[administrator]

Miranda,

Neither of the files you mention are, in fact, SQL databases in themselves. They are scripts for loading the correct tables and data into the SQL database, which you must create on your server. For more details, please refer to Step 2 of the install instructions, which can be found in Install.htm in the root of the application.

If you are not able to create an MSSQL database for use with Ultimate Poll, I would suggest using the MS Access 2000 database provided.

[mirandam]

Hello

I made a database

thats not the problem

but when i want to use the scripts for loading the correct tables and data to the database i created, i get errors #1064

[administrator]

Could you tell please tell me what type of database you have created for the application? Please note that Ultimate Poll supports only Microsoft SQL Server.

[mirandam]

i have created a database called

ultimatepoll

i have added 1 user full acces of the database

it is version 4.1.21 i have acces with phpMyAdmin

where can i see if its microsoft SQL ?

[administrator]

Miranda,

It sounds like you are using a MySQL database with PHP. Is this correct? Ultimate Poll is an ASP application, and will not run on a PHP platform.