Reply to thread

Message: <blockquote data-quote="vbmaster" data-source="post: 3936915" data-attributes="member: 109688">ok this is the way , issellama MySQL Connector/ODBC 3.51 Downloads  eka download karanna oni [code] [URL="ftp://ftp.inria.fr/pub/MySQL/Downloads/Connector-ODBC/3.51/mysql-connector-odbc-3.51.27-win32.msi"]Download[/URL]   or  [URL="http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32"]http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32[/URL][/code] meka instrall karata passe  thamai me vb codes wada karanne [code]Dim con As ConnectionDim rs As RecordsetDim server As String  ' server eka hari server eke ip  , nathnam  "localhost" Dim port As String           'port eka  (3306)  Dim user_name As String  ' "root"          Dim dbname As String   Dim psw As String  Dim [COLOR=DarkOrchid]table[/COLOR] As String     [/code] [code]server = "localhost"port = "3306"dbname = "your_db_name"user_name = "root"  ' or your user name in mysqlpsw = "your password"table = "your_table_name"[/code] create your connection [code]Set con = New Connectioncon.Open "DRIVER={MySQL ODBC 3.51 Driver};"  & "SERVER=" & server & ";" _                      & " DATABASE=" & dbname & ";"  & " PORT=" & port & ";" _                      & "UID=" & user_name & ";PWD=" & psw & "; OPTION=3"[/code] use table[code]Set rs = New Recordsetrs.Open [COLOR=Red]"sqlcommands"[/COLOR], con'sqlcommands walta  mysql commands  use karanna  with in  ""   ' Eg : "INSERT INTO [COLOR=DarkOrchid]table[/COLOR]  (autoID , name , email, ) VALUES (NULL , '" & [COLOR=DarkOrange]varname[/COLOR] & "' , ' " & var[COLOR=DarkOrange]email[/COLOR] & '" )"[/code]  form unload [code]Set rs = Nothing    con.CloseSet con = Nothing[/code] edit : Project > References > Microsoft ActiveX Data Objects 2.7 Library.   tick on it ok it's finish . <img src="/styles/default/xenforo/smilies/default/D.gif"  class="smilie" loading="lazy" alt=":D" title="Big grin    :D" data-shortname=":D" /></blockquote>

Verification: Asuwa dahayen wadi kalama keeyada?

Top Bottom

Search

Latest ads

Reply to thread