Zugg Software :: View topic

Wanderer Joined: 28 Aug 2001 Posts: 86 Location: USA

Here's a list of what i do..

#var conn ""
#VAR Conn %comcreate( "ADODB.Connection")
#call @conn.open("myodbc3-test")
#echo @conn.connectionstring
#var everyone %concat( "blah blah", "blah blah.. this sql statement works")
#echo @everyone
#var rs @comm.execute(@everyone)
#echo this is the end

that is what i do, this is the ooutput

Provider=MSDASQL.1;Data Source=myodbc3-test;Extended Properties="DSN=myodbc3-test;DESC=MySQL ODBC 3.51 TEST DSN;DATABASE=test;SERVER=localhost;UID=root;PASSWORD=;PORT=3306;OPTION=3;STMT=;"
(this is the sql statement. that i put above)
this is the end

that is the output..
since i got the connection string, i can only assume, it connected

any reason, that inst inserting into the database?
the database, and table, exists, currectly... when i copy and paste that sql string, directly to mysql console, it works...

thanks

GURU Joined: 15 Jun 2001 Posts: 654 Location: USA

#var rs @comm.execute(@everyone)

That should be @conn to be consistent with the rest of the script.

Wanderer Joined: 28 Aug 2001 Posts: 86 Location: USA

fix that, no change.. that call command was possed to be another way to write the exec command right above it (duplicate result)

Wanderer Joined: 28 Aug 2001 Posts: 86 Location: USA

found problem.. it was that i have to connect in every script..

i got disconnected from the database