topic Re: Loading an Access Database with a DSN Connection to BT Hosting in Archive

Loading an Access Database with a DSN Connection to BT Hosting

karenmarley — Tue, 05 May 2009 12:32:59 GMT

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.

Re: Loading an Access Database with a DSN Connection to BT Hosting

Chantale — Tue, 05 May 2009 15:38:48 GMT

Hi Karen.

Could you provide me with the domain name?

Thanks..

Re: Loading an Access Database with a DSN Connection to BT Hosting

karenmarley — Tue, 05 May 2009 15:43:45 GMT

www.surveylinecommercial.com/Members_Registration.asp

Re: Loading an Access Database with a DSN Connection to BT Hosting

Chantale — Tue, 05 May 2009 15:54:16 GMT

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

Re: Loading an Access Database with a DSN Connection to BT Hosting

karenmarley — Tue, 05 May 2009 16:02:27 GMT

Yes thats right - the hosting space is with BT.

Re: Loading an Access Database with a DSN Connection to BT Hosting

karenmarley — Tue, 05 May 2009 16:03:48 GMT

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

Re: Loading an Access Database with a DSN Connection to BT Hosting

Chantale — Tue, 05 May 2009 16:41:55 GMT

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

Re: Loading an Access Database with a DSN Connection to BT Hosting

webcrawler2050 — Tue, 05 May 2009 19:26:20 GMT

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! 🙂

Re: Loading an Access Database with a DSN Connection to BT Hosting

webcrawler2050 — Tue, 05 May 2009 19:30:34 GMT

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)

Re: Loading an Access Database with a DSN Connection to BT Hosting

dave — Tue, 05 May 2009 20:25:10 GMT

@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.