how to run ASP Nuke???

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:

Const asaConnectionTimeout = 500
Const asaCommandTimeout = 1000

Const asaConnectionString = "Provider=SQLOLEDB;server=;driver={SQL Server};uid=yourdbusername;pwd=yourdbpassword;database=yourdbname;"

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

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

Who is Participating?
BAlexandrovConnect With a Mentor Commented:
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=;Initial Catalog=Pubs;User ID=sa;Password="

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

See the difference?

Bojidar Alexandrov
Const asaConnectionString = "Provider=SQLOLEDB;server=;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.

khurram007Author Commented:
can u provide me a sample code...

Server Name = localhost or
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!!!


Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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=;driver={SQL Server};uid=sa;pwd=;database=master;"
ap_sajithConnect With a Mentor Commented:
IF you are running the SQL server in the same server as IIS, then  you can use 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.

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

Hope this helps...

khurram007Author Commented:
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...


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.