2. ASPRunnerPro General questions
  3. MS SQL
This topic is locked

MS SQL

 		3/28/2007 09:38:57
ASPRunnerPro General questions
J
 jlgouget author

Hi everybody !
I would like to create a new project using a Ms Sql database. The 2nd screen ask me to indicate the server : is it the Url of the database or something else ? The DB is logged on one of the 1and1's servers and this company give me for host name mssql08.1and1.fr . I tried with http://www.mssql08.1and1.fr, https://www.mssql08.1and1.fr, http://mssql08.1and1.fr but nothing runs and I always obtain a problem of connection.
Somebody of you could help me ?
Many thanks and greetongs from Provence.
Friendly.
Jean-Louis
C
 		clig 3/28/2007

Hi everybody !

I would like to create a new project using a Ms Sql database. The 2nd screen ask me to indicate the server : is it the Url of the database or something else ? The DB is logged on one of the 1and1's servers and this company give me for host name mssql08.1and1.fr . I tried with http://www.mssql08.1and1.fr, https://www.mssql08.1and1.fr, http://mssql08.1and1.fr but nothing runs and I always obtain a problem of connection.
Somebody of you could help me ?
Many thanks and greetongs from Provence.
Friendly.
Jean-Louis


You have to be able to access the db via ODBC or OLEdb - This you will likely not be able to do over the internet - So you will need to build a db / asprunner app then transfer this to your hosting box and attach the db you created / If this is not allowed you are kinda stuck duplicating databases on both your dev machine and the hosting site...
Sergey Kornilov admin 3/28/2007

Ask 1and1 if they allow remote access to this MS SQL server database.
If they do choose "ODBC driver" option in ASPRunnerPro, choose SQL Server driver and use mssql08.1and1.fr as a server address.