godaddy sql connection string

Posted on 2009-04-22
Last Modified: 2012-05-06
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

Question by:Windows95
    LVL 30

    Expert Comment

    by:Wayne Barron
    see if the following sites will give you some info on your issue.

    3rd post on this one

    2nd and 3rd links here

    Good Luck

    Author Comment

    Forgot To Mention My File is .asp & NOT asp .NET
    LVL 30

    Expert Comment

    by:Wayne Barron
    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.

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


    Author Comment

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

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

    OLE DB, OleDbConnection (.NET):

    SqlConnection (.NET):

    Publishing Wizard Connection:
    LVL 30

    Accepted Solution

    Taken from the link above that I provided is the same thing.
    Driver={SQL Server};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

    LVL 30

    Expert Comment

    by:Wayne Barron
    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.


    Author Closing Comment

    Yes is similar
    LVL 30

    Expert Comment

    by:Wayne Barron
    Wish you the best with the GoDaddy server.

    Author Comments:
    Yes is similar

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now