exceeding database connections

[noname]

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:

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?

 

[kishorebarik26]

No friend there is no error!!!!!!!!!!!!!!!