|
|
 Posted 17/03/2005 13:04:36 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 19/03/2005 07:24:00
Posts: 4,
Visits: 1
|
|
Hello! I need help setting up the SQL databases. How and what do I need to connect to the SQL Database on my web server? Thanks!
|
|
|
|
| Posted 17/03/2005 13:08:31 |
|
|
Support Supremo
Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568,
Visits: 2,507
|
|
Hi ASPForum, You should configure the connection string in the Web.Config file like the example below: <add key="InstantForum_DSN" value="server=localhost;trusted_connection=true;database=instantforum34;"/> or: <add key="InstantForum_DSN" value="server= server=yourserver.com;uid=myusername;pwd=mypassword;database=instantforum;;"/> If your databases is not already on the web server you’ll need to run the scripts IF3_4_freshinstall.sql and IF_Defaults.sql (in that order), which are located in the folder database_scripts on the SQL database Server.
|
|
|
|
| Posted 18/03/2005 13:29:00 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 19/03/2005 07:24:00
Posts: 4,
Visits: 1
|
|
Hello! Thanks for the reply. How do I go about running the scripts? Do I need Visual Studio.net installed? Thanks!
|
|
|
|
| Posted 18/03/2005 13:29:40 |
|
|
Support Supremo
Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568,
Visits: 2,507
|
|
Dear AspForum, To run the script, you'll need open and execute IF3_4_freshinstall.sql and
IF_Defaults.sql files (in that order) in SQL Server Query Analyzer.
|
|
|
|
| Posted 21/03/2005 13:13:38 |
|
|
Forum Newbie
Group: Forum Members
Last Login: 19/03/2005 07:24:00
Posts: 4,
Visits: 1
|
|
Hello! I created an .aspx ASP.net VB website using DreamWeaver. I don't have Visual Studio.net or SQL Server Query Analyzer. I'm new to SQL. What programs can I use to run the script? (i.e. do I need to purchase Visual Studio.net?) Is it possible to create these manually on my web server? Do I need to get a copy of SQL Server Enterprise Manager? Thanks!
|
|
|
|
| Posted 21/03/2005 13:15:41 |
|
|
Support Supremo
Group: Customers
Last Login: 13/11/2008 12:44:07
Posts: 568,
Visits: 2,507
|
|
Dear ASPForum,
The database used by the Forum is MSDE/SQL Server. With the installation CD of SQL Server is included Query Analyzer and Enterprise Manager. You need drivers of SQL Server on your Web Server to make the connection to the database and can run the script from other machine that have the SQL Server Query Analyzer installed. You just need the Visual Studio .NET installed if you have purchase the developer edition of InstantForum and want to make customizations.
|
|
|
|