468,556 Members | 2,357 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,556 developers. It's quick & easy.

Support for multiple database

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
May 2 '06 #1
5 1703
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?...e-22eaaebb2723

I hope this helps,

Cor

"Mike TI" <su*******@hotmail.com> schreef in bericht
news:e7**************@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

May 2 '06 #2
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]" <no************@planet.nl> wrote in message
news:OO**************@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?...e-22eaaebb2723

I hope this helps,

Cor

"Mike TI" <su*******@hotmail.com> schreef in bericht
news:e7**************@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


May 2 '06 #3
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]" <no************@planet.nl> wrote in message
news:OO**************@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?...e-22eaaebb2723

I hope this helps,

Cor

"Mike TI" <su*******@hotmail.com> schreef in bericht
news:e7**************@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



May 2 '06 #4
Mike,
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)

That is why this factory is in Net 2.0 build.

Cor
May 2 '06 #5
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

"Kerry Moorman" <Ke**********@discussions.microsoft.com> wrote in message
news:61**********************************@microsof t.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]" <no************@planet.nl> wrote in message
news:OO**************@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?...e-22eaaebb2723
>
> I hope this helps,
>
> Cor
>
> "Mike TI" <su*******@hotmail.com> schreef in bericht
> news:e7**************@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
>>
>>
>
>


May 2 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Aditya Ivaturi | last post: by
3 posts views Thread by Michael Lueck | last post: by
3 posts views Thread by 00_CuMPe3WaR3D12 | last post: by
1 post views Thread by Felix_WafyTech | last post: by
1 post views Thread by UniDue | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.