connection string problem

G'd evening!!
I had been trying to find out how can i connect my ppc to my sql server over
the internet. I had been trying to do it in the same way i do it with PC's
like this:
**************************
Dim strSQL As String
Dim cnn As SqlConnection

strSQL = "Network Library=DBMSSOCN;" & _
"Data Source=<<IP address>>,<<PortNumber>>;" & _
"Initial Catalog=<<DbName>>;" & _
"User ID=xxxxxx;" & _
"Pwd=xxxxxxxxx"
****************************
For the ppc FE i just switch to the SqlServerCe library, but i always get an
error from my device saying that is an error in my connection string in the
"Network Library". I really can't find out which is the sintax i must use.
I would appreciate if some one can help me out with this. i'm pretty new to
the compact framework and any help will be more than welcome.
Regards
Estuardo
--
Don't ask why, ask how...

luismolinaMicasoft
Tue Jan 04 09:33:08 CST 2005

hi, try this

'Connect to SQL 2000
Dim rdaOleDbConnectString As String = _
"Provider=sqloledb; Data Source=" & cc.dbRemoteServer &
";Initial" & _
" Catalog=" & cc.dbRemoteName & ";User Id=" &
cc.dbRemoteLogin & ";Password=" & cc.dbRemotePassword


"Estuardo" escribió:

> G'd evening!!
> I had been trying to find out how can i connect my ppc to my sql server over
> the internet. I had been trying to do it in the same way i do it with PC's
> like this:
> **************************
> Dim strSQL As String
> Dim cnn As SqlConnection
>
> strSQL = "Network Library=DBMSSOCN;" & _
> "Data Source=<<IP address>>,<<PortNumber>>;" & _
> "Initial Catalog=<<DbName>>;" & _
> "User ID=xxxxxx;" & _
> "Pwd=xxxxxxxxx"
> ****************************
> For the ppc FE i just switch to the SqlServerCe library, but i always get an
> error from my device saying that is an error in my connection string in the
> "Network Library". I really can't find out which is the sintax i must use.
> I would appreciate if some one can help me out with this. i'm pretty new to
> the compact framework and any help will be more than welcome.
> Regards
> Estuardo
> --
> Don't ask why, ask how...

estuardo_ommitthis
Tue Jan 04 15:37:08 CST 2005

Hello Luis!!
First of all thanks for your reply. I'd tryed your sugestion with no luck,
but i could find the way to do it.
***********************
strCnn = "packet size=4096;" & _
"Data Source= <IP Address>,<PortNumber>;" & _
"Initial Catalog=<DBName>;" & _
"User ID=<Login>;" & _
"Pwd=<Password>"
**************************
I don't understand way it works without specify a provider and/or network
library. After so many attempts and by "mistake" i found this solution.
I hope it helps others that may face the same problem.
Regards
Estuardo
"luis molina Micasoft" wrote:

> hi, try this
>
> 'Connect to SQL 2000
> Dim rdaOleDbConnectString As String = _
> "Provider=sqloledb; Data Source=" & cc.dbRemoteServer &
> ";Initial" & _
> " Catalog=" & cc.dbRemoteName & ";User Id=" &
> cc.dbRemoteLogin & ";Password=" & cc.dbRemotePassword
>
>
> "Estuardo" escribió:
>
> > G'd evening!!
> > I had been trying to find out how can i connect my ppc to my sql server over
> > the internet. I had been trying to do it in the same way i do it with PC's
> > like this:
> > **************************
> > Dim strSQL As String
> > Dim cnn As SqlConnection
> >
> > strSQL = "Network Library=DBMSSOCN;" & _
> > "Data Source=<<IP address>>,<<PortNumber>>;" & _
> > "Initial Catalog=<<DbName>>;" & _
> > "User ID=xxxxxx;" & _
> > "Pwd=xxxxxxxxx"
> > ****************************
> > For the ppc FE i just switch to the SqlServerCe library, but i always get an
> > error from my device saying that is an error in my connection string in the
> > "Network Library". I really can't find out which is the sintax i must use.
> > I would appreciate if some one can help me out with this. i'm pretty new to
> > the compact framework and any help will be more than welcome.
> > Regards
> > Estuardo
> > --
> > Don't ask why, ask how...