[Mono-list] asp.net conversion advice needed.

[Diego Frata]

Could you show how did you configure the DSN on Windows and on Suse? And how
are you trying to open the connection?

It's always good to debug the application on the server if it's not a
heavily used production one.

Diego Frata
diego.frata at gmail.com


On Thu, Jul 30, 2009 at 3:16 PM, manshack_one <manshack_one at yahoo.com>wrote:

>
> We're working on a project to convert MS Access applications to ASP.net
> using
> a product called Microtools.  It's clunky and we end up doing a lot of
> debugging but we've been able to get Northwind to run locally after
> conversion to ASP.net.  Problem comes in when we copy the website to the
> server (Suse) which has Mono and the latest Mysql connector on it.  After
> copying it over there are errors pertaining to the odbc connection when you
> pull up the screens on Mono.  What's apparent to me is that the DSN in
> windows and the web.config file are set to a windows version of the mysql
> driver (5.1).  When you move it over all of a sudden linux is unable to
> match that DSN name so it defaults to the system odbc driver libodbc.so.
>  We
> went through the process of installing unixODBC but it's now saying there
> is
> no default data source set up.  Which means to me that it's still not using
> the mysql connector.
>
> Would we be doing any better to put monodevelop on the linux box and debug
> the c# asp code that we get from microtools there?  Would monodevelop do a
> better job of getting the db connection to mysql?  What we're up against
> right now is that the changes we're making in visual studio to the
> web.config to make it work on the windows desktop don't have an equivalent
> in linux and for the life of me I can't make the web.config use the mysql
> connector.
>
> Would monodevelop have a better chance of reading the mysql connection if
> we
> developed on the linux box instead of the windows box?  We still have to
> run
> microtools and access in windows but maybe we could just push the converted
> code out to the server and debug it there so that when it's running
> correctly in testing we'll know there is not an extra step to make it talk
> to mysql on the linux box.
> --
> View this message in context:
> http://www.nabble.com/asp.net-conversion-advice-needed.-tp24743915p24743915.html
> Sent from the Mono - General mailing list archive at Nabble.com.
>
> _______________________________________________
> Mono-list maillist  -  Mono-list at lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.ximian.com/pipermail/mono-list/attachments/20090730/a80d91ff/attachment.html