Hi, I have been using MSACCESS forever now. but now I have decided to move to MSSQL to get rid of the problematic ACCESS. It is very different from MSACCESS. I am clueless about the whole setup process.
So far what I have done:
1. Created a MSSQL Login and password in Hsphere.
2. I have SQL SERVER 2005 Express Edition installed on my computer.
3. I have set up datasource in Coldfusion Admin after much googling and time.
4. I have exported MSACCESS tables into my local SQL Server, all data is in SQL Server now.
At this point, I am not sure what to do now. I thought I should get a SQL server name and port from Jodo Host for my SQL server Express to connect to. Is that correct? Jodo provides SQL Server 2000 and I have SQL Server 2005 Express Edition, will that be a problem? Any help would be appreciated.
So far what I have done:
1. Created a MSSQL Login and password in Hsphere.
2. I have SQL SERVER 2005 Express Edition installed on my computer.
3. I have set up datasource in Coldfusion Admin after much googling and time.
4. I have exported MSACCESS tables into my local SQL Server, all data is in SQL Server now.
At this point, I am not sure what to do now. I thought I should get a SQL server name and port from Jodo Host for my SQL server Express to connect to. Is that correct? Jodo provides SQL Server 2000 and I have SQL Server 2005 Express Edition, will that be a problem? Any help would be appreciated.