Link to home
Start Free TrialLog in
Avatar of Windows95
Windows95Flag for United States of America

asked on

godaddy sql connection string

Trying To  make a SQL Connection String With The Following code (MM_ForoMembers_STRING = "dsn=mssql_data.dsn;uid=USER;pwd=pass;"
) but is not working with Goddady Hosting
<%
Dim sErrMsg 
sErrMsg= "<b> Si Ves Esta Pagina Tu Quiniela Fue Metida." & chr(10) 
sErrMsg= sErrMsg & "Estoy trabajando en este error." & chr(10) 
sErrMsg= sErrMsg & "Buena Suerte, Puedes Regresar A la Pagina principal. </b>" 
Dim MM_ForoMembers_STRING
MM_ForoMembers_STRING = "dsn=mssql_data.dsn;uid=USER;pwd=pass;"
if request.QueryString("a")="1" then 
	set Command1 = Server.CreateObject("ADODB.Command")
	Command1.ActiveConnection = MM_GamesOmar_STRING
	dim fArray
	fArray = Session("SessForecast")
	uArray = Session("SessUserInfo")
	'response.write uArray(0) & " **" &  uArray(1)
	dim sData
	sData = " " 
	dim sMember 
	for i = 0 to 8
		Set Recordset1 = Server.CreateObject("ADODB.Recordset")
		
		Set rsGameInfox = Server.CreateObject("ADODB.Recordset")
	
		
		
		
		Recordset1.ActiveConnection = MM_ForoMembers_STRING
'		Recordset1.Source = "SELECT *  FROM dbo.pgd_Members  WHERE Login = '" & request.Form("Nombre" ) &  "' AND Email = '" & request.Form("Email") & "'"   
		Recordset1.Source = "SELECT *  FROM dbo.pgd_Members  WHERE Email = '" & uArray(1) & "'"

Open in new window

Avatar of Wayne Barron
Wayne Barron
Flag of United States of America image

see if the following sites will give you some info on your issue.
http://aspstarterkit.com/index.php/getting-started/godaddy-sql-server-database-setup-connection-string/

3rd post on this one
http://forums.asp.net/p/1024758/1394051.aspx

2nd and 3rd links here
http://forums.asp.net/t/1115166.aspx

Good Luck
Carrzkiss
Avatar of Windows95

ASKER

Forgot To Mention My File is .asp & NOT asp .NET
That sucks.
I am sorry, my fault.
I knew that 2 of them were .net, but thought that the top one was classic.
So sorry.

Please have a look here for the Version of SQL Server that GoDaddy has.
http://www.connectionstrings.com/default.aspx

Once again, I am very sorry for the .net links.

Carrzkiss
Under The SQL Server Config Godaddy Give You The Diferent Strings For you need to sign in to your account to see this

ODBC:
Driver={SQL Server}; Server=SERVER; Database=DATABASE; Uid=DATABASE; Pwd='your password';

OLE DB, OleDbConnection (.NET):

SqlConnection (.NET):

Publishing Wizard Connection:
ASKER CERTIFIED SOLUTION
Avatar of Wayne Barron
Wayne Barron
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Never got a reply back on the code that I displayed that is the same as what [NEW-CHEF]
Has shown.

Regardless of where you got the code from, you could atleast do a:
[Accept] http:Q_24347856.html?cid=1066#a24212459  (On yours)
[Assisted] http:Q_24347856.html?cid=1066#a224212184 (On Mine)
You do not get points for it, but you Question does show as Answer.

That would be the more reasonable way of doing this.
Due to the fact that my link has the same idential code as what you presented that you got from GoDaddy. AND I presented the link Prior to your presenting your Code resolved.

Carrzkiss
Yes is similar
Wish you the best with the GoDaddy server.
Carrzkiss

Author Comments:
Yes is similar