"External table is not in the expected format." how to solve this error?
-
hai all, i am using .net 2005.i do my project in asp.net webapplication. i write the connection named as "connstring_card" in web.config using xml. i done the following code in web.config using xml. <appSettings> <add key="connstring_card" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Kantech\Server_SE\Data;Extended Properties=Paradox 5.x;"/> </appSettings> then i access that connection named as "connstring_card" in c# coding side from web.config. The following code done in c# coding side. string conn = ConfigurationSettings.AppSettings["connstring_card"]; con = new OleDbConnection(conn); con.Open(); com = new OleDbCommand("select CardInfo1 from Card where State=1", con); dr = com.ExecuteReader(); the error "External table is not in the expected format." are showed in the line dr=com.executereader(). how to solve this?
-
hai all, i am using .net 2005.i do my project in asp.net webapplication. i write the connection named as "connstring_card" in web.config using xml. i done the following code in web.config using xml. <appSettings> <add key="connstring_card" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Kantech\Server_SE\Data;Extended Properties=Paradox 5.x;"/> </appSettings> then i access that connection named as "connstring_card" in c# coding side from web.config. The following code done in c# coding side. string conn = ConfigurationSettings.AppSettings["connstring_card"]; con = new OleDbConnection(conn); con.Open(); com = new OleDbCommand("select CardInfo1 from Card where State=1", con); dr = com.ExecuteReader(); the error "External table is not in the expected format." are showed in the line dr=com.executereader(). how to solve this?
sathyan_8294 wrote:
the error "External table is not in the expected format." are showed in the line dr=com.executereader(). how to solve this?
Search in google with error text "External table is not in the expected format". You will give reason why this error cause.
please don't forget to vote on the post that helped you.
-
hai all, i am using .net 2005.i do my project in asp.net webapplication. i write the connection named as "connstring_card" in web.config using xml. i done the following code in web.config using xml. <appSettings> <add key="connstring_card" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Kantech\Server_SE\Data;Extended Properties=Paradox 5.x;"/> </appSettings> then i access that connection named as "connstring_card" in c# coding side from web.config. The following code done in c# coding side. string conn = ConfigurationSettings.AppSettings["connstring_card"]; con = new OleDbConnection(conn); con.Open(); com = new OleDbCommand("select CardInfo1 from Card where State=1", con); dr = com.ExecuteReader(); the error "External table is not in the expected format." are showed in the line dr=com.executereader(). how to solve this?
The guy you 1 voted had it right. If you were to use google, you'd get heaps of info on this. Seeing as you're too lazy, I did it for you. Here's the answer I found. "that usually indicates that the default sort order in Pdox and Access are different, and the Pdox table you're trying to touch is keyed (indexed)" Imagine how much work you could achieve if you were willing to search for yourself ?
Christian Graus No longer a Microsoft MVP, but still happy to answer your questions.
-
sathyan_8294 wrote:
the error "External table is not in the expected format." are showed in the line dr=com.executereader(). how to solve this?
Search in google with error text "External table is not in the expected format". You will give reason why this error cause.
please don't forget to vote on the post that helped you.
:mad: Everybody want code or perfect solution.Nobody wants to try yourself. Dude I have searched in google and I have found a lots of reason thats why I told you to search in google.You needn't to avoid this answer. Believe me if you search in google you can solve this problem in a minute.
please don't forget to vote on the post that helped you.
-
:mad: Everybody want code or perfect solution.Nobody wants to try yourself. Dude I have searched in google and I have found a lots of reason thats why I told you to search in google.You needn't to avoid this answer. Believe me if you search in google you can solve this problem in a minute.
please don't forget to vote on the post that helped you.
I gave your post a 5. This forum depresses me far too often....
Christian Graus No longer a Microsoft MVP, but still happy to answer your questions.
-
I gave your post a 5. This forum depresses me far too often....
Christian Graus No longer a Microsoft MVP, but still happy to answer your questions.
Christian Graus wrote:
I gave your post a 5.
Thanks CG.
please don't forget to vote on the post that helped you.
-
hai all, i am using .net 2005.i do my project in asp.net webapplication. i write the connection named as "connstring_card" in web.config using xml. i done the following code in web.config using xml. <appSettings> <add key="connstring_card" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\Kantech\Server_SE\Data;Extended Properties=Paradox 5.x;"/> </appSettings> then i access that connection named as "connstring_card" in c# coding side from web.config. The following code done in c# coding side. string conn = ConfigurationSettings.AppSettings["connstring_card"]; con = new OleDbConnection(conn); con.Open(); com = new OleDbCommand("select CardInfo1 from Card where State=1", con); dr = com.ExecuteReader(); the error "External table is not in the expected format." are showed in the line dr=com.executereader(). how to solve this?
Hey Dude, Declare the oledb Connection Object Like This. OleDbConnection cn=new OleDbConnection(ConfigurationManager.ConnectionStrings["connstring_card"].ConnectionString; may be it will helpful to you...
-
Hey Dude, Declare the oledb Connection Object Like This. OleDbConnection cn=new OleDbConnection(ConfigurationManager.ConnectionStrings["connstring_card"].ConnectionString; may be it will helpful to you...