Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Can't seem to get set up
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Can't seem to get set up

 Post Reply Post Reply Page  <12
Author
Martimus View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Martimus Quote  Post ReplyReply Direct Link To This Post Posted: 27 July 2006 at 2:20am
 
 
So when I get to this form, I use the user with the writing permissions, correct? What about the last field? Do I leave that as-is (as DBO), or change it to the user name too?
 
SQL Server Username:
< name=name>
SQL Server Password: < = name=>
SQL Server Username for creating tables < id=user value=DBO name=user>
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: 27 July 2006 at 9:13am
This all depends on how your web host has their SQL server login setup for you.

The only people who can tell you this info is your web host.

I often find phoning web hosts gets you a faster response than trying to email them.
Back to Top
Martimus View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Martimus Quote  Post ReplyReply Direct Link To This Post Posted: 28 July 2006 at 10:38pm
It was a problem on their end, which once fixed, was no longer an issue--it set up immediately. However, when I tried to get in then, I got this error:
Server Error in Forum Application
An error has occured while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute
 
Thoughts?
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627
Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post Posted: 28 July 2006 at 11:16pm
means your connectiopn settings arent correct.

checlk the settings, or some hosts will also checlk the file that holds the connection and alter for you.
Back to Top
Martimus View Drop Down
Newbie
Newbie


Joined: 26 July 2006
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote Martimus Quote  Post ReplyReply Direct Link To This Post Posted: 29 July 2006 at 4:51am
Got it--and the forum was great in seconds. Will have great fun looking at this--appreciate your fast reponses (I received multiple posts here within hours to my web hosts single email that took days), and your advice to get me moving. It must be very well put together if I can't break it, because I do have the touch.  :)
Back to Top
Music God View Drop Down
Newbie
Newbie
Avatar

Joined: 03 January 2007
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote Music God Quote  Post ReplyReply Direct Link To This Post Posted: 03 January 2007 at 6:18am
Originally posted by dj air dj air wrote:

means your connectiopn settings arent correct.

checlk the settings, or some hosts will also checlk the file that holds the connection and alter for you.


How do I check the connection settings? Which file do I need to modify?
Back to Top
Music God View Drop Down
Newbie
Newbie
Avatar

Joined: 03 January 2007
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote Music God Quote  Post ReplyReply Direct Link To This Post Posted: 03 January 2007 at 8:13am
Originally posted by Music God Music God wrote:

Originally posted by dj air dj air wrote:

means your connectiopn settings arent correct.

checlk the settings, or some hosts will also checlk the file that holds the connection and alter for you.


How do I check the connection settings? Which file do I need to modify?


Ok in the database_conection.asp folder I've typed in my info:

strSQLServerName = "x.x.x.x.x"
strSQLDBUserName = "Name_Name"
strSQLDBPassword = "xxxxx"
strSQLDBName = "Name_Name"

I was told set up was complete so I went to the url/forum and I get this message

Server Error in Forum Application
An error has occured while connecting to the database.
Please contact the forum administrator.

Support Error Code:- err_SQLServer_db_connection
File Name:- common.asp

Error details:-
Microsoft OLE DB Provider for SQL Server
Invalid connection string attribute

all of my information is correct and my server is running MySQL 4.1

I see no reason why this shouldn't be working does anyone know?
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.