Connection to SQL remote server

I'm using vb.net to connect to a MSDE 2000 database on a remote server.
While in VB.NET, I'm able to view data using Server Explorer. In addition,
I've configured an ODBCDATAADAPTER that fills the dataset under preview data.
When I tried to retrieve data through webform/datagrid I get the error
"ERROR [08001] [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server
does not exist or access denied. ERROR [01000] [Microsoft][ODBC SQL Server
Driver][Named Pipes]ConnectionOpen (Connect())."
I created a system dsn to connect to remote server. Test connection
succeeded. Any ideas what's wrong?
Hutty
The connection string I'm using in vb.net is
Dim Conn As New SqlConnection("Persist Security Info=False;Data
Source=INTL_INSTANCE;Extended
Properties=DSN=INTL_INSTANCE;UID=Hutty;APP=Microso ft? Visual Studio
..NET;WSID=CUI0113;DATABASE=Hutty;Network=DBNMPNTW ;Address=\\INTL\pipe\MSSQL$MYINSTANCE\sql\query;Tr usted_Connection=Yes;Initial Catalog=Hutty")
Hutty
"Hutty" wrote:

> I'm using vb.net to connect to a MSDE 2000 database on a remote server.
> While in VB.NET, I'm able to view data using Server Explorer. In addition,
> I've configured an ODBCDATAADAPTER that fills the dataset under preview data.
> When I tried to retrieve data through webform/datagrid I get the error
> "ERROR [08001] [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server
> does not exist or access denied. ERROR [01000] [Microsoft][ODBC SQL Server
> Driver][Named Pipes]ConnectionOpen (Connect())."
> I created a system dsn to connect to remote server. Test connection
> succeeded. Any ideas what's wrong?
> --
> Hutty
|||I have the same problem.
I want to connect to a SQL server with this connection string:
Dim Conn As New SqlConnection( "Data Source=83.240.161.155;
User Id=sa;password=;Initial Catalog=Avaliacao Desempenho")
Any help?
Ze
"Hutty" wrote:
[vbcol=seagreen]
> The connection string I'm using in vb.net is
> Dim Conn As New SqlConnection("Persist Security Info=False;Data
> Source=INTL_INSTANCE;Extended
> Properties=DSN=INTL_INSTANCE;UID=Hutty;APP=Microso ft? Visual Studio
> .NET;WSID=CUI0113;DATABASE=Hutty;Network=DBNMPNTW; Address=\\INTL\pipe\MSSQL$MYINSTANCE\sql\query;Tru sted_Connection=Yes;Initial Catalog=Hutty")
> --
> Hutty
>
> "Hutty" wrote: