If you would like to use Microsoft SQL and have not already done so, please order our SQL service from your Account Manger. You can reach them via email: sales@junctionbox.net or by phone: (352) 683-0349.
Each database is created with a set space, determined by the customer. Within this space, server storage space may be split between space for the database and space for the logs.
The database is also set up with a Database Owner account name. The database owner account name matches the hosting account login name.. The Database Owner Account is used to administer your database. This account has the power to add tables, delete tables, and can do most things that the System Administrator can, but only in the context of your database. The database owner cannot add users, and cannot modify system level attributes.
Customers wanting to create System DSNs for development, etc. on their local machines may do so by creating an ODBC connection from their machine. The server's location is for example: ntsql1.junctionbox.net.
Customers are responsible for all of their own data, including backups, extractions, and transformations. We will charge at our hourly consulting rate for customers insisting on Junctionbox doing their data manipulation.
The ODBC driver is set up with a DSN with same name as the login name for your web hosting account, e.g. esxxxxx, and the database owner. Use this DSN in your Visual Basic or ASP code to access your database from your web site. For information about access your SQL database from your home or office see Accessing your SQL Server Externally.
The only allowed ODBC connection from the Windows 2000 server is via the SQL Server ODBC driver.
When using ASP to write to the SQL Server be sure to include the following lines of code:
'Database Connect string
name = "driver=SQL Server; Server=ntsql.junctionbox.net;
database=jb01xxx;pwd=xxxxx"
When accessing SQL Server externally, set up a DSN on the machine that will be accessing the database. Usually, this is a System DSN, but can be a File DSN. When adding a DSN, you will want to make sure that you are using the latest Microsoft SQL Server ODBC driver. You can use whatever you want for the data source name, although it is suggested that you use the DSN name that you were given to help to eliminate confusion. For server, use the server supplied your Junctionbox Hosting Account Information.
Once you have a DSN, access the database in a variety of ways. You can link to an external table/database via ODBC or use Microsoft Access.
If you are accessing the database from behind a firewall, you may not be able to access the SQL server until you open Port 1433 in your firewall. Caution: If you are using another instance of SQL at your office, behind the firewall, do not open Port 1433, that creates a security risk for your local database. Instead, look into accessing the SQL database at Junctionbox from a point outside your firewall.
Using Windows 95 to connect to Windows 2000 Services over the net is a painful task. For this reason, we recommend using Windows NT, or Windows 2000. If you still want to use Windows 95, there are a few tricks you need to know, and a few hoops you have to jump through.
First, set up an LMHOSTS file. Without this, you cannot connect to Junctionbox's Windows 2000 Servers. As the rest of this document assumes that you use the same naming conventions that we use, it is recommended that you download the EXAMPLE LMHOSTS file that we provide, and save it in your WINDOWS directory. As usual, any changes such as this will require a reboot in order for them to take affect. NOTE: This file should be saved as LMHOSTS with no file extension.
Once the lmhosts file is set up, there are a few other changes that need to be made. Check Log on to network in the Dial-up Networking Properties.
The next change requires that you log into Windows 95 using the account name and password that you intend to use to connect to the Junctionbox Windows 2000 Servers. In most cases, this is the account name and password that you were provided with your virtual domain in the form of jbxxxxx. Without this, you cannot connect to Junctionbox's Drive Shares.
Mapping a network drive at this point becomes pretty simple. You need to bring up Windows Explorer, and Map Network Drive. You must make sure that you are connected to the Internet at this point.
ODBC DataSources are used for connecting to external DataBases, such as Junctionbox's SQL Servers. (To set this up under Windows 95, you must use an LMHOSTS file). Set up a System DSN using the ODBC Driver Manager.
Make sure that you have a SQL Server ODBC Driver.
Finally, use the following in the ODBC SQL Server Setup replacing jbxxxxx with the information you were provided in the Data Source Name and the Database Name.
At this screen a summary of your previous selections is displayed. Select the Test Data Source button to verify successful ODBC Data Source Creation.
If you encounter a problem with your domain not covered by support documentation, please mail a problem report to support@junctionbox.net. Please include the following information with your request:
Please be as descriptive as possible in your message. The more details you provide, easier it will be for us to diagnose and solve the problem.
Copyright © 2001 Junctionbox Online Services, Inc. All rights reserved.
info@junctionbox.net /
support@junctionbox.net
Junctionbox and the Junctionbox logo are registered trademarks of
Junctionbox Online Services. Certain other names, logos, designs,
titles, words or phrases on this site may constitute trademarks,
servicemarks or tradenames of Junctionbox or other entities which
may be registered in certain jurisdictions.