G
garddawg
Ok this one might be fun or interesting for all you die hard MS access
users.
I have a legacy ASP web application that uses Access as it's Database.
The database is getting very large 500MB and it is become very slow. I
would like to upgrade to MSSQL 2005. My thought was to make this
change gradually and continue to use Access as the front end for the
Database. I was thinking that I could move the larger tables from
Access to MSSQL and then create a linked table in Access to access
these tables.
When I attempt this I get the following error.
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to
'SQL_DSN_NAME' failed.
The error message indicates to me that the ASP app is trying to access
the SQL database using the MS Access ODBC Driver. But I don't know.
Does anyone know if this is possible?
If so how can it be done?
Thanks
|-----------------------------|
| Web application |
|-----------------------------|
|
|
|
|
\ /
|-----------------------------|
| Access |
|-----------------------------|
|
|
|
|
\ /
|-----------------------------|
| MSSQL |
|-----------------------------|
users.
I have a legacy ASP web application that uses Access as it's Database.
The database is getting very large 500MB and it is become very slow. I
would like to upgrade to MSSQL 2005. My thought was to make this
change gradually and continue to use Access as the front end for the
Database. I was thinking that I could move the larger tables from
Access to MSSQL and then create a linked table in Access to access
these tables.
When I attempt this I get the following error.
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to
'SQL_DSN_NAME' failed.
The error message indicates to me that the ASP app is trying to access
the SQL database using the MS Access ODBC Driver. But I don't know.
Does anyone know if this is possible?
If so how can it be done?
Thanks
|-----------------------------|
| Web application |
|-----------------------------|
|
|
|
|
\ /
|-----------------------------|
| Access |
|-----------------------------|
|
|
|
|
\ /
|-----------------------------|
| MSSQL |
|-----------------------------|