"Marcus Vinícius" <marc.marcus@bol.com.br> wrote in message
news:u9ATARH1DHA.2156@TK2MSFTNGP12.phx.gbl...
> Hi Guys,
>
> I'm trying to using vs.net to conect a online SQL Server..
>
> Anybody Know how can I do it??
>
> Ps: The server adreess is a Ip number like a 200.178.123.20 and I have a
> user and a pwd registered in server. But when I trying to conect with sql,
> it returns the error "hm129 the Make sure that the machine name and path
are
> Valid"
>
>
> I don't know how can I do it?
>
> Thanks
>
> --
>
>
> -------------------------------------------------
> Marcus Vinícius M. Montezano
>
> Programador
>
> Digiexpress
> -------------------------------------------------
>
>

> Marcus,
>
> Check out this site here:
>
> http://www.able-consulting.com/ADO_Conn.htm
>
> They have a wealth of information on making connections. Your particular
> solution is (quoting from the referenced site):
>
> If connection to a remote server (via IP address):
>
> oSQLConn.ConnectionString = "Network Library=DBMSSOCN;" & _
> "Data Source=xxx.xxx.xxx.xxx,1433;" & _
> "Initial Catalog=mySQLServerDBName;" & _
> "User ID=myUsername;" & _
> "Password=myPassword"Hope this helps.
>
> bill burrows
>
> "Marcus Vinícius" <marc.marcus@bol.com.br> wrote in message
> news:u9ATARH1DHA.2156@TK2MSFTNGP12.phx.gbl...
> > Hi Guys,
> >
> > I'm trying to using vs.net to conect a online SQL Server..
> >
> > Anybody Know how can I do it??
> >
> > Ps: The server adreess is a Ip number like a 200.178.123.20 and I have
a
> > user and a pwd registered in server. But when I trying to conect with
sql,
> > it returns the error "hm129 the Make sure that the machine name and path
> are
> > Valid"
> >
> >
> > I don't know how can I do it?
> >
> > Thanks
> >
> > --
> >
> >
> > -------------------------------------------------
> > Marcus Vinícius M. Montezano
> >
> > Programador
> >
> > Digiexpress
> > -------------------------------------------------
> >
> >
>
>