Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-02 : 08:23:32
|
| Tom writes "I'm running SQLServer 2000 and Access 2003 on one server and IIS 6.0 on another.I have created a System DSN ODBC link to the SQL Server database and linked all the SQL Server tables in that database in Access. I am able to see the contents of those tables directly from Access just fine.I have also created a local test table in the Access database and can, of course, see that table just fine directly from Access.My problem appears when I use an ADODB connection in ASP to try to go through Access to reach the linked tables. I get an "ODBC--connection to 'database' failed". My connect string in ASP looks like this - "Provider=Microsoft.Jet.OLEDB.4.0;data source=\\Server\Test.mdb"But, with this same connect string, I am able to reach the Access local test table through ASP.I have tried NT and SQL Server Authentication thinking the login credential were'nt being passed, but to no avail.I appreciate any help anyone can give." |
|
|
druer
Constraint Violating Yak Guru
314 Posts |
Posted - 2006-05-02 : 13:28:42
|
| Any chance that the user/password could be an issue for the connection from Access to SQL Server. When you created the link did you click the box to save the password?Hope it helps,DaltonBlessings aren't so much a matter of "if they come" but "are you noticing them." |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-05-02 : 18:07:04
|
| see if this is of any helpwww.connectionstrings.com |
|
|
|
|
|
|
Web to Access to SQL Server