473,320 Members | 1,987 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Visual Studio 2005 and Access database mystery

Hi,

I am having the following problems in getting Microsoft Visual Studio
2005 Professional to link to an Access .mdb

database. Please help me to sort this out.

Problem 1:

The Microsoft page "How to: Connect to Data in an Access Database"

http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx states the
following on how to connect to a Access database:

1. On the Data menu, click Add New Data Source.

2. Select Database on the Choose a Data Source Type page.

3. Select New Connection to create a new data connection.

Note
If the Data source is not Microsoft Access Database File, then select
Change to open the Choose/Change Data Source

dialog box, select Microsoft Access Database File, and then click
Continue.
4. The default provider is .NET Framework Provider for OLE DB. For more
information, see Choose/Change Data Source

Dialog Box.

5. In the Database file name box, enter the path to the .mdb file, or
click the Browse button to locate the database

file.

6. Enter login information if required by your database. For more
information, see Add/Modify Connection (Microsoft

Access).

7. Click OK, and then click Next.

In step 5 above it talks of a browse button. I dont't get that but
rather am given a dialog box titled Add Connection

and the only option is ConnectionString. I have tried all sorts of
options for a connect string but allways get the

error message "Format of the initialization string does not conform to
specification starting at index 0"
Problem 2:
>From the same page it states: "Drag an .mdf or .mdb file from Windows
Explorer into Solution Explorer to

automatically configure your connection and start the Data Source
Configuration Wizard ready for you to select the

objects to use in your application."

When I drag and drop drop an Access database eg. Northwind.mdb into the
Solution Explorer window I get the following

error: "An eror occurred while processing the local data file: Object
reference not set to an instance of an object"

Questions:

1. In problem 1 why don't I get the correct dialog with browse
functionality? I have Microsoft Visual Studio 2005

Professional installed on my Laptop and my main PC and they both do the
same thing. I have all patches and updates

installed.

2. How do I resolve problem 2? I have searched for a solution and and
have found none. I have uninstalled .Net

Framework 2 and reinstalled it with no difference. I think the two
problems are related.

Thanks very much for your help.

Surfrat.

Aug 31 '06 #1
18 9078
Hi,

Do you actually have Access installed on the computers?
Is it possible that you don't have the necessary ODBC drivers (or whatever)
to connect to an Access database?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...
Hi,

I am having the following problems in getting Microsoft Visual Studio
2005 Professional to link to an Access .mdb

database. Please help me to sort this out.

Problem 1:

The Microsoft page "How to: Connect to Data in an Access Database"

http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx states the
following on how to connect to a Access database:

1. On the Data menu, click Add New Data Source.

2. Select Database on the Choose a Data Source Type page.

3. Select New Connection to create a new data connection.

Note
If the Data source is not Microsoft Access Database File, then select
Change to open the Choose/Change Data Source

dialog box, select Microsoft Access Database File, and then click
Continue.
4. The default provider is .NET Framework Provider for OLE DB. For more
information, see Choose/Change Data Source

Dialog Box.

5. In the Database file name box, enter the path to the .mdb file, or
click the Browse button to locate the database

file.

6. Enter login information if required by your database. For more
information, see Add/Modify Connection (Microsoft

Access).

7. Click OK, and then click Next.

In step 5 above it talks of a browse button. I dont't get that but
rather am given a dialog box titled Add Connection

and the only option is ConnectionString. I have tried all sorts of
options for a connect string but allways get the

error message "Format of the initialization string does not conform to
specification starting at index 0"
Problem 2:
>>From the same page it states: "Drag an .mdf or .mdb file from Windows
Explorer into Solution Explorer to

automatically configure your connection and start the Data Source
Configuration Wizard ready for you to select the

objects to use in your application."

When I drag and drop drop an Access database eg. Northwind.mdb into the
Solution Explorer window I get the following

error: "An eror occurred while processing the local data file: Object
reference not set to an instance of an object"

Questions:

1. In problem 1 why don't I get the correct dialog with browse
functionality? I have Microsoft Visual Studio 2005

Professional installed on my Laptop and my main PC and they both do the
same thing. I have all patches and updates

installed.

2. How do I resolve problem 2? I have searched for a solution and and
have found none. I have uninstalled .Net

Framework 2 and reinstalled it with no difference. I think the two
problems are related.

Thanks very much for your help.

Surfrat.

Aug 31 '06 #2
Hi chris,

Yes I have Access 2003 on both machines...

I can access the databases fine from Access.

Thanks

SurfRat

ChrisM wrote:
Hi,

Do you actually have Access installed on the computers?
Is it possible that you don't have the necessary ODBC drivers (or whatever)
to connect to an Access database?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...
Hi,

I am having the following problems in getting Microsoft Visual Studio
2005 Professional to link to an Access .mdb

database. Please help me to sort this out.

Problem 1:

The Microsoft page "How to: Connect to Data in an Access Database"

http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx states the
following on how to connect to a Access database:

1. On the Data menu, click Add New Data Source.

2. Select Database on the Choose a Data Source Type page.

3. Select New Connection to create a new data connection.

Note
If the Data source is not Microsoft Access Database File, then select
Change to open the Choose/Change Data Source

dialog box, select Microsoft Access Database File, and then click
Continue.
4. The default provider is .NET Framework Provider for OLE DB. For more
information, see Choose/Change Data Source

Dialog Box.

5. In the Database file name box, enter the path to the .mdb file, or
click the Browse button to locate the database

file.

6. Enter login information if required by your database. For more
information, see Add/Modify Connection (Microsoft

Access).

7. Click OK, and then click Next.

In step 5 above it talks of a browse button. I dont't get that but
rather am given a dialog box titled Add Connection

and the only option is ConnectionString. I have tried all sorts of
options for a connect string but allways get the

error message "Format of the initialization string does not conform to
specification starting at index 0"
Problem 2:
>From the same page it states: "Drag an .mdf or .mdb file from Windows
Explorer into Solution Explorer to

automatically configure your connection and start the Data Source
Configuration Wizard ready for you to select the

objects to use in your application."

When I drag and drop drop an Access database eg. Northwind.mdb into the
Solution Explorer window I get the following

error: "An eror occurred while processing the local data file: Object
reference not set to an instance of an object"

Questions:

1. In problem 1 why don't I get the correct dialog with browse
functionality? I have Microsoft Visual Studio 2005

Professional installed on my Laptop and my main PC and they both do the
same thing. I have all patches and updates

installed.

2. How do I resolve problem 2? I have searched for a solution and and
have found none. I have uninstalled .Net

Framework 2 and reinstalled it with no difference. I think the two
problems are related.

Thanks very much for your help.

Surfrat.
Aug 31 '06 #3
Hmmm, you are selecting the 'Microsoft Jet...' provider aren't you?

Sorry to ask these dumb questions, it just strange the the provider doens't
seem to know that you want to open an Access database, and giving you the
correct dialog to select it...

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi chris,

Yes I have Access 2003 on both machines...

I can access the databases fine from Access.

Thanks

SurfRat

ChrisM wrote:
>Hi,

Do you actually have Access installed on the computers?
Is it possible that you don't have the necessary ODBC drivers (or
whatever)
to connect to an Access database?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i3g2000cwc.googlegro ups.com...
Hi,

I am having the following problems in getting Microsoft Visual Studio
2005 Professional to link to an Access .mdb

database. Please help me to sort this out.

Problem 1:

The Microsoft page "How to: Connect to Data in an Access Database"

http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx states the
following on how to connect to a Access database:

1. On the Data menu, click Add New Data Source.

2. Select Database on the Choose a Data Source Type page.

3. Select New Connection to create a new data connection.

Note
If the Data source is not Microsoft Access Database File, then select
Change to open the Choose/Change Data Source

dialog box, select Microsoft Access Database File, and then click
Continue.
4. The default provider is .NET Framework Provider for OLE DB. For more
information, see Choose/Change Data Source

Dialog Box.

5. In the Database file name box, enter the path to the .mdb file, or
click the Browse button to locate the database

file.

6. Enter login information if required by your database. For more
information, see Add/Modify Connection (Microsoft

Access).

7. Click OK, and then click Next.

In step 5 above it talks of a browse button. I dont't get that but
rather am given a dialog box titled Add Connection

and the only option is ConnectionString. I have tried all sorts of
options for a connect string but allways get the

error message "Format of the initialization string does not conform to
specification starting at index 0"
Problem 2:

From the same page it states: "Drag an .mdf or .mdb file from Windows
Explorer into Solution Explorer to

automatically configure your connection and start the Data Source
Configuration Wizard ready for you to select the

objects to use in your application."

When I drag and drop drop an Access database eg. Northwind.mdb into the
Solution Explorer window I get the following

error: "An eror occurred while processing the local data file: Object
reference not set to an instance of an object"

Questions:

1. In problem 1 why don't I get the correct dialog with browse
functionality? I have Microsoft Visual Studio 2005

Professional installed on my Laptop and my main PC and they both do the
same thing. I have all patches and updates

installed.

2. How do I resolve problem 2? I have searched for a solution and and
have found none. I have uninstalled .Net

Framework 2 and reinstalled it with no difference. I think the two
problems are related.

Thanks very much for your help.

Surfrat.

Aug 31 '06 #4
Hi Chris,

Thanks for your help. I click on new connection and select "Microsoft
Access database file" at the top under Data Source which in turn
selects ".Net Framework Data Provider for OLE DB" under Data Provider.
When I then click OK I get the "Add Connection" dialog with only
ConnectionString and no browse button. I will see what help I get from
the news groups over the weekend and then uninstall Visual Studio and
..Net Framework 2.0 and try again.

Does your VS2005 work correctly? I have Visual Studio 2005 Pro
installed v8.0.50727.42
(RTM.050727-4200) and .Net Framework v2.0.50727. How do these compare
to you versions?

Cheers

SurfRat.

ChrisM wrote:
Hmmm, you are selecting the 'Microsoft Jet...' provider aren't you?

Sorry to ask these dumb questions, it just strange the the provider doens't
seem to know that you want to open an Access database, and giving you the
correct dialog to select it...

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi chris,

Yes I have Access 2003 on both machines...

I can access the databases fine from Access.

Thanks

SurfRat

ChrisM wrote:
Hi,

Do you actually have Access installed on the computers?
Is it possible that you don't have the necessary ODBC drivers (or
whatever)
to connect to an Access database?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...
Hi,

I am having the following problems in getting Microsoft Visual Studio
2005 Professional to link to an Access .mdb

database. Please help me to sort this out.

Problem 1:

The Microsoft page "How to: Connect to Data in an Access Database"

http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx states the
following on how to connect to a Access database:

1. On the Data menu, click Add New Data Source.

2. Select Database on the Choose a Data Source Type page.

3. Select New Connection to create a new data connection.

Note
If the Data source is not Microsoft Access Database File, then select
Change to open the Choose/Change Data Source

dialog box, select Microsoft Access Database File, and then click
Continue.
4. The default provider is .NET Framework Provider for OLE DB. For more
information, see Choose/Change Data Source

Dialog Box.

5. In the Database file name box, enter the path to the .mdb file, or
click the Browse button to locate the database

file.

6. Enter login information if required by your database. For more
information, see Add/Modify Connection (Microsoft

Access).

7. Click OK, and then click Next.

In step 5 above it talks of a browse button. I dont't get that but
rather am given a dialog box titled Add Connection

and the only option is ConnectionString. I have tried all sorts of
options for a connect string but allways get the

error message "Format of the initialization string does not conform to
specification starting at index 0"
Problem 2:

From the same page it states: "Drag an .mdf or .mdb file from Windows
Explorer into Solution Explorer to

automatically configure your connection and start the Data Source
Configuration Wizard ready for you to select the

objects to use in your application."

When I drag and drop drop an Access database eg. Northwind.mdb into the
Solution Explorer window I get the following

error: "An eror occurred while processing the local data file: Object
reference not set to an instance of an object"

Questions:

1. In problem 1 why don't I get the correct dialog with browse
functionality? I have Microsoft Visual Studio 2005

Professional installed on my Laptop and my main PC and they both do the
same thing. I have all patches and updates

installed.

2. How do I resolve problem 2? I have searched for a solution and and
have found none. I have uninstalled .Net

Framework 2 and reinstalled it with no difference. I think the two
problems are related.

Thanks very much for your help.

Surfrat.
Sep 1 '06 #5
Hi,

Have to admint that I'm still using VS2003, and how now experience of 2005.
I was hoping that it would be similar enough for my suggestions to be able
to help, but maybe they are too different in this area...

Last thing I can think of:
Can you change the DataProvider that it suggests? Is there any others
available that mention Access or Jet?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...
Hi Chris,

Thanks for your help. I click on new connection and select "Microsoft
Access database file" at the top under Data Source which in turn
selects ".Net Framework Data Provider for OLE DB" under Data Provider.
When I then click OK I get the "Add Connection" dialog with only
ConnectionString and no browse button. I will see what help I get from
the news groups over the weekend and then uninstall Visual Studio and
.Net Framework 2.0 and try again.

Does your VS2005 work correctly? I have Visual Studio 2005 Pro
installed v8.0.50727.42
(RTM.050727-4200) and .Net Framework v2.0.50727. How do these compare
to you versions?

Cheers

SurfRat.

ChrisM wrote:
>Hmmm, you are selecting the 'Microsoft Jet...' provider aren't you?

Sorry to ask these dumb questions, it just strange the the provider
doens't
seem to know that you want to open an Access database, and giving you the
correct dialog to select it...

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googleg roups.com...
Hi chris,

Yes I have Access 2003 on both machines...

I can access the databases fine from Access.

Thanks

SurfRat

ChrisM wrote:
Hi,

Do you actually have Access installed on the computers?
Is it possible that you don't have the necessary ODBC drivers (or
whatever)
to connect to an Access database?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i3g2000cwc.googlegro ups.com...
Hi,

I am having the following problems in getting Microsoft Visual
Studio
2005 Professional to link to an Access .mdb

database. Please help me to sort this out.

Problem 1:

The Microsoft page "How to: Connect to Data in an Access Database"

http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx states the
following on how to connect to a Access database:

1. On the Data menu, click Add New Data Source.

2. Select Database on the Choose a Data Source Type page.

3. Select New Connection to create a new data connection.

Note
If the Data source is not Microsoft Access Database File, then
select
Change to open the Choose/Change Data Source

dialog box, select Microsoft Access Database File, and then click
Continue.
4. The default provider is .NET Framework Provider for OLE DB. For
more
information, see Choose/Change Data Source

Dialog Box.

5. In the Database file name box, enter the path to the .mdb file,
or
click the Browse button to locate the database

file.

6. Enter login information if required by your database. For more
information, see Add/Modify Connection (Microsoft

Access).

7. Click OK, and then click Next.

In step 5 above it talks of a browse button. I dont't get that but
rather am given a dialog box titled Add Connection

and the only option is ConnectionString. I have tried all sorts of
options for a connect string but allways get the

error message "Format of the initialization string does not conform
to
specification starting at index 0"
Problem 2:

From the same page it states: "Drag an .mdf or .mdb file from
Windows
Explorer into Solution Explorer to

automatically configure your connection and start the Data Source
Configuration Wizard ready for you to select the

objects to use in your application."

When I drag and drop drop an Access database eg. Northwind.mdb into
the
Solution Explorer window I get the following

error: "An eror occurred while processing the local data file:
Object
reference not set to an instance of an object"

Questions:

1. In problem 1 why don't I get the correct dialog with browse
functionality? I have Microsoft Visual Studio 2005

Professional installed on my Laptop and my main PC and they both do
the
same thing. I have all patches and updates

installed.

2. How do I resolve problem 2? I have searched for a solution and
and
have found none. I have uninstalled .Net

Framework 2 and reinstalled it with no difference. I think the two
problems are related.

Thanks very much for your help.

Surfrat.


Sep 1 '06 #6
Yes there are other data providers...

Dataprovider for ODBC
Dataprovider for SQL server
Dataprovider for SQL server mobile edition
Dataprovider for Oracle

Thanks...

ChrisM wrote:
Hi,

Have to admint that I'm still using VS2003, and how now experience of 2005.
I was hoping that it would be similar enough for my suggestions to be able
to help, but maybe they are too different in this area...

Last thing I can think of:
Can you change the DataProvider that it suggests? Is there any others
available that mention Access or Jet?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...
Hi Chris,

