VS 2003 + opening a connection to SQL SERVER 2000 database

[Jon Delano]

Hey all

I am building a new computer.
I have Windows XP Pro with SP2 and all the updates.

I installed VS 2003.
Then copied a project from my old computer to the new one.

When I try and run the project .. it errors out saying it "sql server does
not exist or access denied"

The connection string is obviously the exact same as when it ran on the old
computer ... as all the files came from the old computer ... where the
project works just fine.
The MSSQL server is running on a seperate computer all together.

I can open query analyzer and access the database, no problem. On the new
machine.
I can even use Tools .. Connect to Database ... in VS 2003 IDE and that
works ...

Just in my vb.net code is it failing .. and again .. it work just fine on
the old development machine.
Any ideas ??

Thanks
Jon

[Rick]

what is your string connection?

"Jon Delano" <jd*****@hotmai l.com> escribió en el mensaje
news:aq******** ************@co mcast.com...

Hey all

I am building a new computer.
I have Windows XP Pro with SP2 and all the updates.

I installed VS 2003.
Then copied a project from my old computer to the new one.

When I try and run the project .. it errors out saying it "sql server does
not exist or access denied"

The connection string is obviously the exact same as when it ran on the
old computer ... as all the files came from the old computer ... where the
project works just fine.
The MSSQL server is running on a seperate computer all together.

I can open query analyzer and access the database, no problem. On the new
machine.
I can even use Tools .. Connect to Database ... in VS 2003 IDE and that
works ...

Just in my vb.net code is it failing .. and again .. it work just fine on
the old development machine.
Any ideas ??

Thanks
Jon

[Greg Burns]

Is this a web app? What is does your connection string look like? Are you
connection to SQL using integrated security? Is it using trying to use your
local ASPNET account?

Greg
"Jon Delano" <jd*****@hotmai l.com> wrote in message
news:aq******** ************@co mcast.com...

Hey all

I am building a new computer.
I have Windows XP Pro with SP2 and all the updates.

I installed VS 2003.
Then copied a project from my old computer to the new one.

When I try and run the project .. it errors out saying it "sql server does
not exist or access denied"

The connection string is obviously the exact same as when it ran on the
old computer ... as all the files came from the old computer ... where the
project works just fine.
The MSSQL server is running on a seperate computer all together.

I can open query analyzer and access the database, no problem. On the new
machine.
I can even use Tools .. Connect to Database ... in VS 2003 IDE and that
works ...

Just in my vb.net code is it failing .. and again .. it work just fine on
the old development machine.
Any ideas ??

Thanks
Jon

[Greg Burns]

Sorry for the bad grammar. :^) Let's try that again.

Is this a web app? What does your connection string look like? Are you
connecting to SQL using integrated security? Is it trying to use your local
ASPNET account?

"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:OK******** ********@TK2MSF TNGP12.phx.gbl. ..

Is this a web app? What is does your connection string look like? Are you
connection to SQL using integrated security? Is it using trying to use
your local ASPNET account?

[Jon Delano]

Hello Thanks all for the quick replies ...

Here is the connection string as it sits in my web config file :
<add key="Repository ConnectionStrin g"
value="server=s erver;uid=sa;pw d=password;data base=ShepherdRe pository;Connec t
Timeout=120" />

Here is the code that is running ...

If Not IsPostBack Then

Dim cmdCheckReposit oryAvailability As New SqlCommand
Dim rdrCheckReposit oryAvailability As SqlDataReader
Dim Conn As SqlConnection

Try
' check the flag for repository availability
Dim SQL As String
Conn = New
SqlConnection(C onfigurationSet tings.AppSettin gs("RepositoryC onnectionString "))
Conn.Open()

SQL = "Select RepositoryAvail able from tblProperty"
cmdCheckReposit oryAvailability = New SqlCommand(SQL, Conn)
rdrCheckReposit oryAvailability =
cmdCheckReposit oryAvailability .ExecuteReader

If rdrCheckReposit oryAvailability .Read Then
If rdrCheckReposit oryAvailability ("RepositoryAva ilable")
= 0 Then
' its not available
txtUserName.Ena bled = False
txtPassword.Ena bled = False
btnLogin.Enable d = False

Label1.ForeColo r = Color.Blue
Label1.Font.Bol d = True
Label1.Font.Siz e = FontUnit.Medium
Label1.Text = "<center>Th e repository is unavailable
at this time.</center>"
End If
End If
Catch
txtUserName.Ena bled = False
txtPassword.Ena bled = False
btnLogin.Enable d = False

Label1.ForeColo r = Color.DarkBlue
Label1.Font.Bol d = True
Label1.Font.Siz e = FontUnit.Medium
Label1.Text = "<center>Th e repository is unavailable at this
time.</center>"
Finally

cmdCheckReposit oryAvailability .Dispose()
cmdCheckReposit oryAvailability = Nothing

If Not rdrCheckReposit oryAvailability Is Nothing Then
rdrCheckReposit oryAvailability .Close()
End If

rdrCheckReposit oryAvailability = Nothing

Conn.Close()
Conn = Nothing

End Try

