DataAdapter vs Coding

[TJ Doherty]

Need help understanding the following please:

When I am creating a project and code my connection using Dim connectString
As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=C:\Temp\ NW-test.MDB", everything works correctly when I run the
project.

However, if I set up the exact same connection using the DataAdapter wizard
and try to run the project, I get a "Microsoft Jet database engine cannot
open the file..." error.

I don't understand why the project runs correctly using the "coded"
connection but always fails when using the DataAdapter wizard.

Any assistance would be greatly appreciated.

Thanks,

TJ

[Scott M.]

With a DataAdapter, you still set up your connection as normal (connection
string and all).

Dim con as New OleDb.OleDbConn ection("Provide r=...")
Dim da as New OleDb.OleDbData Adapter("SELECT .... FROM ...", con)
Dim ds as New DataSet
da.Fill(ds,srcT ableName)

At this point you will have a DataSet containing a table that contains
whatever data your SELECT specified.
"TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
news:95******** *************** ***********@mic rosoft.com...

Need help understanding the following please:

When I am creating a project and code my connection using Dim
connectString
As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=C:\Temp\ NW-test.MDB", everything works correctly when I run the
project.

However, if I set up the exact same connection using the DataAdapter
wizard
and try to run the project, I get a "Microsoft Jet database engine cannot
open the file..." error.

I don't understand why the project runs correctly using the "coded"
connection but always fails when using the DataAdapter wizard.

Any assistance would be greatly appreciated.

Thanks,

TJ

[Jeff Dillon]

He asked why the Wizard is failing

"Scott M." <s-***@nospam.nosp am> wrote in message
news:ez******** ******@TK2MSFTN GP09.phx.gbl...

With a DataAdapter, you still set up your connection as normal (connection
string and all).

Dim con as New OleDb.OleDbConn ection("Provide r=...")
Dim da as New OleDb.OleDbData Adapter("SELECT .... FROM ...", con)
Dim ds as New DataSet
da.Fill(ds,srcT ableName)

At this point you will have a DataSet containing a table that contains
whatever data your SELECT specified.
"TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
news:95******** *************** ***********@mic rosoft.com...

Need help understanding the following please:

When I am creating a project and code my connection using Dim
connectString
As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
Source=C:\Temp\ NW-test.MDB", everything works correctly when I run the
project.

However, if I set up the exact same connection using the DataAdapter
wizard
and try to run the project, I get a "Microsoft Jet database engine cannot open the file..." error.

I don't understand why the project runs correctly using the "coded"
connection but always fails when using the DataAdapter wizard.

Any assistance would be greatly appreciated.

Thanks,

TJ

[Scott M.]

Actually, he said that he set up a DataAdapter using the wizard and that
when the project runs, it fails. He did not say that the wizard fails. So,
by using my code below (or by using the wizard to generate the code below),
he can see if he has a VS problem or just a coding problem. (I suspect that
he didn't use the da.fill which you need to still write even if you use the
wizard).
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ur******** ******@TK2MSFTN GP09.phx.gbl...

He asked why the Wizard is failing

"Scott M." <s-***@nospam.nosp am> wrote in message
news:ez******** ******@TK2MSFTN GP09.phx.gbl...

With a DataAdapter, you still set up your connection as normal
(connection
string and all).

Dim con as New OleDb.OleDbConn ection("Provide r=...")
Dim da as New OleDb.OleDbData Adapter("SELECT .... FROM ...", con)
Dim ds as New DataSet
da.Fill(ds,srcT ableName)

At this point you will have a DataSet containing a table that contains
whatever data your SELECT specified.
"TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
news:95******** *************** ***********@mic rosoft.com...

> Need help understanding the following please:
>
> When I am creating a project and code my connection using Dim
> connectString
> As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
> Source=C:\Temp\ NW-test.MDB", everything works correctly when I run the
> project.
>
> However, if I set up the exact same connection using the DataAdapter
> wizard
> and try to run the project, I get a "Microsoft Jet database engine cannot > open the file..." error.
>
> I don't understand why the project runs correctly using the "coded"
> connection but always fails when using the DataAdapter wizard.
>
> Any assistance would be greatly appreciated.
>
> Thanks,
>
> TJ

[TJ Doherty]

Scott -

As Jeff suggests, it's what the wizard creates that's failing to connect and
I don't understand why. Obviously, I can get a good connection if I code it,
but what I don't understand is why it doesn't work using the code the wizard
generates. FWIW, I did use the da.fill and the binding process following the
wizard setup. My problem is not in getting it to work using the proper code
but rather it's not working using wizard generated code and I don't
understand why.

Regards,

TJ Doherty

"Scott M." wrote:

Actually, he said that he set up a DataAdapter using the wizard and that
when the project runs, it fails. He did not say that the wizard fails. So,
by using my code below (or by using the wizard to generate the code below),
he can see if he has a VS problem or just a coding problem. (I suspect that
he didn't use the da.fill which you need to still write even if you use the
wizard).
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ur******** ******@TK2MSFTN GP09.phx.gbl...

He asked why the Wizard is failing

"Scott M." <s-***@nospam.nosp am> wrote in message
news:ez******** ******@TK2MSFTN GP09.phx.gbl...

With a DataAdapter, you still set up your connection as normal
(connection
string and all).

Dim con as New OleDb.OleDbConn ection("Provide r=...")
Dim da as New OleDb.OleDbData Adapter("SELECT .... FROM ...", con)
Dim ds as New DataSet
da.Fill(ds,srcT ableName)

At this point you will have a DataSet containing a table that contains
whatever data your SELECT specified.
"TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
news:95******** *************** ***********@mic rosoft.com...
> Need help understanding the following please:
>
> When I am creating a project and code my connection using Dim
> connectString
> As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
> Source=C:\Temp\ NW-test.MDB", everything works correctly when I run the
> project.
>
> However, if I set up the exact same connection using the DataAdapter
> wizard
> and try to run the project, I get a "Microsoft Jet database engine

cannot

> open the file..." error.
>
> I don't understand why the project runs correctly using the "coded"
> connection but always fails when using the DataAdapter wizard.
>
> Any assistance would be greatly appreciated.
>
> Thanks,
>
> TJ

[Scott M.]

We would need to see the code that the wizard created for you.

"TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
news:7E******** *************** ***********@mic rosoft.com...

Scott -

As Jeff suggests, it's what the wizard creates that's failing to connect
and
I don't understand why. Obviously, I can get a good connection if I code
it,
but what I don't understand is why it doesn't work using the code the
wizard
generates. FWIW, I did use the da.fill and the binding process following
the
wizard setup. My problem is not in getting it to work using the proper
code
but rather it's not working using wizard generated code and I don't
understand why.

Regards,

TJ Doherty

"Scott M." wrote:

Actually, he said that he set up a DataAdapter using the wizard and that
when the project runs, it fails. He did not say that the wizard fails.
So,
by using my code below (or by using the wizard to generate the code
below),
he can see if he has a VS problem or just a coding problem. (I suspect
that
he didn't use the da.fill which you need to still write even if you use
the
wizard).
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ur******** ******@TK2MSFTN GP09.phx.gbl...

> He asked why the Wizard is failing
>
> "Scott M." <s-***@nospam.nosp am> wrote in message
> news:ez******** ******@TK2MSFTN GP09.phx.gbl...
>> With a DataAdapter, you still set up your connection as normal
>> (connection
>> string and all).
>>
>> Dim con as New OleDb.OleDbConn ection("Provide r=...")
>> Dim da as New OleDb.OleDbData Adapter("SELECT .... FROM ...", con)
>> Dim ds as New DataSet
>> da.Fill(ds,srcT ableName)
>>
>> At this point you will have a DataSet containing a table that contains
>> whatever data your SELECT specified.
>>
>>
>> "TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
>> news:95******** *************** ***********@mic rosoft.com...
>> > Need help understanding the following please:
>> >
>> > When I am creating a project and code my connection using Dim
>> > connectString
>> > As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
>> > Source=C:\Temp\ NW-test.MDB", everything works correctly when I run
>> > the
>> > project.
>> >
>> > However, if I set up the exact same connection using the DataAdapter
>> > wizard
>> > and try to run the project, I get a "Microsoft Jet database engine
> cannot
>> > open the file..." error.
>> >
>> > I don't understand why the project runs correctly using the "coded"
>> > connection but always fails when using the DataAdapter wizard.
>> >
>> > Any assistance would be greatly appreciated.
>> >
>> > Thanks,
>> >
>> > TJ
>>
>>
>
>

[Jeff Dillon]

Oh, he WAS asking why the wizard was failing :-)

I had a similar problem with the wizard, but coding works. I didn't want to
spend the time to determine why the wizard was failing, since I had a work
around.

Jeff
"Scott M." <s-***@nospam.nosp am> wrote in message
news:uI******** ******@TK2MSFTN GP15.phx.gbl...

We would need to see the code that the wizard created for you.

"TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
news:7E******** *************** ***********@mic rosoft.com...

Scott -

