Problema con NeobookDBPro

Discussioni in Italiano di NeoBook
Locked
francescodj3
Posts:10
Joined:Fri Jul 11, 2014 12:43 am
Problema con NeobookDBPro

Post by francescodj3 » Fri Jan 01, 2016 11:17 am

Salve a tutti!
Oggi stavo facendo un software e necessitavo di importare dei file sql.
Quando importo i file sql mi appare un errore...
Questo è il comando:
FileRead "mysqlfile.sql" "All" "[sqlfile]"
dbpOpenDatabase "1" "Provider=MSDASQL.1;Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=mydatabase;User=root;Password=mypassword;Option=3"
dbpExecSQL "1" "[sqlfile]" ""
E l'errore è questo:
L'oggetto Parameter non è stato definito correttamente. Le informazioni fornite sono incoerenti o incomplete

Ho provato ad importare lo stesso file sql con Navicat e PhpMyAdmin e funzionava tutto perfettamente.
Come si può risolvere?
Grazie in anticipo!

Neosoft Support
NeoSoft Team
Posts:5628
Joined:Thu Mar 31, 2005 10:48 pm
Location:Oregon, USA
Contact:

Re: Problema con NeobookDBPro

Post by Neosoft Support » Sat Jan 02, 2016 10:24 pm

DBPro uses an ADO/ODBC interface to connect to the mySQL server. DBPro is not itself capable of executing SQL statements. It must pass them through the ADO/ODBC driver to the mySQL server which then executes the commands. Most likely, something in your SQL file cannot be executed through this type of interface.
NeoSoft Support

francescodj3
Posts:10
Joined:Fri Jul 11, 2014 12:43 am

Re: Problema con NeobookDBPro

Post by francescodj3 » Mon Jan 04, 2016 6:49 am

Neosoft Support wrote:DBPro uses an ADO/ODBC interface to connect to the mySQL server. DBPro is not itself capable of executing SQL statements. It must pass them through the ADO/ODBC driver to the mySQL server which then executes the commands. Most likely, something in your SQL file cannot be executed through this type of interface.
Ok, grazie!

Locked