Multiple data sources

David,

something may have changed since then, but I asked this question last year and was told it was not possible 1 project = 1 data source
Cheers

Andrew

Is it possible to use multiple data sources with ASPRunnerPro? e.g. tables from MS Access and Tables from SQL Server in the same project? If so, how?

This still correct, one project = one datasource.
You can use linked tables in MS Access to use both databases in one project.

I have tried for a while to get the access db with linked tables to function and the only tables that I can get to show data are the ones that are actually physically in the access db. The ones that are linked from an odbc source give me an error[codebox]Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'WWWVSql' failed.

/wwwvaccess/include/commonfunctions.asp, line 1061

[/codebox]
WWWVSql has a username and a BLANK password. When I use the DSN to directly link the tables to another project it works fine but when I try to get the data through a linked Access table I get the error above. I checked to make sure that I have the current Jet Driver and everything is up to date.
I can Add/Edit/Update/Delete data from the linked table within Access.
What do I need to do to make it so that I can link to external data from an access db?
Thanks,
Dave

Dave,
I recommend to try JET OleDb connection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/<pathtofile.mdb>")
Conenction string can be found in include/dbconnection.asp file.

Dave,

I have been working on this for some time. I have an access database with a link from a sql database. I use this with several different applications (crystal reporting, etc) and it works fine. However, I cannot get sql data to pass through my asp pages. I can modify the dbconnection string and hit my sql data using a DSN and the data passes through asp fine, my problem is when the sql data table is linked through access.
Help?
Huff