As Jeff suggests, it's what the wizard creates that's failing to connect
and
I don't understand why. Obviously, I can get a good connection if I code it,
but what I don't understand is why it doesn't work using the code the
wizard
generates. FWIW, I did use the da.fill and the binding process following the
wizard setup. My problem is not in getting it to work using the proper
code
but rather it's not working using wizard generated code and I don't
understand why.

Regards,

TJ Doherty

"Scott M." wrote:

Actually, he said that he set up a DataAdapter using the wizard and that when the project runs, it fails. He did not say that the wizard fails.
So,
by using my code below (or by using the wizard to generate the code
below),
he can see if he has a VS problem or just a coding problem. (I suspect
that
he didn't use the da.fill which you need to still write even if you use
the
wizard).
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ur******** ******@TK2MSFTN GP09.phx.gbl...
> He asked why the Wizard is failing
>
> "Scott M." <s-***@nospam.nosp am> wrote in message
> news:ez******** ******@TK2MSFTN GP09.phx.gbl...
>> With a DataAdapter, you still set up your connection as normal
>> (connection
>> string and all).
>>
>> Dim con as New OleDb.OleDbConn ection("Provide r=...")
>> Dim da as New OleDb.OleDbData Adapter("SELECT .... FROM ...", con)
>> Dim ds as New DataSet
>> da.Fill(ds,srcT ableName)
>>
>> At this point you will have a DataSet containing a table that contains >> whatever data your SELECT specified.
>>
>>
>> "TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
>> news:95******** *************** ***********@mic rosoft.com...
>> > Need help understanding the following please:
>> >
>> > When I am creating a project and code my connection using Dim
>> > connectString
>> > As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
>> > Source=C:\Temp\ NW-test.MDB", everything works correctly when I run
>> > the
>> > project.
>> >
>> > However, if I set up the exact same connection using the DataAdapter >> > wizard
>> > and try to run the project, I get a "Microsoft Jet database engine
> cannot
>> > open the file..." error.
>> >
>> > I don't understand why the project runs correctly using the "coded" >> > connection but always fails when using the DataAdapter wizard.
>> >
>> > Any assistance would be greatly appreciated.
>> >
>> > Thanks,
>> >
>> > TJ
>>
>>
>
>

[Scott M.]

Actually, I wouldn't say that. He's asking why the code generated by the
wizard fails. The wizard itself doesn't fail and this was my point. :)
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ex******** ******@TK2MSFTN GP09.phx.gbl...

Oh, he WAS asking why the wizard was failing :-)

I had a similar problem with the wizard, but coding works. I didn't want
to
spend the time to determine why the wizard was failing, since I had a work
around.

Jeff
"Scott M." <s-***@nospam.nosp am> wrote in message
news:uI******** ******@TK2MSFTN GP15.phx.gbl...

We would need to see the code that the wizard created for you.

"TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
news:7E******** *************** ***********@mic rosoft.com...

> Scott -
>
> As Jeff suggests, it's what the wizard creates that's failing to
> connect
> and
> I don't understand why. Obviously, I can get a good connection if I code > it,
> but what I don't understand is why it doesn't work using the code the
> wizard
> generates. FWIW, I did use the da.fill and the binding process following > the
> wizard setup. My problem is not in getting it to work using the proper
> code
> but rather it's not working using wizard generated code and I don't
> understand why.
>
> Regards,
>
> TJ Doherty
>
> "Scott M." wrote:
>
>> Actually, he said that he set up a DataAdapter using the wizard and that >> when the project runs, it fails. He did not say that the wizard
>> fails.
>> So,
>> by using my code below (or by using the wizard to generate the code
>> below),
>> he can see if he has a VS problem or just a coding problem. (I
>> suspect
>> that
>> he didn't use the da.fill which you need to still write even if you
>> use
>> the
>> wizard).
>>
>>
>> "Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
>> news:ur******** ******@TK2MSFTN GP09.phx.gbl...
>> > He asked why the Wizard is failing
>> >
>> > "Scott M." <s-***@nospam.nosp am> wrote in message
>> > news:ez******** ******@TK2MSFTN GP09.phx.gbl...
>> >> With a DataAdapter, you still set up your connection as normal
>> >> (connection
>> >> string and all).
>> >>
>> >> Dim con as New OleDb.OleDbConn ection("Provide r=...")
>> >> Dim da as New OleDb.OleDbData Adapter("SELECT .... FROM ...", con)
>> >> Dim ds as New DataSet
>> >> da.Fill(ds,srcT ableName)
>> >>
>> >> At this point you will have a DataSet containing a table that contains >> >> whatever data your SELECT specified.
>> >>
>> >>
>> >> "TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
>> >> news:95******** *************** ***********@mic rosoft.com...
>> >> > Need help understanding the following please:
>> >> >
>> >> > When I am creating a project and code my connection using Dim
>> >> > connectString
>> >> > As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
>> >> > Source=C:\Temp\ NW-test.MDB", everything works correctly when I
>> >> > run
>> >> > the
>> >> > project.
>> >> >
>> >> > However, if I set up the exact same connection using the DataAdapter >> >> > wizard
>> >> > and try to run the project, I get a "Microsoft Jet database
>> >> > engine
>> > cannot
>> >> > open the file..." error.
>> >> >
>> >> > I don't understand why the project runs correctly using the "coded" >> >> > connection but always fails when using the DataAdapter wizard.
>> >> >
>> >> > Any assistance would be greatly appreciated.
>> >> >
>> >> > Thanks,
>> >> >
>> >> > TJ
>> >>
>> >>
>> >
>> >
>>
>>
>>

