July 30, 2015 at 2:01 pm
Here's the scenario:
Migrating a SQL Server 2000 database to SQL Server 2012. The database migrates easily enough in the test environment. This database has an Access front end connected via ODBC. I DON'T have access (no pun intended) to the front end application.
Assuming the database is migrated and the DNS entry is aliased, will the ODBC connector used by the Access application be able to connect to the SQL 2012 version without creating a new ODBC connection?
I tried to google this but there was too much chaff to try to sort through.
July 30, 2015 at 2:28 pm
Do you have access to the connection string?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 30, 2015 at 2:39 pm
Not currently. The clients have the front end on their systems and this is supposed to be as transparent as possible.
July 30, 2015 at 4:21 pm
At a minimum, I think you will need to know what the workstation environment is. ODBC in Windows XP is quite different from Win7 or Win8. Also the version of Access would be helpful. We've done conversions like that, but we always had access to the front-end.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 30, 2015 at 4:53 pm
We are all in a standard work environment of Windows 7 and all using Office 2010. Now that I think of it I could just build a front end myself and test it.. lol..
thanks for the input!
July 31, 2015 at 7:59 am
Building a test front-end is an excellent approach. One of the changes in Win7 and later is that the ODBC DSN must be done for the current User, while in older versions you could define a System one and get it to work. But as long as the DSN name doesn't change, I would expect the connection to work after the upgrade. I presume Integrated Security is being used, not SQL Server defined user logins - if not, you may want to investigate, though it sounds like you don't have much control over the network.
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
July 31, 2015 at 8:54 am
Thanks! The ODBC SHOULD be on the current User and is Integrated Security so I'm going to keep my fingers crossed and test it out.
Erin
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply