How can I reinstall SQL?

[BarrMan]

How can I reinstall SQL?

[pinscher]

What do you mean. SQL is a standardised query language and is not something you install but rather use for sending commands to a database.

[jaywhy13]

mayb u need to re-install IIS?

[Roelf]

or re-install sql-server

[BarrMan]

... ..

[BarrMan]

Look at me prvious post "Could not find installable ISAM"
miranda talled me I need to reinstall SQL.

[tboss132]

Where's the previous post?

[fractalvibes]

close your eyes and click your heels together three times.....



fv

[miranda]

I said SQL Server needed to be on the computer... This is an Enterprise level database. The SQL language is not the same as the SQL Server. Different databases use the SQL language but they are not all SQL Server.

[BarrMan]

Ok, whatever you say... but how can I reinstall the sql server?
can you be more specific?

[BarrMan]

Please can someone help?

How can I re-install sql server?

[miranda]

There could be one other problem here besides the lack of the Database program. When you created a new project on InterDev did you install the Scripting Library? If not then create a new project and when prompted to install the scripting library say yes. Once the project has been created try to use a design time control then.

If it doesn't work and you want to install SQL server there is a developmental version called MSDE. you can download MSDE (http://www.microsoft.com/sql/msde/downloads/download.asp) here. This can be redistributed with desktop applications but keep in mind that this version cannot be used in a production website. That would require a different version. In order to use it in a production website you will need to purchase the program. It ranges in cost from $1850.00 US to $3800.00 US depending on licensing.

There is also the option of forgoing the design time controls and just code it in by hand in source view. It is not that difficult to do.

[BarrMan]

When I'm trying to install the MSDE there is an error says: "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same. Refer to readme for more details. Setup will now exit."

and if it doesnt work, What is the code?

[miranda]

Basically that is telling you to assign a username and password to the database.

as for code

dim conn, cmd
conn = Server.CreateObject("ADODB.Connection")
cmd = Server.CreateObject("ADODB.command")



For more information look at this w3 schools (http://www.w3schools.com/ado/default.asp)

[BarrMan]

How can I do that account?

[Roelf]

i cannot find it anymore on my machine, as i have sql-server developer edition right now, but from the time i installed MSDE, i remember the documentation for installing the thingy was rather good, did you get the chance to read it? Or did you just start the setup

[BarrMan]

Yea, I read the documentation but my problam is how to do a SAPWD account for the database.