SqlClient remote connection problems

[Tony Zoccolillo]

I have a SQL Server database on a Windows 2000 Server. I have IIS running
on a 2nd 2000 Server with no SQL Server on it.. Neither are the PDC. Both
servers have the most recent .NET framework installed.

When I try to connect from my aspx page using SqlClient I get an error right
away. My code looks something like...

Imports System.Data.Sql Client

Dim Conn2 As New SqlClient.SqlCo nnection("Data
Source=10.10.10 .101,1433;Initi al Catalog=MapLaye rs; UID=coresqluser ;
PWD=OeQu_!102")
Dim cmd As SqlClient.SqlCo mmand
Dim objDataReader As SqlClient.SqlDa taReader
Dim strSQL As String
Dim basename As String
Dim appt As String
Dim last_upd As String
Dim n As Integer

appt = Request.QuerySt ring("atype")
basename = Request.QuerySt ring("thebase")

Conn2.Open()

strSQL = "SELECT * from site_name WHERE site_name.site_ id = '" & basename &
"';"
cmd = New SqlClient.SqlCo mmand(strSQL, Conn2)
objDataReader = cmd.ExecuteRead er
It errors on the "Imports" line....If I remove it, I get am error on the
first DIM. It seems the problem is with the SqlClient class. If I put .NET
framework on a machine without SQL Server, are these connectors installed?

Any ideas or suggestions would be appreciated,

Tony Zoccolillo

[Tony Zoccolillo]

This line should read...

Source=10.10.10 .101,1433;Initi al Catalog=MapLaye rs; User ID=coresqluser;
Password=OeQu_! 102")


"Tony Zoccolillo" <to*****@hotmai l.com> wrote in message
news:uN******** **********@tk2m sftngp13.phx.gb l...

I have a SQL Server database on a Windows 2000 Server. I have IIS running
on a 2nd 2000 Server with no SQL Server on it.. Neither are the PDC. Both servers have the most recent .NET framework installed.

When I try to connect from my aspx page using SqlClient I get an error right away. My code looks something like...

Imports System.Data.Sql Client

Dim Conn2 As New SqlClient.SqlCo nnection("Data
Source=10.10.10 .101,1433;Initi al Catalog=MapLaye rs; UID=coresqluser ;
PWD=OeQu_!102")
Dim cmd As SqlClient.SqlCo mmand
Dim objDataReader As SqlClient.SqlDa taReader
Dim strSQL As String
Dim basename As String
Dim appt As String
Dim last_upd As String
Dim n As Integer

appt = Request.QuerySt ring("atype")
basename = Request.QuerySt ring("thebase")

Conn2.Open()

strSQL = "SELECT * from site_name WHERE site_name.site_ id = '" & basename & "';"
cmd = New SqlClient.SqlCo mmand(strSQL, Conn2)
objDataReader = cmd.ExecuteRead er
It errors on the "Imports" line....If I remove it, I get am error on the
first DIM. It seems the problem is with the SqlClient class. If I put ..NET framework on a machine without SQL Server, are these connectors installed?

Any ideas or suggestions would be appreciated,

Tony Zoccolillo

[Rick Spiewak]

Have you set a reference to the .dll? If so, perhaps you should set it to
make a local copy, as a workaround.

"Tony Zoccolillo" <to*****@hotmai l.com> wrote in message
news:Ob******** ********@TK2MSF TNGP11.phx.gbl. ..

This line should read...

Source=10.10.10 .101,1433;Initi al Catalog=MapLaye rs; User ID=coresqluser;
Password=OeQu_! 102")


"Tony Zoccolillo" <to*****@hotmai l.com> wrote in message
news:uN******** **********@tk2m sftngp13.phx.gb l...

I have a SQL Server database on a Windows 2000 Server. I have IIS running on a 2nd 2000 Server with no SQL Server on it.. Neither are the PDC. Both

servers have the most recent .NET framework installed.

When I try to connect from my aspx page using SqlClient I get an error

right

away. My code looks something like...

Imports System.Data.Sql Client

Dim Conn2 As New SqlClient.SqlCo nnection("Data
Source=10.10.10 .101,1433;Initi al Catalog=MapLaye rs; UID=coresqluser ;
PWD=OeQu_!102")
Dim cmd As SqlClient.SqlCo mmand
Dim objDataReader As SqlClient.SqlDa taReader
Dim strSQL As String
Dim basename As String
Dim appt As String
Dim last_upd As String
Dim n As Integer

appt = Request.QuerySt ring("atype")
basename = Request.QuerySt ring("thebase")

Conn2.Open()

strSQL = "SELECT * from site_name WHERE site_name.site_ id = '" & basename &

"';"
cmd = New SqlClient.SqlCo mmand(strSQL, Conn2)
objDataReader = cmd.ExecuteRead er
It errors on the "Imports" line....If I remove it, I get am error on the
first DIM. It seems the problem is with the SqlClient class. If I put

.NET

framework on a machine without SQL Server, are these connectors

installed?
Any ideas or suggestions would be appreciated,

Tony Zoccolillo

[Tony Zoccolillo]

I'm fairly new to .NET and I 'm not 100% sure what you mean. I have a
reference to System, System.Data, System.Design, System.Drawing, System.Web,
System.Windows. Forms and System.XML. Copy Local is False on all. If I set
Copy Local to true, will it put the dlls in my bin and distributed when I
copy remote? Shouldn't these refs already be on a system with .NET
Framework installed?

thanks,
TZ
"Rick Spiewak" <ri*********@mi ndspring.com> wrote in message
news:eA******** ********@TK2MSF TNGP10.phx.gbl. ..

Have you set a reference to the .dll? If so, perhaps you should set it to
make a local copy, as a workaround.

"Tony Zoccolillo" <to*****@hotmai l.com> wrote in message
news:Ob******** ********@TK2MSF TNGP11.phx.gbl. ..

This line should read...

Source=10.10.10 .101,1433;Initi al Catalog=MapLaye rs; User ID=coresqluser;
Password=OeQu_! 102")


"Tony Zoccolillo" <to*****@hotmai l.com> wrote in message
news:uN******** **********@tk2m sftngp13.phx.gb l...

I have a SQL Server database on a Windows 2000 Server. I have IIS running on a 2nd 2000 Server with no SQL Server on it.. Neither are the PDC.

Both

servers have the most recent .NET framework installed.

When I try to connect from my aspx page using SqlClient I get an error

right

away. My code looks something like...

Imports System.Data.Sql Client

Dim Conn2 As New SqlClient.SqlCo nnection("Data
Source=10.10.10 .101,1433;Initi al Catalog=MapLaye rs; UID=coresqluser ;
PWD=OeQu_!102")
Dim cmd As SqlClient.SqlCo mmand
Dim objDataReader As SqlClient.SqlDa taReader
Dim strSQL As String
Dim basename As String
Dim appt As String
Dim last_upd As String
Dim n As Integer

appt = Request.QuerySt ring("atype")
basename = Request.QuerySt ring("thebase")

Conn2.Open()

strSQL = "SELECT * from site_name WHERE site_name.site_ id = '" & basename

&

"';"
cmd = New SqlClient.SqlCo mmand(strSQL, Conn2)
objDataReader = cmd.ExecuteRead er
It errors on the "Imports" line....If I remove it, I get am error on the first DIM. It seems the problem is with the SqlClient class. If I

put .NET

framework on a machine without SQL Server, are these connectors

installed?
Any ideas or suggestions would be appreciated,

Tony Zoccolillo