Thanks for your help. I click on new connection and select "Microsoft
Access database file" at the top under Data Source which in turn
selects ".Net Framework Data Provider for OLE DB" under Data Provider.
When I then click OK I get the "Add Connection" dialog with only
ConnectionString and no browse button. I will see what help I get from
the news groups over the weekend and then uninstall Visual Studio and
.Net Framework 2.0 and try again.

Does your VS2005 work correctly? I have Visual Studio 2005 Pro
installed v8.0.50727.42
(RTM.050727-4200) and .Net Framework v2.0.50727. How do these compare
to you versions?

Cheers

SurfRat.

ChrisM wrote:
Hmmm, you are selecting the 'Microsoft Jet...' provider aren't you?

Sorry to ask these dumb questions, it just strange the the provider
doens't
seem to know that you want to open an Access database, and giving you the
correct dialog to select it...

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi chris,

Yes I have Access 2003 on both machines...

I can access the databases fine from Access.

Thanks

SurfRat

ChrisM wrote:
Hi,

Do you actually have Access installed on the computers?
Is it possible that you don't have the necessary ODBC drivers (or
whatever)
to connect to an Access database?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...
Hi,

I am having the following problems in getting Microsoft Visual
Studio
2005 Professional to link to an Access .mdb

database. Please help me to sort this out.

Problem 1:

The Microsoft page "How to: Connect to Data in an Access Database"

http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx states the
following on how to connect to a Access database:

1. On the Data menu, click Add New Data Source.

2. Select Database on the Choose a Data Source Type page.

3. Select New Connection to create a new data connection.

Note
If the Data source is not Microsoft Access Database File, then
select
Change to open the Choose/Change Data Source

dialog box, select Microsoft Access Database File, and then click
Continue.
4. The default provider is .NET Framework Provider for OLE DB. For
more
information, see Choose/Change Data Source

Dialog Box.

5. In the Database file name box, enter the path to the .mdb file,
or
click the Browse button to locate the database

file.

6. Enter login information if required by your database. For more
information, see Add/Modify Connection (Microsoft

Access).

7. Click OK, and then click Next.

In step 5 above it talks of a browse button. I dont't get that but
rather am given a dialog box titled Add Connection

and the only option is ConnectionString. I have tried all sorts of
options for a connect string but allways get the

error message "Format of the initialization string does not conform
to
specification starting at index 0"
Problem 2:

From the same page it states: "Drag an .mdf or .mdb file from
Windows
Explorer into Solution Explorer to

automatically configure your connection and start the Data Source
Configuration Wizard ready for you to select the

objects to use in your application."

When I drag and drop drop an Access database eg. Northwind.mdb into
the
Solution Explorer window I get the following

error: "An eror occurred while processing the local data file:
Object
reference not set to an instance of an object"

Questions:

1. In problem 1 why don't I get the correct dialog with browse
functionality? I have Microsoft Visual Studio 2005

Professional installed on my Laptop and my main PC and they both do
the
same thing. I have all patches and updates

installed.

2. How do I resolve problem 2? I have searched for a solution and
and
have found none. I have uninstalled .Net

Framework 2 and reinstalled it with no difference. I think the two
problems are related.

Thanks very much for your help.

Surfrat.
Sep 1 '06 #7
Hi,

I installed VS2005 on another PC with a vanilla copy of XP Pro. The
problem is not present and the browse button is available.

I then uninstalled VS2005, SQL and .Net framework 2.0 and reinstalled
everything and the problem is still there. I am now thinking that the
problem is caused by something else. Ideas would be welcome...

Thanks

SurfRat.

su******@hotmail.com wrote:
Yes there are other data providers...

Dataprovider for ODBC
Dataprovider for SQL server
Dataprovider for SQL server mobile edition
Dataprovider for Oracle

Thanks...

ChrisM wrote:
Hi,

Have to admint that I'm still using VS2003, and how now experience of 2005.
I was hoping that it would be similar enough for my suggestions to be able
to help, but maybe they are too different in this area...

Last thing I can think of:
Can you change the DataProvider that it suggests? Is there any others
available that mention Access or Jet?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...
Hi Chris,
>
Thanks for your help. I click on new connection and select "Microsoft
Access database file" at the top under Data Source which in turn
selects ".Net Framework Data Provider for OLE DB" under Data Provider.
When I then click OK I get the "Add Connection" dialog with only
ConnectionString and no browse button. I will see what help I get from
the news groups over the weekend and then uninstall Visual Studio and
.Net Framework 2.0 and try again.
>
Does your VS2005 work correctly? I have Visual Studio 2005 Pro
installed v8.0.50727.42
(RTM.050727-4200) and .Net Framework v2.0.50727. How do these compare
to you versions?
>
Cheers
>
SurfRat.
>
ChrisM wrote:
>Hmmm, you are selecting the 'Microsoft Jet...' provider aren't you?
>>
>Sorry to ask these dumb questions, it just strange the the provider
>doens't
>seem to know that you want to open an Access database, and giving you the
>correct dialog to select it...
>>
>Cheers,
>>
>Chris.
>>
><su******@hotmail.comwrote in message
>news:11**********************@h48g2000cwc.googleg roups.com...
Hi chris,
>
Yes I have Access 2003 on both machines...
>
I can access the databases fine from Access.
>
Thanks
>
SurfRat
>
ChrisM wrote:
>Hi,
>>
>Do you actually have Access installed on the computers?
>Is it possible that you don't have the necessary ODBC drivers (or
>whatever)
>to connect to an Access database?
>>
>Cheers,
>>
>Chris.
>>
><su******@hotmail.comwrote in message
>news:11*********************@i3g2000cwc.googlegro ups.com...
Hi,
>
I am having the following problems in getting Microsoft Visual
Studio
2005 Professional to link to an Access .mdb
>
database. Please help me to sort this out.
>
Problem 1:
>
The Microsoft page "How to: Connect to Data in an Access Database"
>
http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx states the
following on how to connect to a Access database:
>
1. On the Data menu, click Add New Data Source.
>
2. Select Database on the Choose a Data Source Type page.
>
3. Select New Connection to create a new data connection.
>
Note
If the Data source is not Microsoft Access Database File, then
select
Change to open the Choose/Change Data Source
>
dialog box, select Microsoft Access Database File, and then click
Continue.
>
>
4. The default provider is .NET Framework Provider for OLE DB. For
more
information, see Choose/Change Data Source
>
Dialog Box.
>
5. In the Database file name box, enter the path to the .mdb file,
or
click the Browse button to locate the database
>
file.
>
6. Enter login information if required by your database. For more
information, see Add/Modify Connection (Microsoft
>
Access).
>
7. Click OK, and then click Next.
>
In step 5 above it talks of a browse button. I dont't get that but
rather am given a dialog box titled Add Connection
>
and the only option is ConnectionString. I have tried all sorts of
options for a connect string but allways get the
>
error message "Format of the initialization string does not conform
to
specification starting at index 0"
>
>
Problem 2:
>
>>From the same page it states: "Drag an .mdf or .mdb file from
>>Windows
Explorer into Solution Explorer to
>
automatically configure your connection and start the Data Source
Configuration Wizard ready for you to select the
>
objects to use in your application."
>
When I drag and drop drop an Access database eg. Northwind.mdb into
the
Solution Explorer window I get the following
>
error: "An eror occurred while processing the local data file:
Object
reference not set to an instance of an object"
>
Questions:
>
1. In problem 1 why don't I get the correct dialog with browse
functionality? I have Microsoft Visual Studio 2005
>
Professional installed on my Laptop and my main PC and they both do
the
same thing. I have all patches and updates
>
installed.
>
2. How do I resolve problem 2? I have searched for a solution and
and
have found none. I have uninstalled .Net
>
Framework 2 and reinstalled it with no difference. I think the two
problems are related.
>
Thanks very much for your help.
>
Surfrat.
>
>
>
Sep 3 '06 #8
What else is installed on the problem PC that isn't present on the vanilla
one?

When you get the browse button on the vanilla PC, is it using EXACTLY the
same provider as when it doesn't work on the other one?

Chris.

<su******@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Hi,

I installed VS2005 on another PC with a vanilla copy of XP Pro. The
problem is not present and the browse button is available.

I then uninstalled VS2005, SQL and .Net framework 2.0 and reinstalled
everything and the problem is still there. I am now thinking that the
problem is caused by something else. Ideas would be welcome...

