Help..

burak.ogutken · Post by **burak.ogutken** » Sat 25 Sep 2010 18:26

hello

i have one form i am putting sqlconnection component on form connecting server is everythink okey..

then putting one sqldatatable and selection connection property my sql connection then connecting table.. is everythink okey

then again putting another sqldatatable component then trying to select again my sqlconnection but in the list my connection is dissapearing automatically creating new sqlconnection i dont understand please help me where is my problem ?

thanks

StanislavK · Post by **StanislavK** » Tue 28 Sep 2010 12:12

Could you please specify the version of dotConnect for SQL Server and Visual Studio you are using? We couldn't reproduce the issue in our environment.

burak.ogutken · Post by **burak.ogutken** » Tue 28 Sep 2010 13:32

hello

2.40.152 Devart Version
Visual Studio 2010

thanks

StanislavK · Post by **StanislavK** » Wed 29 Sep 2010 13:15

I will send you a test project in a letter, please check that it was not blocked by your mail filter.

Please try reproducing the problem with this sample. If it is possible, the issue is probably an integration one; please try performing the following:
- uninstall dotConnect for SQL Server;
- clear the Program Files\Devart\dotConnect and Program Files\Common Files\Devart\dotConnect folders;
- remove all Devart.* and policy.*.Devart.* files from the GAC;
- re-install dotConnect for SQL Server with the 'Install menu item and toolbox components into Visual Studio' option enabled.

If in the sample you are able to set the same connection to both SqlDataTables, please send us a test project with which the issue can be reproduced so that we are able to investigate it in details.

burak.ogutken · Post by **burak.ogutken** » Tue 12 Oct 2010 17:43

'
'sql_connection
'
Me.sql_connection.ConnectionString = "Data Source=.;Initial Catalog=SysSoftDB;Integrated Security=False;Password=dsadrer" & _
"8;Persist Security Info=True;User ID=sa;Application Name=""dotConnect for SQL Ser" & _
"ver"";"
Me.sql_connection.Name = "sql_connection" Me.qr_grid.Name = "qr_grid"
Me.qr_grid.TableName = "sdt_grid"
Me.qr_grid.Owner = Me
Me.qr_grid.Connection = CType(Devart.Common.GlobalComponentsCache.GetObjectByName("frm_login.sql_connection"), Devart.Data.SqlServer.SqlConnection)

i dont understand when i am selecting from frm_login.sql_connection on sqldatatable1 automatically creatin on form sql_connection

after some tables are changing like this

'
'sc_yetki
'
Me.sc_yetki.CommandText = "SELECT * FROM dbo.sys_user_rights ur" & Global.Microsoft.VisualBasic.ChrW(10) & "LEFT OUTER JOIN dbo.sys_user_rights_detay ur" & _
"d ON ur.YetkiID = urd.YetkiID " & Global.Microsoft.VisualBasic.ChrW(10) & "WHERE ur.UserID = @userid AND urd.FormCode = @for" & _
"mcode"
Me.sc_yetki.Connection = Me.sql_connection Me.sc_yetki.Name = "sc_yetki"
Me.sc_yetki.Parameters.Add(New Devart.Data.SqlServer.SqlParameter("@userid", CType(resources.GetObject("sc_yetki.Parameters"), Object)))
Me.sc_yetki.Parameters.Add(New Devart.Data.SqlServer.SqlParameter("@formcode", CType(resources.GetObject("sc_yetki.Parameters1"), Object)))

but some one are

'
'tb_master
'
Me.tb_master.Name = "tb_master"
Me.tb_master.TableName = "sdt_master"
Me.tb_master.Owner = Me
Me.tb_master.Connection = CType(Devart.Common.GlobalComponentsCache.GetObjectByName("frm_login.sql_connection"), Devart.Data.SqlServer.SqlConnection)

someone help me please..

burak.ogutken · Post by **burak.ogutken** » Tue 12 Oct 2010 18:30

i tested now with vs2008 dont have any problem..
working but vs2010 not working..

i think vs2010 changed someting about inheritance

when i create new project in vs2010 not working
but when i create project in vs2008 and convert 2010 working.. please check this sir..

Burak..

StanislavK · Post by **StanislavK** » Thu 14 Oct 2010 12:39

We have reproduced the following issue under Visual Studio 2010: when an SqlConnection object is created on a form (say, Form1) and is referenced from another form (say, Form2), a redundant instance of SqlConnection is created on Form2. Please confirm that you meant this problem. We will investigate it and inform about the results here.

burak.ogutken · Post by **burak.ogutken** » Fri 15 Oct 2010 17:50

yes this is the problem i sended test project by mail

thank you..

burak.ogutken · Post by **burak.ogutken** » Wed 20 Oct 2010 13:45

any news ?

Regards

StanislavK · Post by **StanislavK** » Fri 22 Oct 2010 16:15

We are working on this issue, we will inform you when it is fixed.

burak.ogutken · Post by **burak.ogutken** » Sun 24 Oct 2010 09:45

ok i am waitting thank you..

Burak Ogutken

burak.ogutken · Post by **burak.ogutken** » Fri 05 Nov 2010 13:31

hello again do you have any news about problem ?
we are stopped sir..

thank you

StanislavK · Post by **StanislavK** » Tue 09 Nov 2010 12:27

We will inform you as soon as the build with the fix is available.

StanislavK · Post by **StanislavK** » Tue 30 Nov 2010 17:46

We have released the new 2.40.194 version of dotConnect for SQL Server which includes the fix for this problem.

The new version can be downloaded from
http://www.devart.com/dotconnect/sqlser ... nload.html
(the trial version) or from Registered Users' Area (for users with active subscription only):
http://secure.devart.com/

For the detailed information about the fixes and improvements available in the new version, please refer to
http://www.devart.com/forums/viewtopic.php?t=19636