Help getting ODCB working on Wiin7 client to SQLEXPRESS on server
Posted on 2014-09-22
I have 2 Win7 client PCs. One that I setup a year ago and is running correctly. I am an administrator on all equipment and using a member of a group on the 2nd PC.
I can not get the 2nd PC to work. My server AP is an Access 2007 accde, using SQLEXPRESS with Trusted Server Logon.
I started off by creating the ODCB using the 64 bit software (I got by doing a ODCB search) and when it did not work I researched to find I should have used the SYSWOW64 odbccad32.exe . I admit to being confused about the proper way to tell that exe what I needed and have fumbled through many combinations trying to create the ODCB and nothing I've tried will advise the connection is OK.
I suspicion the Server thinks I am a "Guest" and that is why it is not working (maybe). What networking permission might I have overlooked? Must I be an administrator on the PC and the Server when creating the ODCB? It seems I have tried every combination but nothing is creating an ODCB that works. Is there a way to find out if I created a faulty OCDB that needs to be removed? How do you delete an ODCB?
Your help most gratefully appreciated....