Solved

how to run ASP Nuke???

Posted on 2004-03-27
6
492 Views
Last Modified: 2012-06-27
Can Anyone tell me how to setup and use ASP Nuke?

Currently I have just installed SQL Server and mapped the ASP Nuke directory to IIS. But when I browse index.asp I get the following error:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Invalid connection string attribute
/anuke/lib/ado_lib.asp, line 87

file ado_lib
-----------------

Sub adoConnect()
      ' open a connection to the database
      Set adoConnection = Server.CreateObject("ADODB.Connection")
      If adoDebug Then Response.Write("CONNECTION: " & Application("adoConn_ConnectionString") & "<BR><BR>")
      ' connection timeout and command timeout are not supported for OLEDB
      ' adoConnection.ConnectionTimeout = Application("adoConn_ConnectionTimeout")
      ' adoConnection.CommandTimeout = Application("adoConn_CommandTimeout")
'~~~~~~~~~ Line 87 follows~~~~~~~~~~
      adoConnection.Open Application("adoConn_ConnectionString")      
End Sub

Then I checked global.asa and here is its code:

global.asa
---------------------
<SCRIPT LANGUAGE=VBScript RUNAT=Server>
Const asaConnectionTimeout = 500
Const asaCommandTimeout = 1000

Const asaConnectionString = "Provider=SQLOLEDB;server=127.0.0.1;driver={SQL Server};uid=yourdbusername;pwd=yourdbpassword;database=yourdbname;"
</script>

so tell me what to do and where to go from here....

500 globes will be awarded....thanks..

Khurram.
0
Comment
Question by:khurram007
  • 2
  • 2
  • 2
6 Comments
 
LVL 21

Expert Comment

by:ap_sajith
ID: 10697872
Const asaConnectionString = "Provider=SQLOLEDB;server=127.0.0.1;driver={SQL Server};uid=yourdbusername;pwd=yourdbpassword;database=yourdbname;"


Change the above string to....

Const asaConnectionString = "Provider=sqloledb;Data Source=ServerName; Initial Catalog=DBName;UID=UserID;PWD=Password"

And pass the correct values for the ServerName,DBName,UserID and Password Parameters.

Cheers!
0
 
LVL 2

Author Comment

by:khurram007
ID: 10698390
can u provide me a sample code...

if
Server Name = localhost or 127.0.0.1
Dbname        = master.mdf
userid           = sa (default)
password      = (default... i m not sure what is the default password)

You are just a line of code away from 500 globes!!!

Khurram

0
 
LVL 6

Expert Comment

by:BAlexandrov
ID: 10698884
It is better to leave it as is - odbc syntax.

Are you used master database??? It is not supposed to be used for user databases it is system one. Probably it is possible anyway...
I suggest you to make new database and execute the sql script for creation there.
Default sa password is empty - no password

Const asaConnectionString = "Provider=SQLOLEDB;server=127.0.0.1;driver={SQL Server};uid=sa;pwd=;database=master;"
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 21

Assisted Solution

by:ap_sajith
ap_sajith earned 250 total points
ID: 10701507
IF you are running the SQL server in the same server as IIS, then  you can use 127.0.0.1 or localhost to refer the SQL server. Otherwise, if the SQL server is installed in a different server, then you can provide the Server Name parameter with the IP address of the SQL server box.

eg:
Const asaConnectionString = "Provider=sqloledb;Data Source=10.91.5.178; Initial Catalog=Pubs;UID=sa;PWD="

Hope this helps...

Cheers!
0
 
LVL 6

Accepted Solution

by:
BAlexandrov earned 250 total points
ID: 10701623
I have not seen that they was mixed actually (oledb and odbc)

You have mixed them also!

I've said to keep odbc because the spplication may depend on that but they are mixed already so - oledb is better (if application can run with it)

OLEDB Syntax:
Const asaConnectionString = "Provider=sqloledb;Data Source=10.91.5.178;Initial Catalog=Pubs;User ID=sa;Password="

ODBC Syntax:
Const asaConnectionString =  "Driver={SQL Server};Server=10.91.5.178;Database=Pubs;Uid=sa;Pwd="

See the difference?

Bojidar Alexandrov
0
 
LVL 2

Author Comment

by:khurram007
ID: 10701862
well it seems like some othere problem with ASP Nuke... It still not working for me... I created a new page, a new connection to db and checked out the connection. And it is working there... so may be some other problem... I am posting another question for ASP Nuke with ANOTHER 500 GLOBES!!!

While you both invested precious amount with exactly same no. of msgs, I am splitting 500 points with 250 each for you. See u in the next question...

Thanks,

Khurram.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How do i Properly Convert Date time String in C# 29 66
Prevent URL from printing on header 5 65
HTML in email body has extra  tick marks 3 61
Import csv files to MS SQL 5 72
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

914 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

15 Experts available now in Live!

Get 1:1 Help Now