Connection to SQL remote server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hutty - 07 Jul 2005 17:08 GMT

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?

Signature

Hutty

Reply to this Message

Hutty - 07 Jul 2005 18:57 GMT

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=Microsoft® Visual Studio
.NET;WSID=CUI0113;DATABASE=Hutty;Network=DBNMPNTW;Address=\\INTL\pipe\MSSQL$MYINSTANCE\sql\query;Trusted_Connection=Yes;Initial Catalog=Hutty")

Signature

Hutty

> 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,
[quoted text clipped - 6 lines]
> I created a system dsn to connect to remote server. Test connection
> succeeded. Any ideas what's wrong?

Reply to this Message

Ze Rui - 14 Jul 2005 09:59 GMT

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

> The connection string I'm using in vb.net is
>
[quoted text clipped - 13 lines]
> > I created a system dsn to connect to remote server. Test connection
> > succeeded. Any ideas what's wrong?

Reply to this Message