Re: Support for multiple database

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" <KerryMoorman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6171C31B-BA3A-48A5-900E-5F7656205990@xxxxxxxxxxxxxxxx
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]" <notmyfirstname@xxxxxxxxx> wrote in message
news:OOMrdbfbGHA.3712@xxxxxxxxxxxxxxxxxxxxxxx
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" <sunsetaaa@xxxxxxxxxxx> schreef in bericht
news:e7YPwWfbGHA.4672@xxxxxxxxxxxxxxxxxxxxxxx
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









.

Relevant Pages

  • Re: .ldb file stays when connection is closed
    ... I am working on a vb.net app that access an MS Access Data base. ... I checked the connection state and it ... The .ldb file disappears. ...
    (microsoft.public.dotnet.framework.adonet)
  • .ldb file stays when connection is closed
    ... I am working on a vb.net app that access an MS Access Data base. ... I checked the connection state and it ... The .ldb file disappears. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: .ldb file stays when connection is closed
    ... My guess is that ADO.NET uses connection pooling, ... > I am working on a vb.net app that access an MS Access Data base. ... The .ldb file disappears. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [SOLVED] Cannot display provider-specific login prompt
    ... scenario where the program wouldn't have to know about the database, ... ConnectionStringBuilder up to a PropertyGrid for the end user to populate), ... details of the connection, for the sake of the program being able to connect ... information about the connection string that I will need. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Complicated Connection Problems bewteen ADP and SQL Server
    ... front end on the 5-8 workstations where the users happen to sit. ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... thought that I should instead change my connection string to something ...
    (microsoft.public.access.adp.sqlserver)
Loading