ODBC from Access to SQL Server

[Mbreti Gafur]

Hi

It is possible if we change the dsn of one software that works with Ms.Access to SQL Server?

 

[quosego]

There's some differences but it could be worth a try..

 

http://technet.microsoft.com/en-us/library/cc917601.aspx

 

has some info on it. Looks annoying though.

[Mbreti Gafur]

The software works with Ms Acess Database.I have already done the migration from ms acess to Sql Server.

I'm asking if there is any way that this software that have in it's declarations the connection to acess database to connect with sql instead of acess database.

The gereral idea is that the software coneccts to sql server and not in ms acess,so i can conect more than one pc to this sql.So increace the number of workstations.

[quosego]

Sure reverse engineer the database code and see how it's done. If you're lucky SQL is supported and it's just a simple small change. If you're unlucky you might need to do a awful lot of recoding.