Thanks

SurfRat.

su******@hotmail.com wrote:
>Yes there are other data providers...

Dataprovider for ODBC
Dataprovider for SQL server
Dataprovider for SQL server mobile edition
Dataprovider for Oracle

Thanks...

ChrisM wrote:
Hi,

Have to admint that I'm still using VS2003, and how now experience of
2005.
I was hoping that it would be similar enough for my suggestions to be
able
to help, but maybe they are too different in this area...

Last thing I can think of:
Can you change the DataProvider that it suggests? Is there any others
available that mention Access or Jet?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...
Hi Chris,

Thanks for your help. I click on new connection and select "Microsoft
Access database file" at the top under Data Source which in turn
selects ".Net Framework Data Provider for OLE DB" under Data
Provider.
When I then click OK I get the "Add Connection" dialog with only
ConnectionString and no browse button. I will see what help I get
from
the news groups over the weekend and then uninstall Visual Studio and
.Net Framework 2.0 and try again.

Does your VS2005 work correctly? I have Visual Studio 2005 Pro
installed v8.0.50727.42
(RTM.050727-4200) and .Net Framework v2.0.50727. How do these compare
to you versions?

Cheers

SurfRat.

ChrisM wrote:
Hmmm, you are selecting the 'Microsoft Jet...' provider aren't you?

Sorry to ask these dumb questions, it just strange the the provider
doens't
seem to know that you want to open an Access database, and giving
you the
correct dialog to select it...

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googleg roups.com...
Hi chris,

Yes I have Access 2003 on both machines...

I can access the databases fine from Access.

Thanks

SurfRat

ChrisM wrote:
Hi,

Do you actually have Access installed on the computers?
Is it possible that you don't have the necessary ODBC drivers (or
whatever)
to connect to an Access database?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i3g2000cwc.googlegro ups.com...
Hi,

I am having the following problems in getting Microsoft Visual
Studio
2005 Professional to link to an Access .mdb

database. Please help me to sort this out.

Problem 1:

The Microsoft page "How to: Connect to Data in an Access
Database"

http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx states
the
following on how to connect to a Access database:

1. On the Data menu, click Add New Data Source.

2. Select Database on the Choose a Data Source Type page.

3. Select New Connection to create a new data connection.

Note
If the Data source is not Microsoft Access Database File, then
select
Change to open the Choose/Change Data Source

dialog box, select Microsoft Access Database File, and then
click
Continue.
4. The default provider is .NET Framework Provider for OLE DB.
For
more
information, see Choose/Change Data Source

Dialog Box.

5. In the Database file name box, enter the path to the .mdb
file,
or
click the Browse button to locate the database

file.

6. Enter login information if required by your database. For
more
information, see Add/Modify Connection (Microsoft

Access).

7. Click OK, and then click Next.

In step 5 above it talks of a browse button. I dont't get that
but
rather am given a dialog box titled Add Connection

and the only option is ConnectionString. I have tried all sorts
of
options for a connect string but allways get the

error message "Format of the initialization string does not
conform
to
specification starting at index 0"
Problem 2:

From the same page it states: "Drag an .mdf or .mdb file from
Windows
Explorer into Solution Explorer to

automatically configure your connection and start the Data
Source
Configuration Wizard ready for you to select the

objects to use in your application."

When I drag and drop drop an Access database eg. Northwind.mdb
into
the
Solution Explorer window I get the following

error: "An eror occurred while processing the local data file:
Object
reference not set to an instance of an object"

Questions:

1. In problem 1 why don't I get the correct dialog with browse
functionality? I have Microsoft Visual Studio 2005

Professional installed on my Laptop and my main PC and they
both do
the
same thing. I have all patches and updates

installed.

2. How do I resolve problem 2? I have searched for a solution
and
and
have found none. I have uninstalled .Net

Framework 2 and reinstalled it with no difference. I think the
two
problems are related.

Thanks very much for your help.

Surfrat.

Sep 4 '06 #9
Hi,

The vanilla PC has only WinXP and VS2005 with no updates or patches. My
main PC has all the updates and patches for everything and loads of
apps eg. Office 2003, anti virus. My laptop and main PC are both fully
updated and have similar apps. Yes, exactly the same provider is used
in both cases. I also tested the scenario where you can drag a .mdb
file into your project. On the vanilla PC it worked fine but on my main
PC and my laptop I get the error message.

Something is interfearing with the ADO porion of the .Net framework.

Thanks

SurfRat.

ChrisM wrote:
What else is installed on the problem PC that isn't present on the vanilla
one?

When you get the browse button on the vanilla PC, is it using EXACTLY the
same provider as when it doesn't work on the other one?

Chris.

<su******@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Hi,

I installed VS2005 on another PC with a vanilla copy of XP Pro. The
problem is not present and the browse button is available.

I then uninstalled VS2005, SQL and .Net framework 2.0 and reinstalled
everything and the problem is still there. I am now thinking that the
problem is caused by something else. Ideas would be welcome...

Thanks

SurfRat.

su******@hotmail.com wrote:
Yes there are other data providers...

Dataprovider for ODBC
Dataprovider for SQL server
Dataprovider for SQL server mobile edition
Dataprovider for Oracle

Thanks...

ChrisM wrote:
Hi,

Have to admint that I'm still using VS2003, and how now experience of
2005.
I was hoping that it would be similar enough for my suggestions to be
able
to help, but maybe they are too different in this area...

Last thing I can think of:
Can you change the DataProvider that it suggests? Is there any others
available that mention Access or Jet?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...
Hi Chris,
>
Thanks for your help. I click on new connection and select "Microsoft
Access database file" at the top under Data Source which in turn
selects ".Net Framework Data Provider for OLE DB" under Data
Provider.
When I then click OK I get the "Add Connection" dialog with only
ConnectionString and no browse button. I will see what help I get
from
the news groups over the weekend and then uninstall Visual Studio and
.Net Framework 2.0 and try again.
>
Does your VS2005 work correctly? I have Visual Studio 2005 Pro
installed v8.0.50727.42
(RTM.050727-4200) and .Net Framework v2.0.50727. How do these compare
to you versions?
>
Cheers
>
SurfRat.
>
ChrisM wrote:
>Hmmm, you are selecting the 'Microsoft Jet...' provider aren't you?
>>
>Sorry to ask these dumb questions, it just strange the the provider
>doens't
>seem to know that you want to open an Access database, and giving
>you the
>correct dialog to select it...
>>
>Cheers,
>>
>Chris.
>>
><su******@hotmail.comwrote in message
>news:11**********************@h48g2000cwc.googleg roups.com...
Hi chris,
>
Yes I have Access 2003 on both machines...
>
I can access the databases fine from Access.
>
Thanks
>
SurfRat
>
ChrisM wrote:
>Hi,
>>
>Do you actually have Access installed on the computers?
>Is it possible that you don't have the necessary ODBC drivers (or
>whatever)
>to connect to an Access database?
>>
>Cheers,
>>
>Chris.
>>
><su******@hotmail.comwrote in message
>news:11*********************@i3g2000cwc.googlegro ups.com...
Hi,
>
I am having the following problems in getting Microsoft Visual
Studio
2005 Professional to link to an Access .mdb
>
database. Please help me to sort this out.
>
Problem 1:
>
The Microsoft page "How to: Connect to Data in an Access
Database"
>
http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx states
the
following on how to connect to a Access database:
>
1. On the Data menu, click Add New Data Source.
>
2. Select Database on the Choose a Data Source Type page.
>
3. Select New Connection to create a new data connection.
>
Note
If the Data source is not Microsoft Access Database File, then
select
Change to open the Choose/Change Data Source
>
dialog box, select Microsoft Access Database File, and then
click
Continue.
>
>
4. The default provider is .NET Framework Provider for OLE DB.
For
more
information, see Choose/Change Data Source
>
Dialog Box.
>
5. In the Database file name box, enter the path to the .mdb
file,
or
click the Browse button to locate the database
>
file.
>
6. Enter login information if required by your database. For
more
information, see Add/Modify Connection (Microsoft
>
Access).
>
7. Click OK, and then click Next.
>
In step 5 above it talks of a browse button. I dont't get that
but
rather am given a dialog box titled Add Connection
>
and the only option is ConnectionString. I have tried all sorts
of
options for a connect string but allways get the
>
error message "Format of the initialization string does not
conform
to
specification starting at index 0"
>
>
Problem 2:
>
>>From the same page it states: "Drag an .mdf or .mdb file from
>>Windows
Explorer into Solution Explorer to
>
automatically configure your connection and start the Data
Source
Configuration Wizard ready for you to select the
>
objects to use in your application."
>
When I drag and drop drop an Access database eg. Northwind.mdb
into
the
Solution Explorer window I get the following
>
error: "An eror occurred while processing the local data file:
Object
reference not set to an instance of an object"
>
Questions:
>
1. In problem 1 why don't I get the correct dialog with browse
functionality? I have Microsoft Visual Studio 2005
>
Professional installed on my Laptop and my main PC and they
both do
the
same thing. I have all patches and updates
>
installed.
>
2. How do I resolve problem 2? I have searched for a solution
and
and
have found none. I have uninstalled .Net
>
Framework 2 and reinstalled it with no difference. I think the
two
problems are related.
>
Thanks very much for your help.
>
Surfrat.
>
>
>
Sep 4 '06 #10
Yuck!

Well, the only thing I can think of is to slowly install all the patches and
apps onto the vanilla PC until it starts to show the same problem. Once
you've identified the patch/application that causes the problem, then you
can start trying to work out how you're going to fix it...

I guess installing Office2003 on the vanilla PC would be a good candidate to
try first, along with any other databasey type applications...

Good luck...!

Chris.

<su******@hotmail.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
Hi,

The vanilla PC has only WinXP and VS2005 with no updates or patches. My
main PC has all the updates and patches for everything and loads of
apps eg. Office 2003, anti virus. My laptop and main PC are both fully
updated and have similar apps. Yes, exactly the same provider is used
in both cases. I also tested the scenario where you can drag a .mdb
file into your project. On the vanilla PC it worked fine but on my main
PC and my laptop I get the error message.

Something is interfearing with the ADO porion of the .Net framework.

Thanks

SurfRat.

ChrisM wrote:
>What else is installed on the problem PC that isn't present on the
vanilla
one?

When you get the browse button on the vanilla PC, is it using EXACTLY the
same provider as when it doesn't work on the other one?

Chris.

<su******@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googleg roups.com...
Hi,

I installed VS2005 on another PC with a vanilla copy of XP Pro. The
problem is not present and the browse button is available.

I then uninstalled VS2005, SQL and .Net framework 2.0 and reinstalled
everything and the problem is still there. I am now thinking that the
problem is caused by something else. Ideas would be welcome...

Thanks

SurfRat.

su******@hotmail.com wrote:
Yes there are other data providers...

Dataprovider for ODBC
Dataprovider for SQL server
Dataprovider for SQL server mobile edition
Dataprovider for Oracle

Thanks...

ChrisM wrote:
Hi,

Have to admint that I'm still using VS2003, and how now experience
of
2005.
I was hoping that it would be similar enough for my suggestions to
be
able
to help, but maybe they are too different in this area...

Last thing I can think of:
Can you change the DataProvider that it suggests? Is there any
others
available that mention Access or Jet?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...
Hi Chris,

Thanks for your help. I click on new connection and select
"Microsoft
Access database file" at the top under Data Source which in turn
selects ".Net Framework Data Provider for OLE DB" under Data
Provider.
When I then click OK I get the "Add Connection" dialog with only
ConnectionString and no browse button. I will see what help I get
from
the news groups over the weekend and then uninstall Visual Studio
and
.Net Framework 2.0 and try again.

Does your VS2005 work correctly? I have Visual Studio 2005 Pro
installed v8.0.50727.42
(RTM.050727-4200) and .Net Framework v2.0.50727. How do these
compare
to you versions?

Cheers

SurfRat.

ChrisM wrote:
Hmmm, you are selecting the 'Microsoft Jet...' provider aren't
you?

Sorry to ask these dumb questions, it just strange the the
provider
doens't
seem to know that you want to open an Access database, and giving
you the
correct dialog to select it...

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googleg roups.com...
Hi chris,

Yes I have Access 2003 on both machines...

I can access the databases fine from Access.

Thanks

SurfRat

ChrisM wrote:
Hi,

Do you actually have Access installed on the computers?
Is it possible that you don't have the necessary ODBC drivers
(or
whatever)
to connect to an Access database?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i3g2000cwc.googlegro ups.com...
Hi,

I am having the following problems in getting Microsoft
Visual
Studio
2005 Professional to link to an Access .mdb

database. Please help me to sort this out.

Problem 1:

The Microsoft page "How to: Connect to Data in an Access
Database"

http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx
states
the
following on how to connect to a Access database:

1. On the Data menu, click Add New Data Source.

2. Select Database on the Choose a Data Source Type page.

3. Select New Connection to create a new data connection.

Note
If the Data source is not Microsoft Access Database File,
then
select
Change to open the Choose/Change Data Source

dialog box, select Microsoft Access Database File, and then
click
Continue.
4. The default provider is .NET Framework Provider for OLE
DB.
For
more
information, see Choose/Change Data Source

Dialog Box.

5. In the Database file name box, enter the path to the .mdb
file,
or
click the Browse button to locate the database

file.

6. Enter login information if required by your database. For
more
information, see Add/Modify Connection (Microsoft

Access).

7. Click OK, and then click Next.

In step 5 above it talks of a browse button. I dont't get
that
but
rather am given a dialog box titled Add Connection

and the only option is ConnectionString. I have tried all
sorts
of
options for a connect string but allways get the

error message "Format of the initialization string does not
conform
to
specification starting at index 0"
Problem 2:

From the same page it states: "Drag an .mdf or .mdb file
from
Windows
Explorer into Solution Explorer to

automatically configure your connection and start the Data
Source
Configuration Wizard ready for you to select the

objects to use in your application."

When I drag and drop drop an Access database eg.
Northwind.mdb
into
the
Solution Explorer window I get the following

error: "An eror occurred while processing the local data
file:
Object
reference not set to an instance of an object"

Questions:

1. In problem 1 why don't I get the correct dialog with
browse
functionality? I have Microsoft Visual Studio 2005

Professional installed on my Laptop and my main PC and they
both do
the
same thing. I have all patches and updates

installed.

2. How do I resolve problem 2? I have searched for a
solution
and
and
have found none. I have uninstalled .Net

Framework 2 and reinstalled it with no difference. I think
the
two
problems are related.

Thanks very much for your help.

Surfrat.


Sep 4 '06 #11
Hi,

My only way around this was a complete fresh install of Windows and
Visual Studio. Now VS2005 works correctly.

SurfRat.
ChrisM wrote:
Yuck!

Well, the only thing I can think of is to slowly install all the patches and
apps onto the vanilla PC until it starts to show the same problem. Once
you've identified the patch/application that causes the problem, then you
can start trying to work out how you're going to fix it...

I guess installing Office2003 on the vanilla PC would be a good candidate to
try first, along with any other databasey type applications...

Good luck...!

Chris.

<su******@hotmail.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
Hi,

The vanilla PC has only WinXP and VS2005 with no updates or patches. My
main PC has all the updates and patches for everything and loads of
apps eg. Office 2003, anti virus. My laptop and main PC are both fully
updated and have similar apps. Yes, exactly the same provider is used
in both cases. I also tested the scenario where you can drag a .mdb
file into your project. On the vanilla PC it worked fine but on my main
PC and my laptop I get the error message.

Something is interfearing with the ADO porion of the .Net framework.

Thanks

SurfRat.

ChrisM wrote:
What else is installed on the problem PC that isn't present on the
vanilla
one?

When you get the browse button on the vanilla PC, is it using EXACTLY the
same provider as when it doesn't work on the other one?

Chris.

<su******@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Hi,

I installed VS2005 on another PC with a vanilla copy of XP Pro. The
problem is not present and the browse button is available.

I then uninstalled VS2005, SQL and .Net framework 2.0 and reinstalled
everything and the problem is still there. I am now thinking that the
problem is caused by something else. Ideas would be welcome...

Thanks

SurfRat.

su******@hotmail.com wrote:
Yes there are other data providers...

Dataprovider for ODBC
Dataprovider for SQL server
Dataprovider for SQL server mobile edition
Dataprovider for Oracle

