Unable to connect to the Sql server database
 

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

Re: Unable to connect to the Sql server database
 

hmmm... try removing provider=sqloledb
from your connection string
"Cailin" <Cailin@discussions.microsoft.com> wrote in message
news:6947DE7C-D7EA-448F-B19C-BD3B84FA180B@microsoft.com...
> 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

Re: Unable to connect to the Sql server database
 

Cailin try seeing some connectionstring here:-
http://www.connectionstrings.com/
Hope that helps
Patrick

"Clamps" <Clamps@Spamless.com> wrote in message
news:OOyYgPXtFHA.2072@TK2MSFTNGP14.phx.gbl...
> hmmm... try removing provider=sqloledb
> from your connection string
> "Cailin" <Cailin@discussions.microsoft.com> wrote in message
> news:6947DE7C-D7EA-448F-B19C-BD3B84FA180B@microsoft.com...
> > 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
>
>