473,224 Members | 1,624 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,224 software developers and data experts.

Problem: Database connections remain open

Hi

I've a class that creates a connection to a database, gets and loop on a
dataset given a query and then close the connection. When I use netstat
viewer to see if there is any connection open left, I always see that there
are 2 connections open and in "ESTABLISHED" state. Here is the piece of code
that I'm using, please tell where I'm doing it wrong. Since this class is
being used at many placed in my actual web based application that uses it
extensively, so the open connections grow alot, occupying most of the ports
of system and some time creating problem for other port based applications
like ftp.

Few things that I noted on debugging it line by line and monitoring from
netStats viewer.

1. On execution of m_con.Open, it shows 1 or sometimes 2 connections in
"Established" state. No idea why it shows 2 open connections, where it
should only be one.
2. If I only see one connection in established state after m_con.Open
statement, then the second connection in established state comes when i'm
looping over the dataset records. So at the end there are two connections
left open no matter what.
3. Disposing dataset, sqlcommand, sqladapter, or sqlconnection does'nt have
any effect on the state of the connections that are opened.
4. Somewhere on the net I read that the opened connections are not disposed
rather returned to a pool but in a non-established state to improve
performance, but the connection my application opens stay in "established"
state.
5. When I close my application, all the open and established connections
(two in my case) are deleted from the Netstat viewer utility, i.e. the
opened db sessions are closed on application exit.

Please check it and tell me where I'm making the mistake or how to release
the openend connection.

/////////////////////////////////////////////////////CODE//////////////////////////////////////////////////////////
string strSql="select * from mytable";

#region Open connection
SqlConnection m_con = null;
m_con = new
SqlConnection("server=MyServer;database=MyDB;uid=s a;pwd=sa;");
m_con.Open();
#endregion

#region Create command
SqlCommand cmd = new SqlCommand(strSql,m_con);
cmd.CommandTimeout = 1000;
cmd.CommandType = CommandType.Text;
#endregion

#region Fill data set
SqlDataAdapter adapter=new SqlDataAdapter(cmd);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
#endregion

#region Loop over dataset
if(dataSet.Tables[0].Rows.Count 0)
{
foreach (DataRow reader in dataSet.Tables[0].Rows)
{
string szField1 = reader["field1"].ToString();
string szField2 = reader["field2"].ToString();
}
}
#endregion

#region Dispose dataset
dataSet.Clear();
dataSet.Dispose();
#endregion

#region Dispose Adapter and command
adapter.Dispose();
cmd.Dispose();
#endregion

#region Dispose connection object
m_con.Close();
m_con.Dispose();
m_con = null;
#endregion

/////////////////////////////////////////////////////END OF
CODE//////////////////////////////////////////////////////////
Jun 4 '07 #1
5 3345
First, .Net uses Connection Pooling, so as long as you close your
Connections, you don't need to worry about it.

Second, ensure that you close your Connections, even if an Exception occurs,
by employing a "using" statement, or try/catch/finally.

Third, a DataSet is a *disconnected* set of data. There is no reason not to
close the Connection immediately after filling the DataSet.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net
+
"Usman Jamil" <us***@advcomm.netwrote in message
news:O2**************@TK2MSFTNGP03.phx.gbl...
Hi

I've a class that creates a connection to a database, gets and loop on a
dataset given a query and then close the connection. When I use netstat
viewer to see if there is any connection open left, I always see that
there are 2 connections open and in "ESTABLISHED" state. Here is the piece
of code that I'm using, please tell where I'm doing it wrong. Since this
class is being used at many placed in my actual web based application that
uses it extensively, so the open connections grow alot, occupying most of
the ports of system and some time creating problem for other port based
applications like ftp.

Few things that I noted on debugging it line by line and monitoring from
netStats viewer.

1. On execution of m_con.Open, it shows 1 or sometimes 2 connections in
"Established" state. No idea why it shows 2 open connections, where it
should only be one.
2. If I only see one connection in established state after m_con.Open
statement, then the second connection in established state comes when i'm
looping over the dataset records. So at the end there are two connections
left open no matter what.
3. Disposing dataset, sqlcommand, sqladapter, or sqlconnection does'nt
have any effect on the state of the connections that are opened.
4. Somewhere on the net I read that the opened connections are not
disposed rather returned to a pool but in a non-established state to
improve performance, but the connection my application opens stay in
"established" state.
5. When I close my application, all the open and established connections
(two in my case) are deleted from the Netstat viewer utility, i.e. the
opened db sessions are closed on application exit.

Please check it and tell me where I'm making the mistake or how to release
the openend connection.

/////////////////////////////////////////////////////CODE//////////////////////////////////////////////////////////
string strSql="select * from mytable";

#region Open connection
SqlConnection m_con = null;
m_con = new
SqlConnection("server=MyServer;database=MyDB;uid=s a;pwd=sa;");
m_con.Open();
#endregion

#region Create command
SqlCommand cmd = new SqlCommand(strSql,m_con);
cmd.CommandTimeout = 1000;
cmd.CommandType = CommandType.Text;
#endregion

#region Fill data set
SqlDataAdapter adapter=new SqlDataAdapter(cmd);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
#endregion

#region Loop over dataset
if(dataSet.Tables[0].Rows.Count 0)
{
foreach (DataRow reader in dataSet.Tables[0].Rows)
{
string szField1 = reader["field1"].ToString();
string szField2 = reader["field2"].ToString();
}
}
#endregion

#region Dispose dataset
dataSet.Clear();
dataSet.Dispose();
#endregion

#region Dispose Adapter and command
adapter.Dispose();
cmd.Dispose();
#endregion

#region Dispose connection object
m_con.Close();
m_con.Dispose();
m_con = null;
#endregion

/////////////////////////////////////////////////////END OF
CODE//////////////////////////////////////////////////////////

Jun 4 '07 #2
On 4 Jun, 11:08, "Usman Jamil" <u...@advcomm.netwrote:
Hi

I've a class that creates a connection to a database, gets and loop on a
dataset given a query and then close the connection. When I use netstat
viewer to see if there is any connection open left, I always see that there
are 2 connections open and in "ESTABLISHED" state. Here is the piece of code
that I'm using, please tell where I'm doing it wrong. Since this class is
being used at many placed in my actual web based application that uses it
extensively, so the open connections grow alot, occupying most of the ports
of system and some time creating problem for other port based applications
like ftp.

Few things that I noted on debugging it line by line and monitoring from
netStats viewer.

1. On execution of m_con.Open, it shows 1 or sometimes 2 connections in
"Established" state. No idea why it shows 2 open connections, where it
should only be one.
2. If I only see one connection in established state after m_con.Open
statement, then the second connection in established state comes when i'm
looping over the dataset records. So at the end there are two connections
left open no matter what.
3. Disposing dataset, sqlcommand, sqladapter, or sqlconnection does'nt have
any effect on the state of the connections that are opened.
4. Somewhere on the net I read that the opened connections are not disposed
rather returned to a pool but in a non-established state to improve
performance, but the connection my application opens stay in "established"
state.
5. When I close my application, all the open and established connections
(two in my case) are deleted from the Netstat viewer utility, i.e. the
opened db sessions are closed on application exit.

Please check it and tell me where I'm making the mistake or how to release
the openend connection.

/////////////////////////////////////////////////////CODE//////////////////*////////////////////////////////////////
string strSql="select * from mytable";

#region Open connection
SqlConnection m_con = null;
m_con = new
SqlConnection("server=MyServer;database=MyDB;uid=s a;pwd=sa;");
m_con.Open();
#endregion

#region Create command
SqlCommand cmd = new SqlCommand(strSql,m_con);
cmd.CommandTimeout = 1000;
cmd.CommandType = CommandType.Text;
#endregion

#region Fill data set
SqlDataAdapter adapter=new SqlDataAdapter(cmd);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
#endregion

#region Loop over dataset
if(dataSet.Tables[0].Rows.Count 0)
{
foreach (DataRow reader in dataSet.Tables[0].Rows)
{
string szField1 = reader["field1"].ToString();
string szField2 = reader["field2"].ToString();
}
}
#endregion

#region Dispose dataset
dataSet.Clear();
dataSet.Dispose();
#endregion

#region Dispose Adapter and command
adapter.Dispose();
cmd.Dispose();
#endregion

#region Dispose connection object
m_con.Close();
m_con.Dispose();
m_con = null;
#endregion

/////////////////////////////////////////////////////END OF
CODE//////////////////////////////////////////////////////////
HI,

If you want then connection pooling can be disable by specifying
"pooling=false" in the connection string and then use either "using"
keyword for connection and adaptor object. I suggest to use the using
statement as it will call the dispose automatically even in case of
exception.

Jun 4 '07 #3
Hi Kevin

In my actuall application I am closing all the connections. The code is
between proper sections of try/catch statements and connection is being
closed in case of exceptions also. This piece of code is just a test code, I
wrote it just to seperate a single flow of execution of query. I have
debugged this test code and the Close statement does execute for the opened
connection, infact all the dispose,clear, close statements execute in this
test code application given the query and connection string correct. But
even when all these statements execute, I still am left with open
connections according to NetStat Viewer application. Since it shows me 2
open and established connection after one complete execution of this code.
That is my actual problem. As even if Dotnet does connection pooling, the
connection returned back to pool after a SqlConnection.Close() must be in a
TIME_WAIT state and not ESTABLISHED state. Hope I could explain to you what
my actual problem is, i.e. the state of connection stays established instead
of time_wait even after a close. Please note that these states are the ones
shown in Netstats.

Regards

Usman
"Kevin Spencer" <un**********@nothinks.comwrote in message
news:Oj**************@TK2MSFTNGP06.phx.gbl...
First, .Net uses Connection Pooling, so as long as you close your
Connections, you don't need to worry about it.

Second, ensure that you close your Connections, even if an Exception
occurs, by employing a "using" statement, or try/catch/finally.

Third, a DataSet is a *disconnected* set of data. There is no reason not
to close the Connection immediately after filling the DataSet.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net
+
"Usman Jamil" <us***@advcomm.netwrote in message
news:O2**************@TK2MSFTNGP03.phx.gbl...
>Hi

I've a class that creates a connection to a database, gets and loop on a
dataset given a query and then close the connection. When I use netstat
viewer to see if there is any connection open left, I always see that
there are 2 connections open and in "ESTABLISHED" state. Here is the
piece of code that I'm using, please tell where I'm doing it wrong. Since
this class is being used at many placed in my actual web based
application that uses it extensively, so the open connections grow alot,
occupying most of the ports of system and some time creating problem for
other port based applications like ftp.

Few things that I noted on debugging it line by line and monitoring from
netStats viewer.

1. On execution of m_con.Open, it shows 1 or sometimes 2 connections in
"Established" state. No idea why it shows 2 open connections, where it
should only be one.
2. If I only see one connection in established state after m_con.Open
statement, then the second connection in established state comes when i'm
looping over the dataset records. So at the end there are two connections
left open no matter what.
3. Disposing dataset, sqlcommand, sqladapter, or sqlconnection does'nt
have any effect on the state of the connections that are opened.
4. Somewhere on the net I read that the opened connections are not
disposed rather returned to a pool but in a non-established state to
improve performance, but the connection my application opens stay in
"established" state.
5. When I close my application, all the open and established connections
(two in my case) are deleted from the Netstat viewer utility, i.e. the
opened db sessions are closed on application exit.

Please check it and tell me where I'm making the mistake or how to
release the openend connection.

/////////////////////////////////////////////////////CODE//////////////////////////////////////////////////////////
string strSql="select * from mytable";

#region Open connection
SqlConnection m_con = null;
m_con = new
SqlConnection("server=MyServer;database=MyDB;uid= sa;pwd=sa;");
m_con.Open();
#endregion

#region Create command
SqlCommand cmd = new SqlCommand(strSql,m_con);
cmd.CommandTimeout = 1000;
cmd.CommandType = CommandType.Text;
#endregion

#region Fill data set
SqlDataAdapter adapter=new SqlDataAdapter(cmd);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
#endregion

#region Loop over dataset
if(dataSet.Tables[0].Rows.Count 0)
{
foreach (DataRow reader in dataSet.Tables[0].Rows)
{
string szField1 = reader["field1"].ToString();
string szField2 = reader["field2"].ToString();
}
}
#endregion

#region Dispose dataset
dataSet.Clear();
dataSet.Dispose();
#endregion

#region Dispose Adapter and command
adapter.Dispose();
cmd.Dispose();
#endregion

#region Dispose connection object
m_con.Close();
m_con.Dispose();
m_con = null;
#endregion

/////////////////////////////////////////////////////END OF
CODE//////////////////////////////////////////////////////////


Jun 4 '07 #4
Hi

I'm actually using this code in a web based application, where many
concurrent connections are expected all the time. So setting the pooling to
false is just not an option I can afford, keeping in mind the performance
degradation I will get.

"-pb-" <pr*********@gmail.comwrote in message
news:11**********************@o5g2000hsb.googlegro ups.com...
On 4 Jun, 11:08, "Usman Jamil" <u...@advcomm.netwrote:
Hi

I've a class that creates a connection to a database, gets and loop on a
dataset given a query and then close the connection. When I use netstat
viewer to see if there is any connection open left, I always see that
there
are 2 connections open and in "ESTABLISHED" state. Here is the piece of
code
that I'm using, please tell where I'm doing it wrong. Since this class is
being used at many placed in my actual web based application that uses it
extensively, so the open connections grow alot, occupying most of the
ports
of system and some time creating problem for other port based applications
like ftp.

Few things that I noted on debugging it line by line and monitoring from
netStats viewer.

1. On execution of m_con.Open, it shows 1 or sometimes 2 connections in
"Established" state. No idea why it shows 2 open connections, where it
should only be one.
2. If I only see one connection in established state after m_con.Open
statement, then the second connection in established state comes when i'm
looping over the dataset records. So at the end there are two connections
left open no matter what.
3. Disposing dataset, sqlcommand, sqladapter, or sqlconnection does'nt
have
any effect on the state of the connections that are opened.
4. Somewhere on the net I read that the opened connections are not
disposed
rather returned to a pool but in a non-established state to improve
performance, but the connection my application opens stay in "established"
state.
5. When I close my application, all the open and established connections
(two in my case) are deleted from the Netstat viewer utility, i.e. the
opened db sessions are closed on application exit.

Please check it and tell me where I'm making the mistake or how to release
the openend connection.

/////////////////////////////////////////////////////CODE//////////////////*////////////////////////////////////////
string strSql="select * from mytable";

#region Open connection
SqlConnection m_con = null;
m_con = new
SqlConnection("server=MyServer;database=MyDB;uid=s a;pwd=sa;");
m_con.Open();
#endregion

#region Create command
SqlCommand cmd = new SqlCommand(strSql,m_con);
cmd.CommandTimeout = 1000;
cmd.CommandType = CommandType.Text;
#endregion

#region Fill data set
SqlDataAdapter adapter=new SqlDataAdapter(cmd);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
#endregion

#region Loop over dataset
if(dataSet.Tables[0].Rows.Count 0)
{
foreach (DataRow reader in dataSet.Tables[0].Rows)
{
string szField1 = reader["field1"].ToString();
string szField2 = reader["field2"].ToString();
}
}
#endregion

#region Dispose dataset
dataSet.Clear();
dataSet.Dispose();
#endregion

#region Dispose Adapter and command
adapter.Dispose();
cmd.Dispose();
#endregion

#region Dispose connection object
m_con.Close();
m_con.Dispose();
m_con = null;
#endregion

/////////////////////////////////////////////////////END OF
CODE//////////////////////////////////////////////////////////
HI,

If you want then connection pooling can be disable by specifying
"pooling=false" in the connection string and then use either "using"
keyword for connection and adaptor object. I suggest to use the using
statement as it will call the dispose automatically even in case of
exception.
Jun 4 '07 #5
It's not a problem. Althogh I have not poked into the underlying network
operations that are performed by Connection Pooling, I have been using it
for years without any problems. Also, you mentioned that when your app
closed, the connections were cleaned up. What I suspect is a form of
"caching" is going on. The .Net platform gets a lot of performance boost by
avoiding repetetive operations that are costly. This is achieved by means of
a rather complex set of intelligent mechanisms like Connection Pooling that
monitor reusable objects that have been released without immediately
destroying them. A network database connection is expensive to establish,
particularly with regards to high-security database servers like SQL Server.
I imagine that if you were to watch these underlying connections long
enough, they would go away even without the application shutting down. In
any case, as I mentioned, from my experience, Connection Pooling works
beautifully in the .Net platform. The only exception is when Connection
classes are not properly closed and/or disposed. As long as the Connection
object is opened, your app has not relinquished control of it to the
platform.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net

"Usman Jamil" <us***@advcomm.netwrote in message
news:es**************@TK2MSFTNGP03.phx.gbl...
Hi Kevin

In my actuall application I am closing all the connections. The code is
between proper sections of try/catch statements and connection is being
closed in case of exceptions also. This piece of code is just a test code,
I wrote it just to seperate a single flow of execution of query. I have
debugged this test code and the Close statement does execute for the
opened connection, infact all the dispose,clear, close statements execute
in this test code application given the query and connection string
correct. But even when all these statements execute, I still am left with
open connections according to NetStat Viewer application. Since it shows
me 2 open and established connection after one complete execution of this
code. That is my actual problem. As even if Dotnet does connection
pooling, the connection returned back to pool after a
SqlConnection.Close() must be in a TIME_WAIT state and not ESTABLISHED
state. Hope I could explain to you what my actual problem is, i.e. the
state of connection stays established instead of time_wait even after a
close. Please note that these states are the ones shown in Netstats.

Regards

Usman
"Kevin Spencer" <un**********@nothinks.comwrote in message
news:Oj**************@TK2MSFTNGP06.phx.gbl...
>First, .Net uses Connection Pooling, so as long as you close your
Connections, you don't need to worry about it.

Second, ensure that you close your Connections, even if an Exception
occurs, by employing a "using" statement, or try/catch/finally.

Third, a DataSet is a *disconnected* set of data. There is no reason not
to close the Connection immediately after filling the DataSet.

--
HTH,

Kevin Spencer
Microsoft MVP

Printing Components, Email Components,
FTP Client Classes, Enhanced Data Controls, much more.
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net
+
"Usman Jamil" <us***@advcomm.netwrote in message
news:O2**************@TK2MSFTNGP03.phx.gbl...
>>Hi

I've a class that creates a connection to a database, gets and loop on a
dataset given a query and then close the connection. When I use netstat
viewer to see if there is any connection open left, I always see that
there are 2 connections open and in "ESTABLISHED" state. Here is the
piece of code that I'm using, please tell where I'm doing it wrong.
Since this class is being used at many placed in my actual web based
application that uses it extensively, so the open connections grow alot,
occupying most of the ports of system and some time creating problem for
other port based applications like ftp.

Few things that I noted on debugging it line by line and monitoring from
netStats viewer.

1. On execution of m_con.Open, it shows 1 or sometimes 2 connections in
"Established" state. No idea why it shows 2 open connections, where it
should only be one.
2. If I only see one connection in established state after m_con.Open
statement, then the second connection in established state comes when
i'm looping over the dataset records. So at the end there are two
connections left open no matter what.
3. Disposing dataset, sqlcommand, sqladapter, or sqlconnection does'nt
have any effect on the state of the connections that are opened.
4. Somewhere on the net I read that the opened connections are not
disposed rather returned to a pool but in a non-established state to
improve performance, but the connection my application opens stay in
"established" state.
5. When I close my application, all the open and established connections
(two in my case) are deleted from the Netstat viewer utility, i.e. the
opened db sessions are closed on application exit.

Please check it and tell me where I'm making the mistake or how to
release the openend connection.

/////////////////////////////////////////////////////CODE//////////////////////////////////////////////////////////
string strSql="select * from mytable";

#region Open connection
SqlConnection m_con = null;
m_con = new
SqlConnection("server=MyServer;database=MyDB;uid =sa;pwd=sa;");
m_con.Open();
#endregion

#region Create command
SqlCommand cmd = new SqlCommand(strSql,m_con);
cmd.CommandTimeout = 1000;
cmd.CommandType = CommandType.Text;
#endregion

#region Fill data set
SqlDataAdapter adapter=new SqlDataAdapter(cmd);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
#endregion

#region Loop over dataset
if(dataSet.Tables[0].Rows.Count 0)
{
foreach (DataRow reader in dataSet.Tables[0].Rows)
{
string szField1 = reader["field1"].ToString();
string szField2 = reader["field2"].ToString();
}
}
#endregion

#region Dispose dataset
dataSet.Clear();
dataSet.Dispose();
#endregion

#region Dispose Adapter and command
adapter.Dispose();
cmd.Dispose();
#endregion

#region Dispose connection object
m_con.Close();
m_con.Dispose();
m_con = null;
#endregion

/////////////////////////////////////////////////////END OF
CODE//////////////////////////////////////////////////////////



Jun 5 '07 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Mudge | last post by:
Hi, My hosting provider only allows me to use 50 connections to my MySQL database that my Web site will use. I don't know what this 50 connections means exactly. Does this mean that only 50...
6
by: Graham Mattingley | last post by:
Hello group, I have a question hope it does not turn out to be a silly on.... On everyone of my pages I have an a include page at the top and at the bottom of the page one is the database...
13
by: Lew | last post by:
Hi, I am a bit confused about what I'm seeing on my systems. I am trying to develop a script that will determine what percentage of the total log space is being used. If it is too high (80%)...
11
by: pradeep_TP | last post by:
Hi all, I have a few questions that I have been wanting to ask for long. These are all related to ADO.net and specifically to conenction to database. 1) If I have opened a connection to a...
14
by: Nick Gilbert | last post by:
Hi, I have an asp.net application which runs from a CD-ROM using Cassini. As such, it is single user only. The application connects to an Access database when it is loaded, and keeps the same...
3
by: Lal | last post by:
Dear All, I am seeking a valid suggestions from your side regarding the sql server performance. my connection object get initialized at the time of login. I remain connected throu out the...
1
by: Matik | last post by:
Hello 2 all, Maybe my question can be very stupid, but I'm a little confused. When I run sp_who on my database, I see one process (accessing remotely my database from another database on another...
35
by: Terry Jolly | last post by:
Web Solution Goal: Have a global database connection Why: (There will be 30+ tables, represented by 30+ classes) I only want to reference the database connection once. I put the connection...
1
by: Pradip | last post by:
Hello every body. I am new to this forum and also in Python. Read many things about multi threading in python. But still having problem. I am using Django Framework with Python having PostgreSQL...
1
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.