RSS Feed
Knowledgebase : Databases
With DSN and no User ID/Password<% Set connectionToDatabase=Server.CreateObject("ADODB.Connection") connectionToDatabase.ConnectionTimeout=60 connectionToDatabase.Open"DSN=DSNname" %> VERY IMPORTANT! Make sure to insert the foll...
We're often asked how to create a connection string to a database. In fact a variety of databases and an equal variety of web languages. Fotunately there's a great resource at http://www.connectionstrings.com/ which contains examples of pretty much ...
To connect to Microsoft SQL databases you need Microsoft SQL Server Management Studio. We offer MyLittleAdmin on some servers, however please check with us. If you own a copy of Microsoft SQL or if you use Microsoft Visual Studio, then you wll already h...
We have installed a tool called WebSQL which will allow you to manage your databases through a standard web browser. Using this tool, you can create and design tables, views, stored procedures, as well as perform database queries.This should not be consi...
In order to publish your database to your hosting package, you need to use the SQL database publishing wizard. http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en Download from the...
How do I reference my SQL database through my code?Please reference your sql server databases using the appropriate host names.sql2.hostinguk.netsql3.hostinguk.netsql4.hostinguk.netsql5.hostinguk.net (new customers / SQL 2005)Please do not reference the s...
Error:  You receive a 'Login Failed for User 'myusername''  when connecting to your SQL 2005 database when using Microsoft SQL Management Studio. Fix: Ensure that your username and password have been entered correctly. If you have copied and pasted di...
If you wish to use an access database with your site - you should upload it via FTP to the DB folder in your FTP root.. You can then create a DSN less connection to this database by using the following path: D:\inetpub\users\YOURUSERNAME\db\databasename...
SQL Enterprise Manager tries, by default, to connect via Named Pipes. As this cannot run across the internet you need to "convince" it to use TCP/IP. To do this, you can use the following proceedure. On your computer go to CONTROL PANEL and th...