SQL Script Help.

[bwarner83]

Alright, I have a script that runs in .SQL, how do I run it on MySQL? Everytime I try to run the .sql file to load the tables and such I receive an error.

I'll be more then happy to grant access to the sql table and our folder, I just can't seem to get it to work.

[mitchind]

I receive an error.

What error?

[RTH10260]

Alright, I have a script that runs in .SQL, how do I run it on MySQL? .What do you mean by 'runs in .SQL' ? Myphpadmin runs the .sql script files for you against the MySql database you have logged into.

[bwarner83]

the file is .sql ... everytime i run the script in the myphpadmin i receive ... the script can be located at ... http://www.afmhomes.com/database ... It tells me there is an error ... I'm not really sure how to make it work with MySQL. I know it's written for MSSQL.

[RTH10260]

I'm not really sure how to make it work with MySQL. I know it's written for MSSQL.OK, now that explains much, and it also explains the strange look of that .sql script.

I am sorry to tell you, that there is no standard for writing sql scripts, there is only a standard for coding sql statements themselves. Plus MS is wellknown to make their own extensions to everything. Some of the stuff seen in the script is MSSQL Server specific (eg. the sysobjects table).

I have somehow the impression, that this script also gets some variable substitution applied before execution (eg names in [brackets]), possibly thru an installer application.

You are up for a major rewrite to use this application with MySql as dbms.

[RTH10260]

I know it's written for MSSQL.Correct, but it's only half the truth.

When I interpret the contents of your sql script correctly, this is for a 'ehomes' package from 'enthrallweb.com'.

The following is a partial quote from the System Requirements page at http://www.enthrallweb.com/Detail.asp?ProductID=9#:eHomes System Requirements
Front end is Active Server Pages - Visual Basic 3.0 Back end works with Ms Access 2000 or SQL Server depending on available license

(Access DB is ugradeable to Ms SQL Server 2000 - Click on Upgrade button in download area to request upgrade to SQL)

Installation Requirements ·

Windows server that supports Access 2000 database to host the solution.
In other words, this application will never run at Powweb's hosting, cause it is designed for a completely different environment (a Windows server platform for hosting).

[bwarner83]

Thank you.