Database connect

[merlinvicki]

Hi, frends
I am new to ColdFusion and I was trying this database Access connectivity for
my blog, however it doesnt work on the server. The blog is running fine on my
local machine but it doesnt on the hosting server. It gives me an error :
Error Executing Database Query.
Data source not found.

The link for the blog is [url]http://www.merlinvicki.in/blog/index.cfm[/url]

Can anyone please sort this out for me??

Regards

[Neculai Macarie]

> I am new to ColdFusion and I was trying this database Access connectivity
for

> my blog, however it doesnt work on the server. The blog is running fine on

my

> local machine but it doesnt on the hosting server. It gives me an error :
> Error Executing Database Query.
> Data source not found.
>
> The link for the blog is [url]http://www.merlinvicki.in/blog/index.cfm[/url]
>
> Can anyone please sort this out for me??

You need to create a datasource from the CF admin, datasource that points to
the Access file.

--
<mack />

[merlinvicki]

Hi Neculai,

Thanx for the reply. U see I did that on my local machine and it runs fine,
but the hosting provider at my website doesn't have the CF Admin. I can only
create System DSN from there.

I'll be very grateful if you can sort this out for me. Tell me if you require
the login passwords for my site.

[tech_varun]

Could you tell me who you hosting your site with?
I guess when u log into the Web Controller for your website, it should say somewhere to add a data source.

thanks
Varun Dixit

[merlinvicki]

hi varun,
i did do that but still it says datasource not found. Can I link the same to the mddb file directly??
The same is running fine locally.

[merlinvicki]

Hi guys,
Thanx a lot for ur help. The JDBC Connector has been installed and I have got the blog to work after all.
Your help is much appreciated!