 |
karthic
Wanderer
Joined: 28 Aug 2001
Posts: 86
Location: USA
|
 Posted: Thu Aug 28, 2003 4:44 pm
mysql connection
|
would someone give me an example of connecting to a mysql database through zmud..., inserting, then selecting, and using the result?
oh, for example, the connection string i use for visual basic is...
cn.Connect = "DRIVER={MySQL ODBC 3.51 Driver};uid=root;pwd=;server=127.0.0.1;database=spider;dsn='';"
cn.CursorDriver = rdUseOdbc
Thank you |
|
|
|
|
karthic
Wanderer
Joined: 28 Aug 2001
Posts: 86
Location: USA
|
Posted: Thu Aug 28, 2003 9:44 pm
|
using that same string, then #echo @conn.connectionstring, seems to output nothing
like this
#call @conn.open("DRIVER={MySQL ODBC 3.51 Driver};uid=root;pwd=;server=127.0.0.1;database=spider;dsn='';")
#echo @conn.connectionstring
echo's nothing at all
rob |
|
|
|
|
karthic
Wanderer
Joined: 28 Aug 2001
Posts: 86
Location: USA
|
Posted: Thu Aug 28, 2003 10:21 pm
|
seems i figgured it out
i installed myodbc from mysql.com, oped the bde administrator in my control panel in winxp,
say the mysql dsn string
used this to connect
#VAR Conn %comcreate( "ADODB.Connection")
#call @conn.open("myodbc3-test")
#echo @conn.connectionstring |
|
|
|
|
|
|
|
