 |
Where do I download Microsoft SQL Server Management Studio or SQL Server 2005 Express? |
|
 |
To download Microsoft SQL Server Management Studio (SMS) please visit: http://www.microsoft.com/express/sql/download/default.aspx |
|
|
|
How do I remotely connect to my SQL Express Server? |
|
|
By default SQL Express does not accept any remote connections. You won't be able to connect to it with SQL Management Studio, or an ODBC connection for example until you enable it to accept connections |
|
|
|
How do I Create a DSN with the control panel? |
|
|
Resolution
1. Log in to the control panel (make sure you are logging in as the site user and not as the reseller if you happen to have a reseller account)
2. Click on the link for ODBC connec |
|
|
|
Do you support MySQL? |
|
|
Resolution
Yes, all of our service plans except for the VS-B include MySQL support. Please e-mail support@appliedi.net and include your domain name so that we can activate |
|
|
|
Do you support Microsoft Access? |
|
|
Resolution
Applied Innovations supports unlimited Access databases on
all hosting plans, except for VS-B. A database can give a developer the ability |
|
|
|
Do you support Microsoft SQL Server? |
|
|
Resolution
SQL Server is a powerful database server recommended for higher hit web sites or for customers who want easy database administration. Because SQL Server sits as an actual server instead of a file, |
|
|
|
Can I use a Datasource or DSN to connect to my database? |
|
|
Resolution
Datasources/DSN's are used to transfer information to and from a database, such as Access or SQL (as long as they are within our network). Applied Innovations supports the use datasources/DSN's, wh |
|
|
|
Can I use a DSN-Less Connection? |
|
|
Resolution
A DSN-less connection avoids the overhead of a datasource/DSN connection. It is a faster and recommended way to access your database. Please refer to this article on |
|
|
|
Do you support ODBC? |
|
|
Resolution
Yes, Applied Innovations supports ODBC database
connections. ODBC database connections allow you to use Access and SQL servers
in your AS |
|
|
|
Do you support RDS? |
|
|
Resolution
Yes, Applied Innovations supports RDS. RDS (Remote Data
Services) is supported through the use of a custom datahandler. |
|
|
|
Overflow error upsizing from Access 2000 to SQL 2000 |
|
|
Resolution
When you try to upsize a Microsoft Access 2000 database to Microsoft SQL Server 2000, you may receive the following error message: Overflow
To correct this problem, obtain t |
|
|
|
Can I manage my SQL database using Access 2002? |
|
|
ResolutionYes. Please check out this article found on Microsoft's website for more details: |
|
|
|
My database driven or e-commerce website seems slow the first time I view it. |
|
|
Often times your site may seem slow the first time you view it, and then it's faster afterwards. This is common on low-traffic websites and is due to the |
|
|
