OleDbCommand and OleDbDataReader Question

khng · April 12th, 2005, 09:15 AM

I placed my page at webmatrixhosting and found that it can't run (it should run well as no problem with my own pc)

So could anyone tell me what wrong with the line of
myReader = myCommand.ExecuteReader()
note: myRead is a OleDbDataReader

Code:

<%@ Page Language="VB" Debug="True" %>
<%@ import Namespace="system.data" %>
<%@ import Namespace="system.data.oledb" %>
<html>
<head>
</head>
<body>
    <%
        Dim mySelectQuery As String = "SELECT item_id,item_name FROM item"
            Dim myConnection As New OleDbConnection(application("cnStr"))
        Dim myCommand As New OleDbCommand(mySelectQuery, myConnection)
        myConnection.Open()
        Dim myReader As OleDbDataReader
        myReader = myCommand.ExecuteReader()
        ' Always call Read before accessing data.
        While myReader.Read()
            response.write(myReader.GetInt32(0).ToString() + ", " _
            + myReader.GetString(1) + "<BR>")
        End While
        ' always call Close when done reading.
        myReader.Close()
        ' Close the connection when done with it.
        myConnection.Close()
    %>
</body>
</html>

planoie · April 13th, 2005, 08:07 PM

Are you getting an error message? Can we see it? Nothing looks obviously wrong with what you have.

-Peter

khng · April 13th, 2005, 08:58 PM

Quote:

quote:Originally posted by planoie
Are you getting an error message? Can we see it? Nothing looks obviously wrong with what you have.

-Peter

here is the error showed by that hosing

Code:

Selected collating sequence not supported by the operating system. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.OleDb.OleDbException: Selected collating sequence not supported by the operating system.

Source Error: 


Line 19:                 cmd.parameters("@login_id").value=txtid.text
Line 20:     
Line 21:                 dim dr as OleDbDataReader=cmd.ExecuteReader(CommandBehavior.CloseConnection)
Line 22:                 'Check password
Line 23:                 if dr.read() and dr.getString(0)=txtpassword.text

planoie · April 13th, 2005, 09:30 PM

This sounds like some kind of database/os configuration problem.

khng · April 14th, 2005, 09:04 AM

Quote:

quote:Originally posted by planoie
This sounds like some kind of database/os configuration problem.

but for another code its work!
here is the working code:

I don't know why that code work, while my code being punished by the server

Code:

<%@ Page Language="vb" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.Oledb" %>
<script runat="server">

    Sub Page_Load()
       Dim strConnection as String = "Provider=Microsoft.Jet.OLEDB.4.0;"
         strConnection &= "Data Source=" & Server.MapPath("Northwind.mdb")
         data_src.text = strConnection
         application("strConnection")=strConnection
       Dim strSQL as string = "select FirstName, LastName from Employees"
       Dim strResultsHolder as string

       Dim objConnection as New OledbConnection(application("STRConnection"))
       Dim objCommand as New OledbCommand(strSQL, objConnection)
       Dim objDataReader as OledbDataReader

       try
         objConnection.Open()
         con_open.text="Connection opened successfully.<br />"
       objDataReader = objCommand.ExecuteREader()

       Do While objDataReader.Read()=True
         strResultsHolder +=objDataREader("FirstName")
         strResultsHolder +="&nbsp;"
         strResultsHolder +=objDataREader("LastName")
         strResultsHolder +="<br>"
       Loop

       objDataReader.Close()
         objConnection.Close()
         con_close.text="Connection closed.<br>"
       divListEmployees.innerHTML = strResultsHolder
       catch e as Exception
         con_open.text="Connection failed to open successfully.<br>"
         con_close.text=e.ToString()
       end try
    end Sub

</script>
<html>
<head>
</head>
<body>
    <h4>Reading data from the connection <asp:Label id="data_src" runat="server"></asp:Label>with
        the DataReader object. 
    </h4>
    <asp:Label id="con_open" runat="server"></asp:Label>
    <br />
    <div id="divListEmployees" runat="server">list will go here 
    </div>
    <asp:Label id="con_close" runat="server"></asp:Label>
    <br />
</body>
</html>

For question asking, please made sure that your question is as similar as possible while providing enought level of details!
Since not all peoples, like to read large amounts of text just for reading or requirement and waste the answer time to read your text