[Jeff Dillon]

No, the wizard WAS failing..it was failing to create the proper code.

Jeff

"Scott M." <s-***@nospam.nosp am> wrote in message
news:OQ******** ******@TK2MSFTN GP15.phx.gbl...

Actually, I wouldn't say that. He's asking why the code generated by the
wizard fails. The wizard itself doesn't fail and this was my point. :)
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ex******** ******@TK2MSFTN GP09.phx.gbl...

Oh, he WAS asking why the wizard was failing :-)

I had a similar problem with the wizard, but coding works. I didn't want
to
spend the time to determine why the wizard was failing, since I had a work around.

Jeff
"Scott M." <s-***@nospam.nosp am> wrote in message
news:uI******** ******@TK2MSFTN GP15.phx.gbl...

We would need to see the code that the wizard created for you.

"TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
news:7E******** *************** ***********@mic rosoft.com...
> Scott -
>
> As Jeff suggests, it's what the wizard creates that's failing to
> connect
> and
> I don't understand why. Obviously, I can get a good connection if I

code

> it,
> but what I don't understand is why it doesn't work using the code the
> wizard
> generates. FWIW, I did use the da.fill and the binding process

following

> the
> wizard setup. My problem is not in getting it to work using the proper > code
> but rather it's not working using wizard generated code and I don't
> understand why.
>
> Regards,
>
> TJ Doherty
>
> "Scott M." wrote:
>
>> Actually, he said that he set up a DataAdapter using the wizard and

that

>> when the project runs, it fails. He did not say that the wizard
>> fails.
>> So,
>> by using my code below (or by using the wizard to generate the code
>> below),
>> he can see if he has a VS problem or just a coding problem. (I
>> suspect
>> that
>> he didn't use the da.fill which you need to still write even if you
>> use
>> the
>> wizard).
>>
>>
>> "Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
>> news:ur******** ******@TK2MSFTN GP09.phx.gbl...
>> > He asked why the Wizard is failing
>> >
>> > "Scott M." <s-***@nospam.nosp am> wrote in message
>> > news:ez******** ******@TK2MSFTN GP09.phx.gbl...
>> >> With a DataAdapter, you still set up your connection as normal
>> >> (connection
>> >> string and all).
>> >>
>> >> Dim con as New OleDb.OleDbConn ection("Provide r=...")
>> >> Dim da as New OleDb.OleDbData Adapter("SELECT .... FROM ...", con)
>> >> Dim ds as New DataSet
>> >> da.Fill(ds,srcT ableName)
>> >>
>> >> At this point you will have a DataSet containing a table that

contains

>> >> whatever data your SELECT specified.
>> >>
>> >>
>> >> "TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message >> >> news:95******** *************** ***********@mic rosoft.com...
>> >> > Need help understanding the following please:
>> >> >
>> >> > When I am creating a project and code my connection using Dim
>> >> > connectString
>> >> > As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
>> >> > Source=C:\Temp\ NW-test.MDB", everything works correctly when I
>> >> > run
>> >> > the
>> >> > project.
>> >> >
>> >> > However, if I set up the exact same connection using the

DataAdapter

>> >> > wizard
>> >> > and try to run the project, I get a "Microsoft Jet database
>> >> > engine
>> > cannot
>> >> > open the file..." error.
>> >> >
>> >> > I don't understand why the project runs correctly using the

"coded"

>> >> > connection but always fails when using the DataAdapter wizard.
>> >> >
>> >> > Any assistance would be greatly appreciated.
>> >> >
>> >> > Thanks,
>> >> >
>> >> > TJ
>> >>
>> >>
>> >
>> >
>>
>>
>>

[Scott M.]

Semantics here Jeff. The OP was able to move through and use the features
in all of the screens of the wizard. In that sense, the wizard did not
fail.

It actually has yet to be seen if the code generated by the wizard is at
fault as well, since we haven't seen the OP give us that code yet.

"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:uN******** ******@tk2msftn gp13.phx.gbl...

No, the wizard WAS failing..it was failing to create the proper code.

Jeff

"Scott M." <s-***@nospam.nosp am> wrote in message
news:OQ******** ******@TK2MSFTN GP15.phx.gbl...

Actually, I wouldn't say that. He's asking why the code generated by the
wizard fails. The wizard itself doesn't fail and this was my point. :)
"Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
news:ex******** ******@TK2MSFTN GP09.phx.gbl...

> Oh, he WAS asking why the wizard was failing :-)
>
> I had a similar problem with the wizard, but coding works. I didn't
> want
> to
> spend the time to determine why the wizard was failing, since I had a work > around.
>
> Jeff
> "Scott M." <s-***@nospam.nosp am> wrote in message
> news:uI******** ******@TK2MSFTN GP15.phx.gbl...
>> We would need to see the code that the wizard created for you.
>>
>> "TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message
>> news:7E******** *************** ***********@mic rosoft.com...
>> > Scott -
>> >
>> > As Jeff suggests, it's what the wizard creates that's failing to
>> > connect
>> > and
>> > I don't understand why. Obviously, I can get a good connection if I
> code
>> > it,
>> > but what I don't understand is why it doesn't work using the code
>> > the
>> > wizard
>> > generates. FWIW, I did use the da.fill and the binding process
> following
>> > the
>> > wizard setup. My problem is not in getting it to work using the proper >> > code
>> > but rather it's not working using wizard generated code and I don't
>> > understand why.
>> >
>> > Regards,
>> >
>> > TJ Doherty
>> >
>> > "Scott M." wrote:
>> >
>> >> Actually, he said that he set up a DataAdapter using the wizard and
> that
>> >> when the project runs, it fails. He did not say that the wizard
>> >> fails.
>> >> So,
>> >> by using my code below (or by using the wizard to generate the code
>> >> below),
>> >> he can see if he has a VS problem or just a coding problem. (I
>> >> suspect
>> >> that
>> >> he didn't use the da.fill which you need to still write even if you
>> >> use
>> >> the
>> >> wizard).
>> >>
>> >>
>> >> "Jeff Dillon" <je**@removeeme rgencyreporting .com> wrote in message
>> >> news:ur******** ******@TK2MSFTN GP09.phx.gbl...
>> >> > He asked why the Wizard is failing
>> >> >
>> >> > "Scott M." <s-***@nospam.nosp am> wrote in message
>> >> > news:ez******** ******@TK2MSFTN GP09.phx.gbl...
>> >> >> With a DataAdapter, you still set up your connection as normal
>> >> >> (connection
>> >> >> string and all).
>> >> >>
>> >> >> Dim con as New OleDb.OleDbConn ection("Provide r=...")
>> >> >> Dim da as New OleDb.OleDbData Adapter("SELECT .... FROM ...",
>> >> >> con)
>> >> >> Dim ds as New DataSet
>> >> >> da.Fill(ds,srcT ableName)
>> >> >>
>> >> >> At this point you will have a DataSet containing a table that
> contains
>> >> >> whatever data your SELECT specified.
>> >> >>
>> >> >>
>> >> >> "TJ Doherty" <TJ*******@disc ussions.microso ft.com> wrote in message >> >> >> news:95******** *************** ***********@mic rosoft.com...
>> >> >> > Need help understanding the following please:
>> >> >> >
>> >> >> > When I am creating a project and code my connection using Dim
>> >> >> > connectString
>> >> >> > As String = "Provider=Micro soft.Jet.OLEDB. 4.0;" & "Data
>> >> >> > Source=C:\Temp\ NW-test.MDB", everything works correctly when I
>> >> >> > run
>> >> >> > the
>> >> >> > project.
>> >> >> >
>> >> >> > However, if I set up the exact same connection using the
> DataAdapter
>> >> >> > wizard
>> >> >> > and try to run the project, I get a "Microsoft Jet database
>> >> >> > engine
>> >> > cannot
>> >> >> > open the file..." error.
>> >> >> >
>> >> >> > I don't understand why the project runs correctly using the
> "coded"
>> >> >> > connection but always fails when using the DataAdapter wizard.
>> >> >> >
>> >> >> > Any assistance would be greatly appreciated.
>> >> >> >
>> >> >> > Thanks,
>> >> >> >
>> >> >> > TJ
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>
>