Windows95
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=US ER;pwd=pas s;"
) but is not working with Goddady Hosting
) 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) & "'"
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
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
ASKER
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:
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
Yes is similar
Wish you the best with the GoDaddy server.
Carrzkiss
Author Comments:
Yes is similar
Carrzkiss
Author Comments:
Yes is similar
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