hello sir i backup mysql table using mysql infile command in vb.net 2005. this is nicely working local database.but connect remote sytem error came. i used code is
SELECT * INTO OUTFILE 'D:\Latest\LogSheet\bin\Debug\logsheet_00119082009033114\area_table.txt' FROM area_table
if i connect local database is this code execute correct.but i connect server(remote system) this code note executed.
---this is connection open Code----- Dim NewConnection As New ADODB.Connection NewConnection .open(DRIVER={MySQL ODBC 5.1 Driver};SERVER=server;DATABASE=LOGSHEET_001;UID=root;PWD=root;OPTION=3) here server means remote sytem name to replace server to localhost that code working correctly ------****----------- Please help me sir