My application is usningtraditional connection string:
<
addkey="DbConnection"value="driver={SQL Native Driver}; provider=SQLNCLI;server=localhost;trusted_connection=yes;database=ebay" />It works fine with database attached to SQL Server, how do I make this working with SQL Express attachable file in data directory?
I have tried this, but it does not work:
Provider=SQLNCLI;Server=RAF001\SQLExpress;AttachDbFilename=..\TestSite\App_Data\ebay.mdf;Database=ebay;Trusted_Connection=Yes;
can someone help me why it produces an error...
error is: ERROR 22001 Microsoft ODBC SQL Server Driver SQL Server STRING or data of BINARY was cut short.
ERROR 01000 Microsoft ODBC SQL Server Driver SQL Server statement was ended.
This is my code here for editing a record...
Protected Sub Button_save2_Click1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button_save2.Click
'||||| Create string connection
Dim StrConn As String = "Dsn=MS_PKG01;UID=emiline;APP=Microsoft? Visual Studio? 2005;WSID=MSHNP200603;DATABASE=MS_PKG01;Trusted_Connection=Yes"
'||||| Create connection object
Dim MyConn As Odbc.OdbcConnection = New Odbc.OdbcConnection(StrConn)
'||||| Open connection
MyConn.Open()
'|||| Create odbcCommand object
Dim Update_record As New Odbc.OdbcCommand("UPDATE TM0001 SET TM0001.syain_name = ?, TM0001.syain_pass = ?, TM0001.office_id = ?, TM0001.birth_date = ?, TM0001.empl_date = ?, TM0001.user_iden = ? ", MyConn)
Dim hireYear As String
Dim hireMonth As String
Dim hireDay As String
Dim date_hire As String
hireYear = DropDownList_hire_yr.Text
hireMonth = DropDownList_hire_mo.Text
hireDay = DropDownList_hire_day.Text
date_hire = hireYear + "/" + hireMonth + "/" + hireDay
'|||| Add command parameters
Update_record.Parameters.Add("@.P1", OdbcType.Char, 8).Value = TextBox_id.Text
Update_record.Parameters.Add("@.P2", OdbcType.Char, 20).Value = TextBox_name.Text
Update_record.Parameters.Add("@.P3", OdbcType.Char, 20).Value = TextBox_pswd.Text
Update_record.Parameters.Add("@.P3", OdbcType.Char, 40).Value = DropDownList_office.SelectedValue
Update_record.Parameters.Add("@.P3", OdbcType.Char, 2).Value = date_hire
Update_record.Parameters.Add("@.P3", OdbcType.Char, 10).Value = TextBox_bday.Text
Update_record.Parameters.Add("@.P3", OdbcType.Char, 1).Value = DropDownList_iden.SelectedValue
'|||| Execute command
Update_record.ExecuteNonQuery()
'|||| Close connection
MyConn.Close()
End Sub
End Class
I modify some codes already but still same error...
my code:
'||||| Create connection object
Dim MyConn As Odbc.OdbcConnection = New Odbc.OdbcConnection(StrConn)
'|||| Create odbcCommand object
Dim Update_record As New Odbc.OdbcCommand("UPDATE TM0001 SET TM0001.syain_name = ?, TM0001.syain_pass = ?, TM0001.office_id = ?, TM0001.birth_date = ?, TM0001.empl_date = ?, TM0001.user_iden = ? where syain_id = ? ", MyConn)
id_user = TextBox_id.Text
name = TextBox_name.Text
pass = TextBox_pswd.Text
office_id = DropDownList_office.SelectedValue
bday = TextBox_bday.Text
iden = DropDownList_iden.SelectedValue
hireYear = DropDownList_hire_yr.Text
hireMonth = DropDownList_hire_mo.Text
hireDay = DropDownList_hire_day.Text
date_hire = hireYear + "/" + hireMonth + "/" + hireDay
'|||| Add command parameters
Update_record.Parameters.Add("@.P1", OdbcType.Char).Value = name
Update_record.Parameters.Add("@.P1", OdbcType.Char).Value = pass
Update_record.Parameters.Add("@.P1", OdbcType.Char).Value = office_id
Update_record.Parameters.Add("@.P1", OdbcType.Char).Value = date_hire
Update_record.Parameters.Add("@.P1", OdbcType.Char).Value = bday
Update_record.Parameters.Add("@.P1", OdbcType.Char).Value = iden
Update_record.Parameters.Add("@.P1", OdbcType.Char).Value = id_user
'||||| Open connection
MyConn.Open()
'|||| Execute command
Update_record.ExecuteNonQuery()
'|||| Close connection
MyConn.Close()
Hi,
i think a textfield has more data as permitted, so the update command crashed. You can inspect the prepared SQLCommand inside the Update_record object and try to execute this command direct in the database (Query Analyzer or Database Command Prompt Interface).
Regards
Marc Andre
hmmm i already check it and there is nothing wrong...
and whenever i input a new record it always satisfy the condition in the data type...
but still i dont why when i edit it generates error in my code...
hmmm another thing that i observe in my code is that when
i click the save button when editing it doesnt change anything...but the first record or the initial record always shows...
i tried putting is postback but nothing happens...
everytime i press the save button to saved my changes in the data the initial entry shows...
coz in my pageload the initial entry or the first record in the dabse is shown...
hmmm what do u think?
Hi,
Anybody have a clear idea why I might have problems connecting from reporting services to Oracle 9i database using the Microsoft ODBC driver? Getting following error
"Cannot create a connection to data source 'oracleName'.
I have the data source correctly set-up thought. Is it a permissions problem?
Thanks.
When you say you have it set up correctly, do you mean that you were able to connect to it from other applications? or what exactly?
Assuming it is correct, try using the Microsoft OLE DB Provider for ODBC. This always works for me.
>L<
quote:
> Microsoft OLE DB Provider for ODBC Drivers
> error '80004005'
> Specified driver could not be loaded due to system error
> 126 (SQL Server).
>
Hi,
The project I′m working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.
But when I tried to create a DataRearder Source pointing to my ODBC Data Source, and open the next tab I received this error message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.
Thanks
Wenyang
|||Wenyang,
Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.
But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.
If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager? We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...
Thanks
Wenyang
|||
were you able to slove this problem..
I am also facing similar problems.
|||
Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.
When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,
"Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."
Can any body help me ?
Regards,
Chetan
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||Hi, I am facing problem to connect to progress db in .net,
Would you please let me know of the connection string and other settings ,
I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.
but then i get error when i try set anything else.
Thanking you.
|||
Problem solved
|||
Hi,
Could you please share your experience with us?
Thanks
Hi,
The project I′m working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.
But when I tried to create a DataRearder Source pointing to my ODBC Data Source, and open the next tab I received this error message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.
Thanks
Wenyang
|||Wenyang,
Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.
But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.
If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager? We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...
Thanks
Wenyang
|||
were you able to slove this problem..
I am also facing similar problems.
|||
Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.
When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,
"Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."
Can any body help me ?
Regards,
Chetan
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||Hi, I am facing problem to connect to progress db in .net,
Would you please let me know of the connection string and other settings ,
I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.
but then i get error when i try set anything else.
Thanking you.
|||Problem solved
|||
Hi,
Could you please share your experience with us?
Thanks
Hi,
The project I′m working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.
But when I tried to create a DataRearder Source pointing to my ODBC Data Source, and open the next tab I received this error message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.
Thanks
Wenyang
|||Wenyang,
Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.
But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.
If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager? We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...
Thanks
Wenyang
|||
were you able to slove this problem..
I am also facing similar problems.
|||
Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.
When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,
"Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."
Can any body help me ?
Regards,
Chetan
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||Hi, I am facing problem to connect to progress db in .net,
Would you please let me know of the connection string and other settings ,
I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.
but then i get error when i try set anything else.
Thanking you.
|||Problem solved
|||
Hi,
Could you please share your experience with us?
Thanks
Hi,
The project I′m working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.
But when I tried to create a DataRearder Source pointing to my ODBC Data Source, and open the next tab I received this error message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.
Thanks
Wenyang
|||Wenyang,
Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.
But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.
If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager? We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...
Thanks
Wenyang
|||
were you able to slove this problem..
I am also facing similar problems.
|||
Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.
When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,
"Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."
Can any body help me ?
Regards,
Chetan
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||Hi, I am facing problem to connect to progress db in .net,
Would you please let me know of the connection string and other settings ,
I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.
but then i get error when i try set anything else.
Thanking you.
|||
Problem solved
|||
Hi,
Could you please share your experience with us?
Thanks
Hi,
The project I′m working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.
But when I tried to create a DataRearder Source pointing to my ODBC Data Source, and open the next tab I received this error message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.
Thanks
Wenyang
|||Wenyang,
Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.
But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.
If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager? We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...
Thanks
Wenyang
|||
were you able to slove this problem..
I am also facing similar problems.
|||
Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.
When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,
"Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."
Can any body help me ?
Regards,
Chetan
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||Hi, I am facing problem to connect to progress db in .net,
Would you please let me know of the connection string and other settings ,
I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.
but then i get error when i try set anything else.
Thanking you.
|||Problem solved
|||
Hi,
Could you please share your experience with us?
Thanks
Hi,
The project I′m working needs to import data from a Progress Database. I had configured my ODBC (MERANT 3.60 32-BIT Progress SQL92 v9.1D) driver and everything seems to be ok.
But when I tried to create a DataRearder Source pointing to my ODBC Data Source, and open the next tab I received this error message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
DataReaderSource requires a managed ADO.Net connection, so try to create a ADO.Net:ODBC connection first then point to that connection at DataReaderSrc.
Thanks
Wenyang
|||Wenyang,
Since the first time I did what you said. I create a ADO.NET:ODBC connection and I received a successifull message.
But when I create create a DataReader Source and point to my ADO.NET:ODBC connection I receive this message:
“Error at Data Flow Task [DataReader Soucer [135]]: Cannot acquire a managed connection from the run-time connection manager”
um...normally this error is only seen when you use a wrong type of connection manager(e.g. a native one) at DataReaderSrc.
If you did use .Net provider for ODBC in your connection manager, did you see success when pushing the button "Test Connection" in your connection manager? We cast the connection to IDbConnection, I see no reason why you succeeded there but failed in DataReaderSrc on this error...
Thanks
Wenyang
|||
were you able to slove this problem..
I am also facing similar problems.
|||
Even i am facing similar kind of problem. But i my case i trying to connect to JDE through ODBC driver.
When i test the connection in connection manager, it succeds. but when i try to pull data using DataSource reader, it gives the same error,
"Error at DAta Flow Tast[DataReader Source [1]]: Cannot acquire a managed connection from the run-time connection manager."
Can any body help me ?
Regards,
Chetan
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||I had a similar issue, the error I was getting:
"Error at Data Flow Tast[DataReader Source [35]]: Cannot acquire a managed connection from the run-time connection manager."
I changed to the ADO.NET ODBC as suggested above and it worked for me, THANKS for the tip!
Before changing it to ADO.NET ODBC it would work in the connection manager for the test but not the data read task. You would think Microsoft would either give better error messages or not allow the connection to be selected or something instead of just giving generic messages.
|||Hi, I am facing problem to connect to progress db in .net,
Would you please let me know of the connection string and other settings ,
I currently get connection string wrong format problem , but the weird part is when i test connection, it passes.
but then i get error when i try set anything else.
Thanking you.
|||
Problem solved
|||
Hi,
Could you please share your experience with us?
Thanks
