ExecuteReader: Connection property has not been initialized RSS

• • Reply
  

  sessiz

  Member

  105 Points

  21 Posts

  ExecuteReader: Connection property has not been initialized

  Sep 03, 2003 09:27 PM|LINK

  well, here is my simple code: <script runat="server"> Sub Page_Load (Obj as object,E as EventArgs) Dim db_baglanti as OleDbConnection db_baglanti = New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source=" & Server.MapPath("db/ornek_veritabani.mdb")) db_baglanti.Open() Dim db_komut as OleDbCommand db_komut = New OleDbCommand ("Select * From müsteriler,db_baglanti") db_komut.ExecuteReader() db_baglanti.Close() End Sub </script> müsteriler is the table in ornek_veritabani.mdb And error message is: "ExecuteReader: Connection property has not been initialized." Does anyone know how to "initialize" the connection property ... Many thanks from a rookie ...
• • Reply
  

  SushilaSB

  Star

  11417 Points

  2265 Posts

  Re: ExecuteReader: Connection property has not been initialized

  Sep 03, 2003 11:41 PM|LINK

  db_komut = New OleDbCommand ("Select * From müsteriler,db_baglanti") is it a typo It should be

  db_komut = New OleDbCommand ("Select * From müsteriler",db_baglanti)

  Also make sure that the connection string is proper
  Sushila Bowalekar Patel
  Visual ASP/ASP.NET MVP
  http://weblogs.asp.net/sushilasb
• • Reply
  

  sessiz

  Member

  105 Points

  21 Posts

  Re: ExecuteReader: Connection property has not been initialized

  Sep 04, 2003 03:47 PM|LINK

  oh!!! sorry for that awful mistake ... i i must have seen that ! ... and thanks for help SushilaSB ...