Source language: Translate to:

Problema con NeobookDBPro

Discussioni in Italiano di NeoBook

Moderator: systems.it

Problema con NeobookDBPro

Postby 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!
francescodj3
 
Posts: 10
Joined: Fri Jul 11, 2014 12:43 am

Re: Problema con NeobookDBPro

Postby 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
Neosoft Support
NeoSoft Team
 
Posts: 5593
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Re: Problema con NeobookDBPro

Postby 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!
francescodj3
 
Posts: 10
Joined: Fri Jul 11, 2014 12:43 am


Return to NeoBook in Italiano

Who is online

Users browsing this forum: No registered users and 1 guest