This is a web application, I don't remember having to do anything special on
the old development machine to be able to connect to SQL Server.
As you can see I am using SQL Server Authentication (using sa is only in my
test network <grin>)

Thanks for any assistance, please let me know if there is anything else you
need.

Jon
jd*****@hotmail .com
"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:Oi******** ********@TK2MSF TNGP10.phx.gbl. ..

Sorry for the bad grammar. :^) Let's try that again.

Is this a web app? What does your connection string look like? Are you
connecting to SQL using integrated security? Is it trying to use your
local ASPNET account?

"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:OK******** ********@TK2MSF TNGP12.phx.gbl. ..

Is this a web app? What is does your connection string look like? Are
you connection to SQL using integrated security? Is it using trying to
use your local ASPNET account?

[Greg Burns]

I was not expecting to see sa being used. That definately eliminates a lot
of my theories. :^)

Only thing I have left to offer is perhaps XP SP2's firewall???

Greg

"Jon Delano" <jd*****@hotmai l.com> wrote in message
news:6v******** *************** *******@comcast .com...

Hello Thanks all for the quick replies ...

Here is the connection string as it sits in my web config file :
<add key="Repository ConnectionStrin g"
value="server=s erver;uid=sa;pw d=password;data base=ShepherdRe pository;Connec t
Timeout=120" />

Here is the code that is running ...

If Not IsPostBack Then

Dim cmdCheckReposit oryAvailability As New SqlCommand
Dim rdrCheckReposit oryAvailability As SqlDataReader
Dim Conn As SqlConnection

Try
' check the flag for repository availability
Dim SQL As String
Conn = New
SqlConnection(C onfigurationSet tings.AppSettin gs("RepositoryC onnectionString "))
Conn.Open()

SQL = "Select RepositoryAvail able from tblProperty"
cmdCheckReposit oryAvailability = New SqlCommand(SQL, Conn)
rdrCheckReposit oryAvailability =
cmdCheckReposit oryAvailability .ExecuteReader

If rdrCheckReposit oryAvailability .Read Then
If
rdrCheckReposit oryAvailability ("RepositoryAva ilable") = 0 Then
' its not available
txtUserName.Ena bled = False
txtPassword.Ena bled = False
btnLogin.Enable d = False

Label1.ForeColo r = Color.Blue
Label1.Font.Bol d = True
Label1.Font.Siz e = FontUnit.Medium
Label1.Text = "<center>Th e repository is
unavailable at this time.</center>"
End If
End If
Catch
txtUserName.Ena bled = False
txtPassword.Ena bled = False
btnLogin.Enable d = False

Label1.ForeColo r = Color.DarkBlue
Label1.Font.Bol d = True
Label1.Font.Siz e = FontUnit.Medium
Label1.Text = "<center>Th e repository is unavailable at
this time.</center>"
Finally

cmdCheckReposit oryAvailability .Dispose()
cmdCheckReposit oryAvailability = Nothing

If Not rdrCheckReposit oryAvailability Is Nothing Then
rdrCheckReposit oryAvailability .Close()
End If

rdrCheckReposit oryAvailability = Nothing

Conn.Close()
Conn = Nothing

End Try

This is a web application, I don't remember having to do anything special
on the old development machine to be able to connect to SQL Server.
As you can see I am using SQL Server Authentication (using sa is only in
my test network <grin>)

Thanks for any assistance, please let me know if there is anything else
you need.

Jon
jd*****@hotmail .com
"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:Oi******** ********@TK2MSF TNGP10.phx.gbl. ..

Sorry for the bad grammar. :^) Let's try that again.

Is this a web app? What does your connection string look like? Are you
connecting to SQL using integrated security? Is it trying to use your
local ASPNET account?

"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:OK******** ********@TK2MSF TNGP12.phx.gbl. ..

Is this a web app? What is does your connection string look like? Are
you connection to SQL using integrated security? Is it using trying to
use your local ASPNET account?

[Jon Delano]

Oh yeah ... the server that sql server 2000 is running on is Windows 2000

"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:Oi******** ********@TK2MSF TNGP10.phx.gbl. ..

Sorry for the bad grammar. :^) Let's try that again.

Is this a web app? What does your connection string look like? Are you
connecting to SQL using integrated security? Is it trying to use your
local ASPNET account?

"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:OK******** ********@TK2MSF TNGP12.phx.gbl. ..

Is this a web app? What is does your connection string look like? Are
you connection to SQL using integrated security? Is it using trying to
use your local ASPNET account?

[Jon Delano]

I checked that ... I have it off .. as I am using NAT and am behind a
router.
The server I am connecting to is behind the router as well.

This is so strange ...
"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:%2******** *********@TK2MS FTNGP09.phx.gbl ...

I was not expecting to see sa being used. That definately eliminates a lot
of my theories. :^)

Only thing I have left to offer is perhaps XP SP2's firewall???

Greg

"Jon Delano" <jd*****@hotmai l.com> wrote in message
news:6v******** *************** *******@comcast .com...

Hello Thanks all for the quick replies ...

Here is the connection string as it sits in my web config file :
<add key="Repository ConnectionStrin g"
value="server=s erver;uid=sa;pw d=password;data base=ShepherdRe pository;Connec t
Timeout=120" />

Here is the code that is running ...

If Not IsPostBack Then

Dim cmdCheckReposit oryAvailability As New SqlCommand
Dim rdrCheckReposit oryAvailability As SqlDataReader
Dim Conn As SqlConnection

Try
' check the flag for repository availability
Dim SQL As String
Conn = New
SqlConnection(C onfigurationSet tings.AppSettin gs("RepositoryC onnectionString "))
Conn.Open()

SQL = "Select RepositoryAvail able from tblProperty"
cmdCheckReposit oryAvailability = New SqlCommand(SQL, Conn)
rdrCheckReposit oryAvailability =
cmdCheckReposit oryAvailability .ExecuteReader

If rdrCheckReposit oryAvailability .Read Then
If
rdrCheckReposit oryAvailability ("RepositoryAva ilable") = 0 Then
' its not available
txtUserName.Ena bled = False
txtPassword.Ena bled = False
btnLogin.Enable d = False

Label1.ForeColo r = Color.Blue
Label1.Font.Bol d = True
Label1.Font.Siz e = FontUnit.Medium
Label1.Text = "<center>Th e repository is
unavailable at this time.</center>"
End If
End If
Catch
txtUserName.Ena bled = False
txtPassword.Ena bled = False
btnLogin.Enable d = False

Label1.ForeColo r = Color.DarkBlue
Label1.Font.Bol d = True
Label1.Font.Siz e = FontUnit.Medium
Label1.Text = "<center>Th e repository is unavailable at
this time.</center>"
Finally

cmdCheckReposit oryAvailability .Dispose()
cmdCheckReposit oryAvailability = Nothing

If Not rdrCheckReposit oryAvailability Is Nothing Then
rdrCheckReposit oryAvailability .Close()
End If

rdrCheckReposit oryAvailability = Nothing

Conn.Close()
Conn = Nothing

End Try

This is a web application, I don't remember having to do anything special
on the old development machine to be able to connect to SQL Server.
As you can see I am using SQL Server Authentication (using sa is only in
my test network <grin>)

Thanks for any assistance, please let me know if there is anything else
you need.

Jon
jd*****@hotmail .com
"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:Oi******** ********@TK2MSF TNGP10.phx.gbl. ..

Sorry for the bad grammar. :^) Let's try that again.

Is this a web app? What does your connection string look like? Are you
connecting to SQL using integrated security? Is it trying to use your
local ASPNET account?

"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:OK******** ********@TK2MSF TNGP12.phx.gbl. ..
Is this a web app? What is does your connection string look like? Are
you connection to SQL using integrated security? Is it using trying to
use your local ASPNET account?

[Greg Burns]

You say you are getting "sql server does not exist or access denied", but I
don't see where you are recording the error in your catch statement. How
can you tell what the error is from the code you posted?

Try
....
Catch ex as exception
trace.warn(ex.t ostring)
...
Finally
....
End Try

Change your catch to something like that. You could, of course, put a
breakpoint on the catch statement itself and take a look ex's value.

Greg
"Jon Delano" <jd*****@hotmai l.com> wrote in message
news:ZO******** ************@co mcast.com...

Oh yeah ... the server that sql server 2000 is running on is Windows 2000

"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:Oi******** ********@TK2MSF TNGP10.phx.gbl. ..

Sorry for the bad grammar. :^) Let's try that again.

Is this a web app? What does your connection string look like? Are you
connecting to SQL using integrated security? Is it trying to use your
local ASPNET account?

"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:OK******** ********@TK2MSF TNGP12.phx.gbl. ..

Is this a web app? What is does your connection string look like? Are
you connection to SQL using integrated security? Is it using trying to
use your local ASPNET account?

[Jon Delano]

In VS 2003 ... I had changed the catch to catch ex as exception ...
Then put a break point in that section ... when it stopped there ... I did a
quick watch on ex ...
"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:uM******** ********@TK2MSF TNGP12.phx.gbl. ..

You say you are getting "sql server does not exist or access denied", but
I don't see where you are recording the error in your catch statement.
How can you tell what the error is from the code you posted?

Try
...
Catch ex as exception
trace.warn(ex.t ostring)
...
Finally
...
End Try

Change your catch to something like that. You could, of course, put a
breakpoint on the catch statement itself and take a look ex's value.

Greg
"Jon Delano" <jd*****@hotmai l.com> wrote in message
news:ZO******** ************@co mcast.com...

Oh yeah ... the server that sql server 2000 is running on is Windows 2000

"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:Oi******** ********@TK2MSF TNGP10.phx.gbl. ..

Sorry for the bad grammar. :^) Let's try that again.

Is this a web app? What does your connection string look like? Are you
connecting to SQL using integrated security? Is it trying to use your
local ASPNET account?

"Greg Burns" <bl*******@news groups.nospam> wrote in message
news:OK******** ********@TK2MSF TNGP12.phx.gbl. ..
Is this a web app? What is does your connection string look like? Are
you connection to SQL using integrated security? Is it using trying to
use your local ASPNET account?