ExamGuru IT/.Net Guru : SV: RE: SV: sql server connection on ASPFriends.com 'ngfx-sqlclient' list

.NETGURU

SV: RE: SV: sql server connection

Messages

Related Types

This message was discovered on ASPFriends.com 'ngfx-sqlclient' list.

=?iso-8859-1?Q?Andr=E9_Colbi=F6rnsen?=

That's no problem. You may well connect to a SQL-Server remotely like
this.

Regards/Halsningar

Andre Colbiornsen
--------------------------------------
Sonnenburg Communications
Bergsgatan 3,
SE-211 54 Malm=F6
Sweden
Tel.: +46-(0)40-97 78 80
Fax.: +46-(0)40-97 78 80
Mob.: +46-(0)708-97 78 79
Mail: Click here to reveal e-mail address
Web.: www.sonnenburg.se
----------------------------------------
B2B Web Solutions - Specializing in .Net
----------------------------------------

-----Ursprungligt meddelande-----
Fr=E5n: Graham Dobson [mailto:Click here to reveal e-mail address]=20
Skickat: den 12 juli 2002 13:15
Till: ngfx-sqlclient
=C4mne: [ngfx-sqlclient] RE: SV: sql server connection

I could be way off here but usually I see the string looking like this
"Data Source=3Dservername;Database=3Dpubs;UID=3Dsa;pwd=3D;". It seems =
to me you
have a partial url for your server name. Does this mean you are using
http to try and access SQL server? The SQLClient .NET access is through
SQL Server's native tabular data stream protocol so I think this would
be problematic. I haven't seen SQL server exposing it's data store or
native protocol in this way (over http) before.

Graham

-----Original Message-----
From: Andr=E9 Colbi=F6rnsen [mailto:Click here to reveal e-mail address]
Sent: Friday, July 12, 2002 3:52 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] SV: sql server connection

I thought a SQL server connection string should look like this:

Dim objConn As New
SqlConnection("Server=3Dsqlserver.quotamais.com.br;UID=3Dquotamais;PWD=3D=
webQ2
602";Database=3Dquotamais)

Regards/Halsningar

Andre Colbiornsen
--------------------------------------
Sonnenburg Communications
Bergsgatan 3,
SE-211 54 Malm=F6
Sweden
Tel.: +46-(0)40-97 78 80
Fax.: +46-(0)40-97 78 80
Mob.: +46-(0)708-97 78 79
Mail: Click here to reveal e-mail address
Web.: www.sonnenburg.se
----------------------------------------
B2B Web Solutions - Specializing in .Net
----------------------------------------

-----Ursprungligt meddelande-----
Fr=E5n: Giovani [mailto:Click here to reveal e-mail address]
Skickat: den 11 juli 2002 18:18
Till: ngfx-sqlclient
=C4mne: [ngfx-sqlclient] sql server connection

-- Moved from [aspngfreeforall] to [ngfx-sqlclient] by Tony Stark
<Click here to reveal e-mail address> --

I=B4m trying to make a connection with sql server. Follow the code:

Dim objConn As New SqlConnection("Server =3D sqlserver.quotamais.com.br;
Database =3D quotamais; User ID =3D quotamais; Password =3D webQ2602")

Dim strSql As String =3D "SELECT id FROM adm_user WHERE login =3D =
@userName
AND senha =3D @password"

Dim objCmd As New SqlCommand(strSql, objConn)

objConn.Open()

The error message that I receive when the Open method is executed is:

"SQL Server does not exist or access denied."

Do I need to add more information on ConnectionString?

Giovani.
| [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR ID=20
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D JOIN/QUIT

| [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR ID=20
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D JOIN/QUIT

| [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR ID=20
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D JOIN/QUIT

Reply to this message...

Graham Dobson

Yes, sorry I found this in an article called ".NET Data Access Architecture
Guide" by Alex Mackman, Chris Brooks, Steve Busby, and Ed Jezierski from Oct
2001, and on the April 2002 MSDN Library.
Could the port number be the problem?
Specifying a Port
If your instance of SQL Server is configured to listen on a port other than
the default 1433, you can specify the port number to connect to, by:

Using the Client Network Utility.
Specifying the port number with the "Server" or "Data Source" name-value
pair supplied to the connection string. Use a string with the following
format:
"Data Source=ServerName,PortNumber"

Note ServerName might be an IP address or Domain Name System (DNS) name.
For optimum performance, use an IP address to avoid a DNS lookup.

Graham

-----Original Message-----
From: André Colbiörnsen [mailto:Click here to reveal e-mail address]
Sent: Friday, July 12, 2002 7:15 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] SV: RE: SV: sql server connection

That's no problem. You may well connect to a SQL-Server remotely like
this.

Regards/Halsningar

Andre Colbiornsen
--------------------------------------
Sonnenburg Communications
Bergsgatan 3,
SE-211 54 Malmö
Sweden
Tel.: +46-(0)40-97 78 80
Fax.: +46-(0)40-97 78 80
Mob.: +46-(0)708-97 78 79
Mail: Click here to reveal e-mail address
Web.: www.sonnenburg.se
----------------------------------------
B2B Web Solutions - Specializing in .Net
----------------------------------------

-----Ursprungligt meddelande-----
Från: Graham Dobson [mailto:Click here to reveal e-mail address]
Skickat: den 12 juli 2002 13:15
Till: ngfx-sqlclient
Ämne: [ngfx-sqlclient] RE: SV: sql server connection

I could be way off here but usually I see the string looking like this
"Data Source=servername;Database=pubs;UID=sa;pwd=;". It seems to me you
have a partial url for your server name. Does this mean you are using
http to try and access SQL server? The SQLClient .NET access is through
SQL Server's native tabular data stream protocol so I think this would
be problematic. I haven't seen SQL server exposing it's data store or
native protocol in this way (over http) before.

Graham

-----Original Message-----
From: André Colbiörnsen [mailto:Click here to reveal e-mail address]
Sent: Friday, July 12, 2002 3:52 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] SV: sql server connection

I thought a SQL server connection string should look like this:

Dim objConn As New
SqlConnection("Server=sqlserver.quotamais.com.br;UID=quotamais;PWD=webQ2
602";Database=quotamais)

Regards/Halsningar

Andre Colbiornsen
--------------------------------------
Sonnenburg Communications
Bergsgatan 3,
SE-211 54 Malmö
Sweden
Tel.: +46-(0)40-97 78 80
Fax.: +46-(0)40-97 78 80
Mob.: +46-(0)708-97 78 79
Mail: Click here to reveal e-mail address
Web.: www.sonnenburg.se
----------------------------------------
B2B Web Solutions - Specializing in .Net
----------------------------------------

-----Ursprungligt meddelande-----
Från: Giovani [mailto:Click here to reveal e-mail address]
Skickat: den 11 juli 2002 18:18
Till: ngfx-sqlclient
Ämne: [ngfx-sqlclient] sql server connection

-- Moved from [aspngfreeforall] to [ngfx-sqlclient] by Tony Stark
<Click here to reveal e-mail address> --

I´m trying to make a connection with sql server. Follow the code:

Dim objConn As New SqlConnection("Server = sqlserver.quotamais.com.br;
Database = quotamais; User ID = quotamais; Password = webQ2602")

Dim strSql As String = "SELECT id FROM adm_user WHERE login = @userName
AND senha = @password"

Dim objCmd As New SqlCommand(strSql, objConn)

objConn.Open()

The error message that I receive when the Open method is executed is:

"SQL Server does not exist or access denied."

Do I need to add more information on ConnectionString?

Giovani.
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT

| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT

| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT

| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT

Reply to this message...

Mike Campbell

Correct. I'd also advise changing your password and other info since it
has been broadcast to everyone on this list.=20

Make sure you can connect to the sql server from the client box
correctly. i.e. is that sql server on port 1433? If not, you'll need to
specify it's port with a comma like:

Server=3Dsqlserver.quotamais.com.br,1211;

Do yourself a favor and make sure you can connect correctly to the sql
server from the client machine. To do so, create a new text document on
your desktop.. Then change the extension to .udl (you'll have to have
the 'show extensions for know file types' toggled from windows
explorer>tools>folder options>view)

Once you change it to a .udl, open it and walk through the configuration
tabs to make the connection to your server from the client machine. You
can test it ... If it works, hit okay, then you can just right click it>
open with notepad and you'll have the correct connection string.=20

--Mike

-----Original Message-----
From: Andr=E9 Colbi=F6rnsen [mailto:Click here to reveal e-mail address]=20
Sent: Friday, July 12, 2002 5:15 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] SV: RE: SV: sql server connection

That's no problem. You may well connect to a SQL-Server remotely like
this.

Regards/Halsningar

Andre Colbiornsen
--------------------------------------
Sonnenburg Communications
Bergsgatan 3,
SE-211 54 Malm=F6
Sweden
Tel.: +46-(0)40-97 78 80
Fax.: +46-(0)40-97 78 80
Mob.: +46-(0)708-97 78 79
Mail: Click here to reveal e-mail address
Web.: www.sonnenburg.se
----------------------------------------
B2B Web Solutions - Specializing in .Net
----------------------------------------

-----Ursprungligt meddelande-----
Fr=E5n: Graham Dobson [mailto:Click here to reveal e-mail address]=20
Skickat: den 12 juli 2002 13:15
Till: ngfx-sqlclient
=C4mne: [ngfx-sqlclient] RE: SV: sql server connection

I could be way off here but usually I see the string looking like this
"Data Source=3Dservername;Database=3Dpubs;UID=3Dsa;pwd=3D;". It seems =
to me you
have a partial url for your server name. Does this mean you are using
http to try and access SQL server? The SQLClient .NET access is through
SQL Server's native tabular data stream protocol so I think this would
be problematic. I haven't seen SQL server exposing it's data store or
native protocol in this way (over http) before.

Graham

-----Original Message-----
From: Andr=E9 Colbi=F6rnsen [mailto:Click here to reveal e-mail address]
Sent: Friday, July 12, 2002 3:52 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] SV: sql server connection

I thought a SQL server connection string should look like this:

Dim objConn As New
SqlConnection("Server=3Dsqlserver.quotamais.com.br;UID=3Dquotamais;PWD=3D=
webQ2
602";Database=3Dquotamais)

Regards/Halsningar

Andre Colbiornsen
--------------------------------------
Sonnenburg Communications
Bergsgatan 3,
SE-211 54 Malm=F6
Sweden
Tel.: +46-(0)40-97 78 80
Fax.: +46-(0)40-97 78 80
Mob.: +46-(0)708-97 78 79
Mail: Click here to reveal e-mail address
Web.: www.sonnenburg.se
----------------------------------------
B2B Web Solutions - Specializing in .Net
----------------------------------------

-----Ursprungligt meddelande-----
Fr=E5n: Giovani [mailto:Click here to reveal e-mail address]
Skickat: den 11 juli 2002 18:18
Till: ngfx-sqlclient
=C4mne: [ngfx-sqlclient] sql server connection

-- Moved from [aspngfreeforall] to [ngfx-sqlclient] by Tony Stark
<Click here to reveal e-mail address> --

I=B4m trying to make a connection with sql server. Follow the code:

Dim objConn As New SqlConnection("Server =3D sqlserver.quotamais.com.br;
Database =3D quotamais; User ID =3D quotamais; Password =3D webQ2602")

Dim strSql As String =3D "SELECT id FROM adm_user WHERE login =3D =
@userName
AND senha =3D @password"

Dim objCmd As New SqlCommand(strSql, objConn)

objConn.Open()

The error message that I receive when the Open method is executed is:

"SQL Server does not exist or access denied."

Do I need to add more information on ConnectionString?

Giovani.
| [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR ID=20
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D JOIN/QUIT

| [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR ID=20
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D JOIN/QUIT

| [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR ID=20
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D JOIN/QUIT

| [ngfx-sqlclient] member Click here to reveal e-mail address =3D YOUR ID
| http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp =3D JOIN/QUIT
-

-

Reply to this message...

	System.Data.SqlClient.SqlCommand
	System.Data.SqlClient.SqlConnection

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification