linked tables

[Ambassador]

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 ServerMYDATABAS E' failed.

windows 2000, access XP, and sql 2000

Please help me.
Thank you

[Trevor Best]

Re: linked tables

Ambassador wrote:
[color=blue]
> 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 ServerMYDATABAS E' failed.
>
> windows 2000, access XP, and sql 2000[/color]

From your ASP page, you should link directly to the SQL Server to get
at it's tables and not to the Access MDB.

[Ben Sen]

Re: linked tables



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!

[Trevor Best]

Re: linked tables

Ben Sen wrote:
[color=blue]
>
> 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![/color]

Using Enterprise Manager or an Access ADP, yes.

[Ben Sen]

Re: linked tables

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!

[Trevor Best]

Re: linked tables

Ben Sen wrote:[color=blue]
> 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![/color]

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