Unable to connect to the Sql server database

G

Guest

hi all,
I can't connect to the Sql server database, and I see this error message:
"BC30519: Overload resolution failed because no accessible 'New' can be
called without a narrowing conversion" on the code below with "Here is the
error code ->". Do anyone know how to fix it! Here is the code

sub Page_Load

dim myConnection as New SqlConnection("Provider=sqloledb;Data
Source=sss3333;Initial Catalog=eDB;User Id=eeee;Password=eeee;")

"Here is the error code ->" dim myCommand as New SqlDataAdapter("SELECT
symbol_id, symbol_name FROM d_symbol", myConnection)

sqlDataReader=myCommand.ExecuteReader()
listbox1.DataSource = sqlDataReader
listbox1.DataBind()
sqlDataReader.Close()

myConnection.Close()

end sub

Thanks
Cailin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,743
Messages
2,569,478
Members
44,898
Latest member
BlairH7607

Latest Threads

Top