Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - How do I create a db on a SQL server?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How do I create a db on a SQL server?

 Post Reply Post Reply Page  <12
Author
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 10 June 2004 at 3:32am
I think you are still confused.

SQL Server is not a flat file like Access, you don't have a physical database file as such.

You need to install MS SQL Server onto a server making sure you have set it up that it allows you to connect to it using TCP/IP

You then need to create a database on the SQL Server (this is not a flat phsical file but a database on the actual MS SQL Server)

You then need to enter the correct information into the forums connection page to connect to the database created on the MS SQL Server (you connect to the database on the MS SQL Server not a file).

Try looking up on Google how MS SQL Server works as this should help you understand a little more as it is completly different to the flat physical file system that Access uses.
Back to Top
pvillaca View Drop Down
Newbie
Newbie


Joined: 03 June 2004
Status: Offline
Points: 34
Post Options Post Options   Thanks (0) Thanks(0)   Quote pvillaca Quote  Post ReplyReply Direct Link To This Post Posted: 10 June 2004 at 3:38am

I expressed myself badly. I know it's not a flat file. It created a directory full of files. That was what I was referring to. But the SQL Server has to have a name doesn't it? (The string on that asp file says so...)

So.. my doubts are the same. Just replace "file" for system of files, or something like that. Anyway, I think I might just give up on this whole thing and keep the slow, access forum.

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 10 June 2004 at 4:32am
When you look at the SQL servers through enterprise mangager they should have names or IP addresses.

For a local MS SQL install you can use 'localhost' as the name of the MS SQL server.
Back to Top
pvillaca View Drop Down
Newbie
Newbie


Joined: 03 June 2004
Status: Offline
Points: 34
Post Options Post Options   Thanks (0) Thanks(0)   Quote pvillaca Quote  Post ReplyReply Direct Link To This Post Posted: 11 June 2004 at 11:07am

Believe it or not, I did it! I managed to make the forum work!

Now...

1) Is there a way of "import" the users and the topics from the old forum to the new one?

2) I had already changed the skin and the language (including the images) of my forum to Portuguese. How do I "transfer" this to the new forum?

 

Back to Top
jaj478 View Drop Down
Newbie
Newbie


Joined: 29 March 2005
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote jaj478 Quote  Post ReplyReply Direct Link To This Post Posted: 29 March 2005 at 9:33pm
I see that you made it work.  How did you do it?
Back to Top
 Post Reply Post Reply Page  <12

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.