how to load multiple lines via myodbc and installshield ?
am 15.04.2006 10:27:21 von Abylai Ospan--=-jbNf3Wq50O4lCH7QsL7Q
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Good day !
I'm trying to install SQL scripts (initial database scheme) using
installshield and internal SQL -scripts loading feature. This
installshield 10.5 is using MyODBC to load sql script.
For example sql-script:
CREATE TABLE test(id int);
CREATE TABLE another_table(id int);
and I'm get error in line 2 from ODBC driver ;-( Error message like "You
have an error in your SQL syntax; ... "
But when I'm loading this sql script from command line using mysql.exe
all is ok.
May be myodbc dosn't support multiple lined sql script file ? Where to
download new version (may be unstable) with this feature support ?
--
Abylai Ospan
NetUP Inc.
--=-jbNf3Wq50O4lCH7QsL7Q--