Thanks...

ChrisM wrote:
Hi,

Have to admint that I'm still using VS2003, and how now experience
of
2005.
I was hoping that it would be similar enough for my suggestions to
be
able
to help, but maybe they are too different in this area...

Last thing I can think of:
Can you change the DataProvider that it suggests? Is there any
others
available that mention Access or Jet?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...
Hi Chris,
>
Thanks for your help. I click on new connection and select
"Microsoft
Access database file" at the top under Data Source which in turn
selects ".Net Framework Data Provider for OLE DB" under Data
Provider.
When I then click OK I get the "Add Connection" dialog with only
ConnectionString and no browse button. I will see what help I get
from
the news groups over the weekend and then uninstall Visual Studio
and
.Net Framework 2.0 and try again.
>
Does your VS2005 work correctly? I have Visual Studio 2005 Pro
installed v8.0.50727.42
(RTM.050727-4200) and .Net Framework v2.0.50727. How do these
compare
to you versions?
>
Cheers
>
SurfRat.
>
ChrisM wrote:
>Hmmm, you are selecting the 'Microsoft Jet...' provider aren't
>you?
>>
>Sorry to ask these dumb questions, it just strange the the
>provider
>doens't
>seem to know that you want to open an Access database, and giving
>you the
>correct dialog to select it...
>>
>Cheers,
>>
>Chris.
>>
><su******@hotmail.comwrote in message
>news:11**********************@h48g2000cwc.googleg roups.com...
Hi chris,
>
Yes I have Access 2003 on both machines...
>
I can access the databases fine from Access.
>
Thanks
>
SurfRat
>
ChrisM wrote:
>Hi,
>>
>Do you actually have Access installed on the computers?
>Is it possible that you don't have the necessary ODBC drivers
>(or
>whatever)
>to connect to an Access database?
>>
>Cheers,
>>
>Chris.
>>
><su******@hotmail.comwrote in message
>news:11*********************@i3g2000cwc.googlegro ups.com...
Hi,
>
I am having the following problems in getting Microsoft
Visual
Studio
2005 Professional to link to an Access .mdb
>
database. Please help me to sort this out.
>
Problem 1:
>
The Microsoft page "How to: Connect to Data in an Access
Database"
>
http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx
states
the
following on how to connect to a Access database:
>
1. On the Data menu, click Add New Data Source.
>
2. Select Database on the Choose a Data Source Type page.
>
3. Select New Connection to create a new data connection.
>
Note
If the Data source is not Microsoft Access Database File,
then
select
Change to open the Choose/Change Data Source
>
dialog box, select Microsoft Access Database File, and then
click
Continue.
>
>
4. The default provider is .NET Framework Provider for OLE
DB.
For
more
information, see Choose/Change Data Source
>
Dialog Box.
>
5. In the Database file name box, enter the path to the .mdb
file,
or
click the Browse button to locate the database
>
file.
>
6. Enter login information if required by your database. For
more
information, see Add/Modify Connection (Microsoft
>
Access).
>
7. Click OK, and then click Next.
>
In step 5 above it talks of a browse button. I dont't get
that
but
rather am given a dialog box titled Add Connection
>
and the only option is ConnectionString. I have tried all
sorts
of
options for a connect string but allways get the
>
error message "Format of the initialization string does not
conform
to
specification starting at index 0"
>
>
Problem 2:
>
>>From the same page it states: "Drag an .mdf or .mdb file
>>from
>>Windows
Explorer into Solution Explorer to
>
automatically configure your connection and start the Data
Source
Configuration Wizard ready for you to select the
>
objects to use in your application."
>
When I drag and drop drop an Access database eg.
Northwind.mdb
into
the
Solution Explorer window I get the following
>
error: "An eror occurred while processing the local data
file:
Object
reference not set to an instance of an object"
>
Questions:
>
1. In problem 1 why don't I get the correct dialog with
browse
functionality? I have Microsoft Visual Studio 2005
>
Professional installed on my Laptop and my main PC and they
both do
the
same thing. I have all patches and updates
>
installed.
>
2. How do I resolve problem 2? I have searched for a
solution
and
and
have found none. I have uninstalled .Net
>
Framework 2 and reinstalled it with no difference. I think
the
two
problems are related.
>
Thanks very much for your help.
>
Surfrat.
>
>
>
Sep 18 '06 #12
Oh well, at least you're working again now.
You'll have to try and remember to check it still works everytime you
install/upgrade anything and see ifyou can ever work out what messed it up
in the first place...

<su******@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi,

My only way around this was a complete fresh install of Windows and
Visual Studio. Now VS2005 works correctly.

SurfRat.
ChrisM wrote:
>Yuck!

Well, the only thing I can think of is to slowly install all the patches
and
apps onto the vanilla PC until it starts to show the same problem. Once
you've identified the patch/application that causes the problem, then you
can start trying to work out how you're going to fix it...

I guess installing Office2003 on the vanilla PC would be a good candidate
to
try first, along with any other databasey type applications...

Good luck...!

Chris.

<su******@hotmail.comwrote in message
news:11**********************@e3g2000cwe.googlegr oups.com...
Hi,

The vanilla PC has only WinXP and VS2005 with no updates or patches. My
main PC has all the updates and patches for everything and loads of
apps eg. Office 2003, anti virus. My laptop and main PC are both fully
updated and have similar apps. Yes, exactly the same provider is used
in both cases. I also tested the scenario where you can drag a .mdb
file into your project. On the vanilla PC it worked fine but on my main
PC and my laptop I get the error message.

Something is interfearing with the ADO porion of the .Net framework.

Thanks

SurfRat.

ChrisM wrote:
What else is installed on the problem PC that isn't present on the
vanilla
one?

When you get the browse button on the vanilla PC, is it using EXACTLY
the
same provider as when it doesn't work on the other one?

Chris.

<su******@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googleg roups.com...
Hi,

I installed VS2005 on another PC with a vanilla copy of XP Pro. The
problem is not present and the browse button is available.

I then uninstalled VS2005, SQL and .Net framework 2.0 and
reinstalled
everything and the problem is still there. I am now thinking that
the
problem is caused by something else. Ideas would be welcome...

Thanks

SurfRat.

su******@hotmail.com wrote:
Yes there are other data providers...

Dataprovider for ODBC
Dataprovider for SQL server
Dataprovider for SQL server mobile edition
Dataprovider for Oracle

Thanks...

ChrisM wrote:
Hi,

Have to admint that I'm still using VS2003, and how now
experience
of
2005.
I was hoping that it would be similar enough for my suggestions
to
be
able
to help, but maybe they are too different in this area...

Last thing I can think of:
Can you change the DataProvider that it suggests? Is there any
others
available that mention Access or Jet?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...
Hi Chris,

Thanks for your help. I click on new connection and select
"Microsoft
Access database file" at the top under Data Source which in
turn
selects ".Net Framework Data Provider for OLE DB" under Data
Provider.
When I then click OK I get the "Add Connection" dialog with
only
ConnectionString and no browse button. I will see what help I
get
from
the news groups over the weekend and then uninstall Visual
Studio
and
.Net Framework 2.0 and try again.

Does your VS2005 work correctly? I have Visual Studio 2005 Pro
installed v8.0.50727.42
(RTM.050727-4200) and .Net Framework v2.0.50727. How do these
compare
to you versions?

Cheers

SurfRat.

ChrisM wrote:
Hmmm, you are selecting the 'Microsoft Jet...' provider
aren't
you?

Sorry to ask these dumb questions, it just strange the the
provider
doens't
seem to know that you want to open an Access database, and
giving
you the
correct dialog to select it...

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googleg roups.com...
Hi chris,

Yes I have Access 2003 on both machines...

I can access the databases fine from Access.

Thanks

SurfRat

ChrisM wrote:
Hi,

Do you actually have Access installed on the computers?
Is it possible that you don't have the necessary ODBC
drivers
(or
whatever)
to connect to an Access database?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i3g2000cwc.googlegro ups.com...
Hi,

I am having the following problems in getting Microsoft
Visual
Studio
2005 Professional to link to an Access .mdb

database. Please help me to sort this out.

Problem 1:

The Microsoft page "How to: Connect to Data in an Access
Database"

http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx
states
the
following on how to connect to a Access database:

1. On the Data menu, click Add New Data Source.

