Mysql & Aruba

[unreg]

Salve,

Ho questo codice:

   Set Rs = Server.CreateObject("ADODB.Recordset")
   Sql = "SELECT * FROM User"
   Rs.Open Sql, Conn ,3,3

che mi ritorna questo errore:

ADODB.Recordset error '800a0e7d'

Connessione chiusa o non valida in questo contesto. Impossibile utilizzarla per eseguire l'operazione.

come mai ?

grazie !

[Roby_72]

Te lo dice: Conn l'hai aperta?

Roby

[unreg]

grazie !

solo che ora ho un'altro problema

Sql = "DELETE FROM User WHERE ID = 1" 
Conn.Execute(Sql)

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[TCX][MyODBC]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 '* From User Where ID = 1' at line 1

come mai ?

[maximum]

MySql credo voglia specificato l'asterisco:

Sql = "DELETE * FROM User WHERE ID = 1" 
Conn.Execute(Sql)

[unreg]

mi da questo errore

[TCX][MyODBC]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 '* From User Where ID = 1' at line 1

[Roby_72]

Sql = "DELETE FROM [User] WHERE ID = 1" 
Conn.Execute(Sql)

Roby

[unreg]

ritorna questo errore:

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[TCX][MyODBC]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 '[User] WHERE ID = 1' at line 1

come mai ?

[Roby_72]

Scrivi user con la lettera minuscola.

Roby

[unreg]

fatto, inoltre ho anche rinomitato la tabella, ma l'errore persiste

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[TCX][MyODBC]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 '[user] WHERE ID = 1' at line 1

ti posto tutta la pagina asp:

   Response.Buffer = True

   Dim Conn
   Set Conn=Server.CreateObject("ADODB.Connection")
        Conn.ConnectionString = "Driver={mySQL};Server=**.***.***.**;Port=3306;Database=Sql*****_1;Uid=Sql*****;Pwd=********;"
        Conn.Open

       
   Sql = "DELETE FROM [user] WHERE ID = 1" 
   Conn.Execute(Sql)

[Roby_72]

Prova:

ConnectionString = "Driver={mySQL};Server=**.***.***. **;Port=3306;Database=Sql*****_1;Uid=Sql
*****;Pwd=********;"
Conn.Open ConnectionString

Roby