 |
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 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 |
|
|
|
SQL Error: Could not allocate space for object ... 'Primary' filegroup is full. |
|
|
You may receive an error like:Could not allocate space for object 'dbo.databasename'.'database_object' in database 'databasename' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the file |
|
|
