mySql connect

[David]

Hello

I am working with a mySql backend and am trying to get it to connect without
the need to install drivers for the backend.

Is there a way to skip the need to install mysql drivers on each computer in
order to create an ODBC connection or is there a standard microsoft sql
format that will not need an extra install to run on a windows system?

David

 

[David W. Fenton]

If you REALLY can't do the above and REALLY cannot install any
drivers at all, then you I would suggest you go with some of the
free editions of sql server, as those drivers are pre-installed on
windows.

If you can't install MyODBC, why would you be able to install SQL
Server?

 

[Albert D. Kallal]

If you can't install MyODBC, why would you be able to install SQL
Server?

Perhaps SQL server (or MySql) has already been installed by his IT
department/people on some server in the office.....

The question really centers around the person not wanting to install
anything on each of the desktops, we can't really determine where the SQL
server is being installed, but a wild guess on my part suggest that the
servers are installed somewhere and the user simply wants to avoid having to
do any installing or setup work on each of the workstations.

Since the SQL server drivers are preinstalled on windows boxes then that's a
possible solution, but I think as you mention if they can't install anything
at all, then we're getting into a pretty difficult and lame situation....

 

[David]

Hello

The situation is that we are a service sub-contractor with our own set of
programs.
The company that we work for supplies our IT from their own server but
normally has no need of mySql on their server so does not support it. Their
IT department manages everything including the desktop from their server and
is not very accessible.

I have packaged the mySql drivers and our program (with registry managed
server ODBC settings) using INNO as suggested and have given it to our site
manager to work with IT to install on our desktops for our use.

The other way I thought to manage it was to use their MSSql server but that
requires them to develop their own program for us. Since what we have works
well and the code is precious to us we cannot just hand that over for
development.

Thanks for your help.
If you have any further suggestions in light of this that would be helpful.