|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
MySQL and MyOleDBI have installed MySql and am trying to use it in VB.Net 2003 using the
MyOleDb driver. However, from all I can find, MyOleDb only works on VB.Net 2005. Does anyone know if this is correct or is it supposed to work in VB.Net 2003 as well? -- Dennis in Houston Dennis,
I would use the MySql dot net connector. There is a vs 2003 and vs 2005 version. http://dev.mysql.com/downloads/connector/net/1.0.html http://dev.mysql.com/downloads/connector/net/1.0.html http://dev.mysql.com/downloads/connector/net/5.0.html There is also a VS 2005 plug in available. http://dev.mysql.com/downloads/visual-studio-plugin/1.0.html Ken ---------------------- Show quoteHide quote "Dennis" <Den***@discussions.microsoft.com> wrote in message news:A02E5577-545D-4737-830B-4CF40D456627@microsoft.com... >I have installed MySql and am trying to use it in VB.Net 2003 using the > MyOleDb driver. However, from all I can find, MyOleDb only works on > VB.Net > 2005. Does anyone know if this is correct or is it supposed to work in > VB.Net 2003 as well? > -- > Dennis in Houston I would but my specific requirements are to develop an application that by
changing the connection string but using the same Data Access Layer, runs with either MySql or Access or SQL Express and OleDB seemed to be the way to do it. Is this even possible. -- Show quoteHide quoteDennis in Houston "Ken Tucker [MVP]" wrote: > Dennis, > > I would use the MySql dot net connector. There is a vs 2003 and > vs 2005 version. > > http://dev.mysql.com/downloads/connector/net/1.0.html > > http://dev.mysql.com/downloads/connector/net/1.0.html > > http://dev.mysql.com/downloads/connector/net/5.0.html > > There is also a VS 2005 plug in available. > > http://dev.mysql.com/downloads/visual-studio-plugin/1.0.html > > Ken > ---------------------- > > "Dennis" <Den***@discussions.microsoft.com> wrote in message > news:A02E5577-545D-4737-830B-4CF40D456627@microsoft.com... > >I have installed MySql and am trying to use it in VB.Net 2003 using the > > MyOleDb driver. However, from all I can find, MyOleDb only works on > > VB.Net > > 2005. Does anyone know if this is correct or is it supposed to work in > > VB.Net 2003 as well? > > -- > > Dennis in Houston > I would set it up to have an option the user chooses in some way shape or
form the backend they are using, and then have a case statement that handles their choice. Implement the best drivers within your project for each kind of database that could be possibly used so that all choices are covered. Show quoteHide quote "Dennis" <Den***@discussions.microsoft.com> wrote in message news:41A6202C-B6F9-41B7-9E7B-C15201ACE90C@microsoft.com... >I would but my specific requirements are to develop an application that by > changing the connection string but using the same Data Access Layer, runs > with either MySql or Access or SQL Express and OleDB seemed to be the way > to > do it. Is this even possible. > -- > Dennis in Houston > > > "Ken Tucker [MVP]" wrote: > >> Dennis, >> >> I would use the MySql dot net connector. There is a vs 2003 >> and >> vs 2005 version. >> >> http://dev.mysql.com/downloads/connector/net/1.0.html >> >> http://dev.mysql.com/downloads/connector/net/1.0.html >> >> http://dev.mysql.com/downloads/connector/net/5.0.html >> >> There is also a VS 2005 plug in available. >> >> http://dev.mysql.com/downloads/visual-studio-plugin/1.0.html >> >> Ken >> ---------------------- >> >> "Dennis" <Den***@discussions.microsoft.com> wrote in message >> news:A02E5577-545D-4737-830B-4CF40D456627@microsoft.com... >> >I have installed MySql and am trying to use it in VB.Net 2003 using the >> > MyOleDb driver. However, from all I can find, MyOleDb only works on >> > VB.Net >> > 2005. Does anyone know if this is correct or is it supposed to work in >> > VB.Net 2003 as well? >> > -- >> > Dennis in Houston >> Hi,
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp Ken ------------------------ Show quoteHide quote "Dennis" <Den***@discussions.microsoft.com> wrote in message news:41A6202C-B6F9-41B7-9E7B-C15201ACE90C@microsoft.com... >I would but my specific requirements are to develop an application that by > changing the connection string but using the same Data Access Layer, runs > with either MySql or Access or SQL Express and OleDB seemed to be the way > to > do it. Is this even possible. > -- > Dennis in Houston > > > "Ken Tucker [MVP]" wrote: > >> Dennis, >> >> I would use the MySql dot net connector. There is a vs 2003 >> and >> vs 2005 version. >> >> http://dev.mysql.com/downloads/connector/net/1.0.html >> >> http://dev.mysql.com/downloads/connector/net/1.0.html >> >> http://dev.mysql.com/downloads/connector/net/5.0.html >> >> There is also a VS 2005 plug in available. >> >> http://dev.mysql.com/downloads/visual-studio-plugin/1.0.html >> >> Ken >> ---------------------- >> >> "Dennis" <Den***@discussions.microsoft.com> wrote in message >> news:A02E5577-545D-4737-830B-4CF40D456627@microsoft.com... >> >I have installed MySql and am trying to use it in VB.Net 2003 using the >> > MyOleDb driver. However, from all I can find, MyOleDb only works on >> > VB.Net >> > 2005. Does anyone know if this is correct or is it supposed to work in >> > VB.Net 2003 as well? >> > -- >> > Dennis in Houston >> myoledb_Colibri3.exe
I have try this Oledb it work with framework 1.1 or vs 2003 and dreamweaver the connection object does not show properly but it works. but i am unable locate the web site that was downloaded http://sourceforge.net/project/shownotes.php?group_id=148466&release_id=425929 myoledbWIX-3.9.6.msi this one works with mysql 5.0 and asp.net 2.0 --- Posted via DotNetSlackers.com 
Other interesting topics
|
|||||||||||||||||||||||
