Groups | Blog | Home
all groups > sql server (alternate) > february 2004 >

sql server (alternate) : linked tables


sifre78 NO[at]SPAM yahoo.com
2/27/2004 4:56:18 PM
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.
Trevor Best
2/28/2004 9:19:22 AM
[quoted text, click to view]

From your ASP page, you should link directly to the SQL Server to get
Ben Sen
2/28/2004 4:48:18 PM


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 ***
Trevor Best
2/29/2004 1:20:24 AM
[quoted text, click to view]

Ben Sen
3/1/2004 8:48:17 PM
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 ***
Trevor Best
3/1/2004 10:22:06 PM
[quoted text, click to view]

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!!!!!!
AddThis Social Bookmark Button