linked tables

I have access tables which are linked to SQL database by ODBC
connection. By using Access, i can easily see my table contents. but
when i am using ASP, i con not. I am getting this error message

Microsoft JET Database Engine (0x80004005)
ODBC--connection to 'SQL ServerMYDATABASE' failed.

windows 2000, access XP, and sql 2000

Please help me.
Thank youAmbassador wrote:

> I have access tables which are linked to SQL database by ODBC
> connection. By using Access, i can easily see my table contents. but
> when i am using ASP, i con not. I am getting this error message
> Microsoft JET Database Engine (0x80004005)
> ODBC--connection to 'SQL ServerMYDATABASE' failed.
> windows 2000, access XP, and sql 2000

From your ASP page, you should link directly to the SQL Server to get
at it's tables and not to the Access MDB.|||
But I would like to access my access stored queries which are related to
SQL system. if i find a solution it will be very easy for me to create
queries with access. is ther any chance on sql to create that kind if
queries by mouse :)?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Ben Sen wrote:

> But I would like to access my access stored queries which are related to
> SQL system. if i find a solution it will be very easy for me to create
> queries with access. is ther any chance on sql to create that kind if
> queries by mouse :)?
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Using Enterprise Manager or an Access ADP, yes.|||Hi Trevor;

I serched on the net and i could't find any samle about how to connect
ADP queries by ASP. Also I think developing queries by ADP is diffent
than MDB file. Yesterday I was working on ADP file first time.

If you have any sample about coonection ADP queries to ASP.
Please send it to me.
Thank you for your helping.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!|||Ben Sen wrote:
> Hi Trevor;
> I serched on the net and i could't find any samle about how to connect
> ADP queries by ASP. Also I think developing queries by ADP is diffent
> than MDB file. Yesterday I was working on ADP file first time.
> If you have any sample about coonection ADP queries to ASP.
> Please send it to me.
> Thank you for your helping.
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

No, you use the ADP to create the Views. then use ASP to connect to the
SQL Server to open the views. DO NOT CONNECT TO THE ACCESS DATABASE FROM
ASP!!!!!!