Loading an Access Database with a DSN Connection to BT Hosting

[karenmarley]

Hi

I have an access database drive website with a dsn connection which worked fine with other hosting services.

I have now uploaded this to a BT Server and now cannot connect to the database.  Are there any settings I should be looking at which are peculiar to BT? i.e. connection strings, dsn etc.

[Chantale]

Hi Karen.

Could you provide me with the domain name?

Thanks..

[karenmarley]

www.surveylinecommercial.com/Members_Registration.asp

[Chantale]

you said your domain was being hosted here, with BT?

[karenmarley]

Yes thats right - the hosting space is with BT.

[karenmarley]

www.surveylinecommercial.com is forward to www.surveyline.com/portal/ - which sits on a BT Server

[Chantale]

Unfortunately, there is no history of surveylinecommercial.com on our BT Hosting.

[webcrawler2050]

Its not going to happen with an Access database, theres no DSN connection support. Only MYSQL! I am also lead the believe, there is no ASP.net support either.

It aint going to happen! 🙂

[webcrawler2050]

The Domain isn't being hosted at BT Either.

Nslookup says: 

C:\Users\Richard>nslookup
Default Server:  indnsc60.bt.net
Address:  194.72.0.98

> server dns01.gpn.register.com
Default Server:  dns01.gpn.register.com
Address:  98.124.192.1

> set type=a
> dns01.gpn.register.com
Server:  dns01.gpn.register.com
Address:  98.124.192.1

Name:    dns01.gpn.register.com
Address:  98.124.198.1

> set type=a
> surveylinecommercial.com
Server:  dns01.gpn.register.com
Address:  98.124.192.1

Name:    surveylinecommercial.com
Address:  69.64.147.243 < This isnt a BT IP.

You need to first change your nameservers at your registra (Where you bought your domain from)

[dave · Accepted solution]

---

@webcrawler2050 wrote:

Its not going to happen with an Access database, theres no DSN connection support. Only MYSQL! I am also lead the believe, there is no ASP.net support either.

It aint going to happen! 🙂

---

BT will create a DSN for you if you ask them. There is ASP.net support and Access.

What there isn't support for is MSSQL.