Problem in accessing data from MYSQL table???
-
There is a open connection to the database.That i have checked with my connection object's state(conn.state) property.. My connection string is : "Conn.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=MyServer;Database=test;uid=root;pwd=;option=3" Dim strSQL As String = select * from tablename cmd.connection=conn cmd.commandtext=strSQL da = New Odbc.OdbcDataAdapter(cmd) Da.Fill(ds, "RAHUL") Here it gives exception at last statement i.e "Da.Fill(ds, "RAHUL")" Thanks in advance..
-
There is a open connection to the database.That i have checked with my connection object's state(conn.state) property.. My connection string is : "Conn.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=MyServer;Database=test;uid=root;pwd=;option=3" Dim strSQL As String = select * from tablename cmd.connection=conn cmd.commandtext=strSQL da = New Odbc.OdbcDataAdapter(cmd) Da.Fill(ds, "RAHUL") Here it gives exception at last statement i.e "Da.Fill(ds, "RAHUL")" Thanks in advance..
Rahul Say hiiiii wrote:
Here it gives exception at last statement i.e "Da.Fill(ds, "RAHUL")"
paste your exception error text here
Human knowledge belongs to the world http://www.rad.pasfu.com/index.php
-
There is a open connection to the database.That i have checked with my connection object's state(conn.state) property.. My connection string is : "Conn.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};Server=MyServer;Database=test;uid=root;pwd=;option=3" Dim strSQL As String = select * from tablename cmd.connection=conn cmd.commandtext=strSQL da = New Odbc.OdbcDataAdapter(cmd) Da.Fill(ds, "RAHUL") Here it gives exception at last statement i.e "Da.Fill(ds, "RAHUL")" Thanks in advance..
Whatever you do, don't tell anyone what the exception is. Just let them all waste some time guessing. :)
Luc Pattyn [Forum Guidelines] [My Articles]
- before you ask a question here, search CodeProject, then Google - the quality and detail of your question reflects on the effectiveness of the help you are likely to get - use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets