would the following code and process cause database to deny access/exceed connections?
create connection
set sql statement
open connection with sql
put results into data set
close connection
see code:
Missing something funamental?
create connection
set sql statement
open connection with sql
put results into data set
close connection
see code:
VB.NET:
dbCon.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = " & vmdbfile
sql = "SELECT * FROM TABLES"
'data adapter
da = New OleDbDataAdapter(sql, dbCon)
da.Fill(ds, "pie")
dbCon.Close
Missing something funamental?