|
web
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Support for multiple databaseHi All I have been learning VB.Net 2005 by developing a small project. I have been using SQL Express till now. Now I have built a similar to SQL Data Base in MS Access. I tried to use the MS Access Data Base in my application but am unable to do so. 1. I attached the MS Access Data Base in the "Server Explorer" 2. I changed the connection string in the "APP.CONFIG" file Please guide me on how to build support for multiple database in an application. Thanks Mike TI Mike,
See this sample on our website, be aware that this is only for multiple Microsoft databases this does not yet exist by instance for Oracle. http://www.vb-tips.com/default.aspx?ID=8c3dc2d7-1232-4dd1-817e-22eaaebb2723 I hope this helps, Cor Show quoteHide quote "Mike TI" <sunset***@hotmail.com> schreef in bericht news:e7YPwWfbGHA.4672@TK2MSFTNGP04.phx.gbl... > May 2, 2006 > > Hi All > > I have been learning VB.Net 2005 by developing a small project. > > I have been using SQL Express till now. > > Now I have built a similar to SQL Data Base in MS Access. I tried to use > the MS Access Data Base in my application but am unable to do so. > > 1. I attached the MS Access Data Base in the "Server Explorer" > 2. I changed the connection string in the "APP.CONFIG" file > > Please guide me on how to build support for multiple database in an > application. > > Thanks > Mike TI > > Thank you for your reply. I have looked at the example which was very
interesting. Now, I have built an application and have used SQL Express. I want to change the application so as to use MS Access. (Not both at the same time) What do I have to do in the current application so as to be able to use MS Access database ? Mike TI Show quoteHide quote "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message news:OOMrdbfbGHA.3712@TK2MSFTNGP03.phx.gbl... > Mike, > > See this sample on our website, be aware that this is only for multiple > Microsoft databases this does not yet exist by instance for Oracle. > > http://www.vb-tips.com/default.aspx?ID=8c3dc2d7-1232-4dd1-817e-22eaaebb2723 > > I hope this helps, > > Cor > > "Mike TI" <sunset***@hotmail.com> schreef in bericht > news:e7YPwWfbGHA.4672@TK2MSFTNGP04.phx.gbl... >> May 2, 2006 >> >> Hi All >> >> I have been learning VB.Net 2005 by developing a small project. >> >> I have been using SQL Express till now. >> >> Now I have built a similar to SQL Data Base in MS Access. I tried to use >> the MS Access Data Base in my application but am unable to do so. >> >> 1. I attached the MS Access Data Base in the "Server Explorer" >> 2. I changed the connection string in the "APP.CONFIG" file >> >> Please guide me on how to build support for multiple database in an >> application. >> >> Thanks >> Mike TI >> >> > > Mike,
In your current app are you using the SQLClient namespace classes, such as SQLConnection, SQLCommand, SQLDataAdapter, etc? If so, you will need to change your app to use OleDB namespace classes, such as OleDBConnection, OleDbCommand, etc. Kerry Moorman Show quoteHide quote "Mike TI" wrote: > Thank you for your reply. I have looked at the example which was very > interesting. > > Now, I have built an application and have used SQL Express. > > I want to change the application so as to use MS Access. (Not both at the > same time) > > What do I have to do in the current application so as to be able to use MS > Access database ? > Mike TI > > "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message > news:OOMrdbfbGHA.3712@TK2MSFTNGP03.phx.gbl... > > Mike, > > > > See this sample on our website, be aware that this is only for multiple > > Microsoft databases this does not yet exist by instance for Oracle. > > > > http://www.vb-tips.com/default.aspx?ID=8c3dc2d7-1232-4dd1-817e-22eaaebb2723 > > > > I hope this helps, > > > > Cor > > > > "Mike TI" <sunset***@hotmail.com> schreef in bericht > > news:e7YPwWfbGHA.4672@TK2MSFTNGP04.phx.gbl... > >> May 2, 2006 > >> > >> Hi All > >> > >> I have been learning VB.Net 2005 by developing a small project. > >> > >> I have been using SQL Express till now. > >> > >> Now I have built a similar to SQL Data Base in MS Access. I tried to use > >> the MS Access Data Base in my application but am unable to do so. > >> > >> 1. I attached the MS Access Data Base in the "Server Explorer" > >> 2. I changed the connection string in the "APP.CONFIG" file > >> > >> Please guide me on how to build support for multiple database in an > >> application. > >> > >> Thanks > >> Mike TI > >> > >> > > > > > > > Kerry
I tried using your tip and it worked very fine. Thank you. I kept the "Data Connection Name" same in both cases, hence I had to change only the "Connection String". Please note I did not change anything in the app.config, DataSet.xtd files. Q1. Do I need to change app.config, DataSet.xtd files. If yes, how ? Q2. Can I store the value of the Connection String in a variable and use this variable where the string needs to be defined ? Q3. Where do I define this variable ? Your help is much appreciated. Mike TI Show quoteHide quote "Kerry Moorman" <KerryMoor***@discussions.microsoft.com> wrote in message news:6171C31B-BA3A-48A5-900E-5F7656205990@microsoft.com... > Mike, > > In your current app are you using the SQLClient namespace classes, such as > SQLConnection, SQLCommand, SQLDataAdapter, etc? > > If so, you will need to change your app to use OleDB namespace classes, > such > as OleDBConnection, OleDbCommand, etc. > > Kerry Moorman > > > > > "Mike TI" wrote: > >> Thank you for your reply. I have looked at the example which was very >> interesting. >> >> Now, I have built an application and have used SQL Express. >> >> I want to change the application so as to use MS Access. (Not both at the >> same time) >> >> What do I have to do in the current application so as to be able to use >> MS >> Access database ? >> Mike TI >> >> "Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message >> news:OOMrdbfbGHA.3712@TK2MSFTNGP03.phx.gbl... >> > Mike, >> > >> > See this sample on our website, be aware that this is only for multiple >> > Microsoft databases this does not yet exist by instance for Oracle. >> > >> > http://www.vb-tips.com/default.aspx?ID=8c3dc2d7-1232-4dd1-817e-22eaaebb2723 >> > >> > I hope this helps, >> > >> > Cor >> > >> > "Mike TI" <sunset***@hotmail.com> schreef in bericht >> > news:e7YPwWfbGHA.4672@TK2MSFTNGP04.phx.gbl... >> >> May 2, 2006 >> >> >> >> Hi All >> >> >> >> I have been learning VB.Net 2005 by developing a small project. >> >> >> >> I have been using SQL Express till now. >> >> >> >> Now I have built a similar to SQL Data Base in MS Access. I tried to >> >> use >> >> the MS Access Data Base in my application but am unable to do so. >> >> >> >> 1. I attached the MS Access Data Base in the "Server Explorer" >> >> 2. I changed the connection string in the "APP.CONFIG" file >> >> >> >> Please guide me on how to build support for multiple database in an >> >> application. >> >> >> >> Thanks >> >> Mike TI >> >> >> >> >> > >> > >> >> >> Mike,
> Thank you for your reply. I have looked at the example which was very That is why this factory is in Net 2.0 build.> interesting. > > Now, I have built an application and have used SQL Express. > > I want to change the application so as to use MS Access. (Not both at the > same time) > Cor 
Other interesting topics
vb.net, so slow !!!???
Collections General Question About Web Apps, VB/ASP? Accessing existing Excel Workbook from complete path Appending two data tables Application Error: CiceroUIWndFrame How to control Bluetooth? Screen Scraper that does Automated data entry. Debugging DLLs - best practice calling C dll from VB.NET |
|||||||||||||||||||||||
