MSSQL Newbie

[djredmond]

I just switched to IXWebhosting and noticed that it supports MSSQL. I have used MSAccess through ODBC in the past but would like to convert to MSSQL. I was able to setup the Database but I'm not sure how I go about accessing the database to add tables and eventually to add information. Do I connect through Enterprise Manager? I apologize for the simplicity in the explanation but will try to provide more details once I know what you might need to know.

[Administrator]

hi, login to ix web hosting control panel > manage your hosting > mysql server > create your database & assign user to this database.

Once you are done creating the mysql database, use the phpmyadmin (in control panel) to login to your database & browse & update it.

for scripting connection to mysql database, you can refer to this tutorial
http://my.php.net/function.mysql-connect