Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Dll is taking too much time to return the result #180

Open
gopals05 opened this issue Apr 6, 2020 · 1 comment
Open

Dll is taking too much time to return the result #180

gopals05 opened this issue Apr 6, 2020 · 1 comment

Comments

@gopals05
Copy link

gopals05 commented Apr 6, 2020

Hello

I am using this dll(AdoNetCore.AseClient) to connect to Sybase database.Connection is established.
But when executing the stored procedure it says "unsuppoted datatype 114 column"
The input parametes(in/out) totally 6 and out parameters are 16(out)
Sample code:

    AseConnection conn = new AseConnection();
    conn.ConnectionString = "server=TestServer;Database=TestDB;charset=iso_1;PWD=*****;port=1223;UID=testuser";
    conn.Open();                     
    AseCommand cmd = new AseCommand("testSp", conn);
    cmd.CommandType = CommandType.StoredProcedure;
    AseParameter param = cmd.CreateParameter();
    param.ParameterName = "@Name";
    param.AseDbType = AseDbType.VarChar;
    param.Direction = ParameterDirection.InputOutput;
    param.Value = "John";
    cmd.Parameters.Add(param);

    AseParameter param1 = cmd.CreateParameter();
    param1.ParameterName = "@ID";
    param1.AseDbType = AseDbType.Integer;
    param1.Direction = ParameterDirection.InputOutput;
    param1.Value = 1;
    cmd.Parameters.Add(param1);
    //return value
    AseParameter retValue = new AseParameter("@name", AseDbType.VarChar);
    retValue.Direction = ParameterDirection.Output;
    cmd.Parameters.Add(retValue);

    AseParameter retValue1 = new AseParameter("@year", AseDbType.Integer);
    retValue1.Direction = ParameterDirection.Output;
    cmd.Parameters.Add(retValue1);
 var reader = cmd.ExecuteReader();
    while (reader.Read())
    {
        //do something

    }
    reader.Close();
    conn.Close();

Can anyone assist please to solve this issue?
I have been going through this for over 2 weeks
Thanks

@gopals05 gopals05 changed the title Dll is taking too much tome to return the result Dll is taking too much time to return the result Apr 6, 2020
@formicas
Copy link
Contributor

Can you share an example stored proc that can be used to reproduce this issue?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants