Search:   Namespaces Discussions .NET v1.1 Feedback

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 Ad MBR BootFX Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT

Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd. Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com