Getting a timeout expired when filling dataset, cant seem to update the timeout.

[mike11d11]

I'm doing a simple TableAdapter.Fill filling my datatable from a view
within a SQL database. for some reason it is timing out after 30
seconds and I cant seem to find out where in vb.net 2005 I can go to
change the timeout setting for this. when i go to my project, then my
settings tab i set the connection timeout for 120, but it doesn't seem
to affect the timeout for filling my datatable.

Code used to fill datatable:
Me.Duplicates_ViewTableAdapter.Fill(Me.ALDataSet.D uplicates_View)

Settings for the connection to the SQL server:
Data Source=TLSQL;Initial Catalog=AL;Persist Security Info=True;User
ID=AL;Password=ALMMEN23L1;Asynchronous Processing=True;Connect
Timeout=120

[Cor Ligthert [MVP]]

Mike,

There are a lot of errors in your code.

There is in VB for sure not command as
Data Source =

Did you know that there is a special newsgroup for by instance timeouts.

There are as much persons in that specialized for VBNet as for C#.

microsoft.public.dotnet.framework.adonet

Cor

"mike11d11" <mi*******@yahoo.comschreef in bericht
news:11**********************@l53g2000cwa.googlegr oups.com...

I'm doing a simple TableAdapter.Fill filling my datatable from a view
within a SQL database. for some reason it is timing out after 30
seconds and I cant seem to find out where in vb.net 2005 I can go to
change the timeout setting for this. when i go to my project, then my
settings tab i set the connection timeout for 120, but it doesn't seem
to affect the timeout for filling my datatable.

Code used to fill datatable:
Me.Duplicates_ViewTableAdapter.Fill(Me.ALDataSet.D uplicates_View)

Settings for the connection to the SQL server:
Data Source=TLSQL;Initial Catalog=AL;Persist Security Info=True;User
ID=AL;Password=ALMMEN23L1;Asynchronous Processing=True;Connect
Timeout=120