2. Select Database on the Choose a Data Source Type page.

3. Select New Connection to create a new data connection.

Note
If the Data source is not Microsoft Access Database File,
then
select
Change to open the Choose/Change Data Source

dialog box, select Microsoft Access Database File, and
then
click
Continue.
4. The default provider is .NET Framework Provider for
OLE
DB.
For
more
information, see Choose/Change Data Source

Dialog Box.

5. In the Database file name box, enter the path to the
.mdb
file,
or
click the Browse button to locate the database

file.

6. Enter login information if required by your database.
For
more
information, see Add/Modify Connection (Microsoft

Access).

7. Click OK, and then click Next.

In step 5 above it talks of a browse button. I dont't get
that
but
rather am given a dialog box titled Add Connection

and the only option is ConnectionString. I have tried all
sorts
of
options for a connect string but allways get the

error message "Format of the initialization string does
not
conform
to
specification starting at index 0"
Problem 2:

From the same page it states: "Drag an .mdf or .mdb file
from
Windows
Explorer into Solution Explorer to

automatically configure your connection and start the
Data
Source
Configuration Wizard ready for you to select the

objects to use in your application."

When I drag and drop drop an Access database eg.
Northwind.mdb
into
the
Solution Explorer window I get the following

error: "An eror occurred while processing the local data
file:
Object
reference not set to an instance of an object"

Questions:

1. In problem 1 why don't I get the correct dialog with
browse
functionality? I have Microsoft Visual Studio 2005

Professional installed on my Laptop and my main PC and
they
both do
the
same thing. I have all patches and updates

installed.

2. How do I resolve problem 2? I have searched for a
solution
and
and
have found none. I have uninstalled .Net

Framework 2 and reinstalled it with no difference. I
think
the
two
problems are related.

Thanks very much for your help.

Surfrat.



Sep 18 '06 #13
I have the same problem. Haven't found any way around this problem yet,
because there isn't an option for me to completely reinstall my
laptop since I am in the middle of a project.
But I think it happens because I have different version of Visual
studio installed. I am using Visual Studio 6.0, Visual studio 2003 and
Visual studio 2005 on my laptop. Some kind of dll hell...
The problem is really frustrating since I have a deadline coming up.
Any help would be appreciated.
ChrisM skrev:
Oh well, at least you're working again now.
You'll have to try and remember to check it still works everytime you
install/upgrade anything and see ifyou can ever work out what messed it up
in the first place...

<su******@hotmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Hi,

My only way around this was a complete fresh install of Windows and
Visual Studio. Now VS2005 works correctly.

SurfRat.
ChrisM wrote:
Yuck!

Well, the only thing I can think of is to slowly install all the patches
and
apps onto the vanilla PC until it starts to show the same problem. Once
you've identified the patch/application that causes the problem, then you
can start trying to work out how you're going to fix it...

I guess installing Office2003 on the vanilla PC would be a good candidate
to
try first, along with any other databasey type applications...

Good luck...!

Chris.

<su******@hotmail.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
Hi,

The vanilla PC has only WinXP and VS2005 with no updates or patches. My
main PC has all the updates and patches for everything and loads of
apps eg. Office 2003, anti virus. My laptop and main PC are both fully
updated and have similar apps. Yes, exactly the same provider is used
in both cases. I also tested the scenario where you can drag a .mdb
file into your project. On the vanilla PC it worked fine but on my main
PC and my laptop I get the error message.

Something is interfearing with the ADO porion of the .Net framework.

Thanks

SurfRat.

ChrisM wrote:
What else is installed on the problem PC that isn't present on the
vanilla
one?

When you get the browse button on the vanilla PC, is it using EXACTLY
the
same provider as when it doesn't work on the other one?

Chris.

<su******@hotmail.comwrote in message
news:11**********************@p79g2000cwp.googlegr oups.com...
Hi,

I installed VS2005 on another PC with a vanilla copy of XP Pro. The
problem is not present and the browse button is available.

I then uninstalled VS2005, SQL and .Net framework 2.0 and
reinstalled
everything and the problem is still there. I am now thinking that
the
problem is caused by something else. Ideas would be welcome...

Thanks

SurfRat.

su******@hotmail.com wrote:
Yes there are other data providers...

Dataprovider for ODBC
Dataprovider for SQL server
Dataprovider for SQL server mobile edition
Dataprovider for Oracle

Thanks...

ChrisM wrote:
Hi,

Have to admint that I'm still using VS2003, and how now
experience
of
2005.
I was hoping that it would be similar enough for my suggestions
to
be
able
to help, but maybe they are too different in this area...

Last thing I can think of:
Can you change the DataProvider that it suggests? Is there any
others
available that mention Access or Jet?

Cheers,

Chris.

<su******@hotmail.comwrote in message
news:11*********************@i42g2000cwa.googlegro ups.com...
Hi Chris,
>
Thanks for your help. I click on new connection and select
"Microsoft
Access database file" at the top under Data Source which in
turn
selects ".Net Framework Data Provider for OLE DB" under Data
Provider.
When I then click OK I get the "Add Connection" dialog with
only
ConnectionString and no browse button. I will see what help I
get
from
the news groups over the weekend and then uninstall Visual
Studio
and
.Net Framework 2.0 and try again.
>
Does your VS2005 work correctly? I have Visual Studio 2005 Pro
installed v8.0.50727.42
(RTM.050727-4200) and .Net Framework v2.0.50727. How do these
compare
to you versions?
>
Cheers
>
SurfRat.
>
ChrisM wrote:
>Hmmm, you are selecting the 'Microsoft Jet...' provider
>aren't
>you?
>>
>Sorry to ask these dumb questions, it just strange the the
>provider
>doens't
>seem to know that you want to open an Access database, and
>giving
>you the
>correct dialog to select it...
>>
>Cheers,
>>
>Chris.
>>
><su******@hotmail.comwrote in message
>news:11**********************@h48g2000cwc.googleg roups.com...
Hi chris,
>
Yes I have Access 2003 on both machines...
>
I can access the databases fine from Access.
>
Thanks
>
SurfRat
>
ChrisM wrote:
>Hi,
>>
>Do you actually have Access installed on the computers?
>Is it possible that you don't have the necessary ODBC
>drivers
>(or
>whatever)
>to connect to an Access database?
>>
>Cheers,
>>
>Chris.
>>
><su******@hotmail.comwrote in message
>news:11*********************@i3g2000cwc.googlegro ups.com...
Hi,
>
I am having the following problems in getting Microsoft
Visual
Studio
2005 Professional to link to an Access .mdb
>
database. Please help me to sort this out.
>
Problem 1:
>
The Microsoft page "How to: Connect to Data in an Access
Database"
>
http://msdn2.microsoft.com/en-us/library/cf131f6b.aspx
states
the
following on how to connect to a Access database:
>
1. On the Data menu, click Add New Data Source.
>
2. Select Database on the Choose a Data Source Type page.
>
3. Select New Connection to create a new data connection.
>
Note
If the Data source is not Microsoft Access Database File,
then
select
Change to open the Choose/Change Data Source
>
dialog box, select Microsoft Access Database File, and
then
click
Continue.
>
>
4. The default provider is .NET Framework Provider for
OLE
DB.
For
more
information, see Choose/Change Data Source
>
Dialog Box.
>
5. In the Database file name box, enter the path to the
.mdb
file,
or
click the Browse button to locate the database
>
file.
>
6. Enter login information if required by your database.
For
more
information, see Add/Modify Connection (Microsoft
>
Access).
>
7. Click OK, and then click Next.
>
In step 5 above it talks of a browse button. I dont't get
that
but
rather am given a dialog box titled Add Connection
>
and the only option is ConnectionString. I have tried all
sorts
of
options for a connect string but allways get the
>
error message "Format of the initialization string does
not
conform
to
specification starting at index 0"
>
>
Problem 2:
>
>>From the same page it states: "Drag an .mdf or .mdb file
>>from
>>Windows
Explorer into Solution Explorer to
>
automatically configure your connection and start the
Data
Source
Configuration Wizard ready for you to select the
>
objects to use in your application."
>
When I drag and drop drop an Access database eg.
Northwind.mdb
into
the
Solution Explorer window I get the following
>
error: "An eror occurred while processing the local data
file:
Object
reference not set to an instance of an object"
>
Questions:
>
1. In problem 1 why don't I get the correct dialog with
browse
functionality? I have Microsoft Visual Studio 2005
>
Professional installed on my Laptop and my main PC and
they
both do
the
same thing. I have all patches and updates
>
installed.
>
2. How do I resolve problem 2? I have searched for a
solution
and
and
have found none. I have uninstalled .Net
>
Framework 2 and reinstalled it with no difference. I
think
the
two
problems are related.
>
Thanks very much for your help.
>
Surfrat.
>
>
>
Sep 25 '06 #14
"ChrisM" <ch**************@suedeyahoo.comwrote in message
news:89******************************@bt.com...
Oh well, at least you're working again now.
You'll have to try and remember to check it still works everytime you
install/upgrade anything and see ifyou can ever work out what messed it up
in the first place...
I've got exactly the same problem, not sure what's causing it yet either...
Sep 25 '06 #15
I Highly recomend that you download the FREE Virtual PC from Microsoft.
It lets you create a Virgin environment, then copy the .vhd file and
maintain a virgin install for any purpose you choose, like testing etc.
You can then delete the original and copy is back in a few seconds and
have a brand new install to test with again. Its a GREAT Free Tool

