Good day all!

I have Sql Server 2012 installed on  a Windows 7 machine. I have downloaded the ODBC trial version and have it installed. I am able to connect to the DBISAM DB via excel 2010 just fine. I need assistance in setting up the connection from SQL Server 2012 to the DBISAM database.  I haven't done very much with setting up SQL servers and the like so any assistance would be greatly appreciated.  Also if the help could be as detailed as possible that would also be a big help.

Thank you very much for all your help and time.

Jim

Jim,

Just a quick note: these support forums are checked by me only periodically,
so if you don't get a response, please email us at support@elevatesoft.com
and we'll be able to help you directly or make a point to answer your
question here.

<< I have Sql Server 2012 installed on  a Windows 7 machine. I have
downloaded the ODBC trial version and have it installed. I am able to
connect to the DBISAM DB via excel 2010 just fine. I need assistance in
setting up the connection from SQL Server 2012 to the DBISAM database.  I
haven't done very much with setting up SQL servers and the like so any
assistance would be greatly appreciated.  Also if the help could be as
detailed as possible that would also be a big help. >>

See here for information on using the OPENDATASOURCE function in SQL Server
to query an ODBC DSN:

http://msdn.microsoft.com/en-us/library/ms179856.aspx

You can also use defined linked servers to do so:

http://msdn.microsoft.com/en-us/library/ms188279.aspx

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com