In article <45*********************@ptn-nntp-reader03.plus.net>, "Liddle
Feesh" <liddlefeesh]at[gmail.comsays...
"ChrisM" <ch**************@suedeyahoo.comwrote in message
news:89******************************@bt.com...
Oh well, at least you're working again now.
You'll have to try and remember to check it still works everytime you
install/upgrade anything and see ifyou can ever work out what messed it up
in the first place...

I've got exactly the same problem, not sure what's causing it yet either...
Sep 27 '06 #16
I'd second that.
Totally fantastic tool. When I was doing one project, I had 3 virtual PCs
running on my desktop. One running XP, one 2000 and one Win95. Could copy
environments, return a PC to 'virgin' status etc etc all in a few moments.

As Curt says, really really good tool.

Chris.

"Curt" <No***@Anywhere.comwrote in message
news:MP************************@news-server.tampabay.rr.com...
>I Highly recomend that you download the FREE Virtual PC from Microsoft.
It lets you create a Virgin environment, then copy the .vhd file and
maintain a virgin install for any purpose you choose, like testing etc.
You can then delete the original and copy is back in a few seconds and
have a brand new install to test with again. Its a GREAT Free Tool

In article <45*********************@ptn-nntp-reader03.plus.net>, "Liddle
Feesh" <liddlefeesh]at[gmail.comsays...
>"ChrisM" <ch**************@suedeyahoo.comwrote in message
news:89******************************@bt.com...
Oh well, at least you're working again now.
You'll have to try and remember to check it still works everytime you
install/upgrade anything and see ifyou can ever work out what messed it
up
in the first place...

I've got exactly the same problem, not sure what's causing it yet
either...

Sep 27 '06 #17
I know and I am using it especially for testing clients in a clean
environment. But I think there is a little performance issue when you
are developing through Virtual PC.
Anyway it does not help me to get my laptop and environment good again
without reinstalling windows:-|

-Vemund

ChrisM skrev:
I'd second that.
Totally fantastic tool. When I was doing one project, I had 3 virtual PCs
running on my desktop. One running XP, one 2000 and one Win95. Could copy
environments, return a PC to 'virgin' status etc etc all in a few moments.

As Curt says, really really good tool.

Chris.

"Curt" <No***@Anywhere.comwrote in message
news:MP************************@news-server.tampabay.rr.com...
I Highly recomend that you download the FREE Virtual PC from Microsoft.
It lets you create a Virgin environment, then copy the .vhd file and
maintain a virgin install for any purpose you choose, like testing etc.
You can then delete the original and copy is back in a few seconds and
have a brand new install to test with again. Its a GREAT Free Tool

In article <45*********************@ptn-nntp-reader03.plus.net>, "Liddle
Feesh" <liddlefeesh]at[gmail.comsays...
"ChrisM" <ch**************@suedeyahoo.comwrote in message
news:89******************************@bt.com...
Oh well, at least you're working again now.
You'll have to try and remember to check it still works everytime you
install/upgrade anything and see ifyou can ever work out what messed it
up
in the first place...

I've got exactly the same problem, not sure what's causing it yet
either...
Sep 28 '06 #18
Yea, Ok. Apologies for my somewhat off topic post.

You are right. I don't think that DEVELOPING on a Virtual PC would be, in
any way, a good idea!

Do you actually need all 3 versions of VS on you laptop for this current
project you're working on?
If you suspect this to be the problem, can't you uninstall anything you
don't need for this project and maybe (just maybe) it could help... :-/

As a last resort, and if it is causing you severe problems, I can't see why
you can't back up all your project files and test data and whatever else.
ReInstall your laptop, then restore all the project stuff. Might be a pain
in the a** and take some effort, but might be worth it in the long run... ?

Chris.

"vemund" <ve*********@yahoo.nowrote in message
news:11*********************@b28g2000cwb.googlegro ups.com...
>I know and I am using it especially for testing clients in a clean
environment. But I think there is a little performance issue when you
are developing through Virtual PC.
Anyway it does not help me to get my laptop and environment good again
without reinstalling windows:-|

-Vemund

ChrisM skrev:
>I'd second that.
Totally fantastic tool. When I was doing one project, I had 3 virtual PCs
running on my desktop. One running XP, one 2000 and one Win95. Could copy
environments, return a PC to 'virgin' status etc etc all in a few
moments.

As Curt says, really really good tool.

Chris.

"Curt" <No***@Anywhere.comwrote in message
news:MP************************@news-server.tampabay.rr.com...
>I Highly recomend that you download the FREE Virtual PC from Microsoft.
It lets you create a Virgin environment, then copy the .vhd file and
maintain a virgin install for any purpose you choose, like testing etc.
You can then delete the original and copy is back in a few seconds and
have a brand new install to test with again. Its a GREAT Free Tool

In article <45*********************@ptn-nntp-reader03.plus.net>,
"Liddle
Feesh" <liddlefeesh]at[gmail.comsays...
"ChrisM" <ch**************@suedeyahoo.comwrote in message
news:89******************************@bt.com...
Oh well, at least you're working again now.
You'll have to try and remember to check it still works everytime
you
install/upgrade anything and see ifyou can ever work out what messed
it
up
in the first place...

I've got exactly the same problem, not sure what's causing it yet
either...

Sep 28 '06 #19

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

11
by: olle | last post by:
Hi everyone. I am an Access developer having worked with Access-dev. projects for many years on Sql server databases and Access. For the internet I have been using traditional asp. But now I have...
5
by: Nathan Sokalski | last post by:
I recently upgraded from Visual Studio .NET 2003 to Visual Studio .NET 2005. Visual Studio .NET 2005 does not create the Global.asax files that Visual Studio .NET 2003 did, which I used for...
3
by: Hansen | last post by:
I hope that there is someone here that can help me. It's not directly related to this group but maybe someone here can help me. I wanted to deploy my Access database to another pc using the Access...
5
by: kbutterly | last post by:
Good morning all, I have a weird problem with my VS 2005 Documentation. When I open the help file through Start -Visual Studion 2005 ->Visual Studio 2005 Documentation, I get what appears to be...
3
by: Edwin Smith | last post by:
I have a 2 form project in VS2005 that now hangs whenever I try to do anything with the second form. This seems to have started when I added some SQL tables from a Pervasive v.9 database using the...
5
by: dougdoc | last post by:
We are exploring doing some development with MS Visual Studio 2005 to access our DB2 UDB for Windows databases. Are there any other options to accessing DB2 with Visual Studio that may be more...
0
by: fiona | last post by:
Reading, Berkshire, UK 05 June 2007 - Crainiate Software make details available of the release of Objecto Framework 2.0, an upgrade to their enterprise business component framework, designed to...
1
by: bharathreddy | last post by:
This Article gives an introduction to VSTS Team Foundation & fundamental difference between Visual Source Safe (VSS) and VSTS Team Foundation. Team Foundation is a set of tools and technologies...
4
by: Cindy H | last post by:
Hi I am currently using Visual Studio.Net 2003 running on Windows Server 2000 operating system. I have used Visual Studio.net 2003 connecting to Access 2002 databases in the pass with great...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.