ole db specification

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I'm trying to use the server explorer and toolbox data to
access my Access database - is this a good idea? or should
I just use my own code?

I'm getting an error message displayed when I try to drag
table fields from the server explorer onto the web page
(so that it will automatically create the connection and
produce the sql statement using the query builder).
The error message says that the "format of the
initialization string does not conform to the OLE DB
specification".

Thanks in advance
 
¤ Hi
¤
¤ I'm trying to use the server explorer and toolbox data to
¤ access my Access database - is this a good idea? or should
¤ I just use my own code?
¤
¤ I'm getting an error message displayed when I try to drag
¤ table fields from the server explorer onto the web page
¤ (so that it will automatically create the connection and
¤ produce the sql statement using the query builder).
¤ The error message says that the "format of the
¤ initialization string does not conform to the OLE DB
¤ specification".

Are you actually using the Jet OLEDB provider when you build the Data Connection. What is the
ConnectionString property value after you have created the connection?


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Hi Paul

Thanks for replying.

But what do you mean by the Jet OLEDB provider? I'm doing
all this in .net studio.

And how do I find out the ConnectionString property value?

-----Original Message-----
¤ Hi
¤
¤ I'm trying to use the server explorer and toolbox data to
¤ access my Access database - is this a good idea? or should
¤ I just use my own code?
¤
¤ I'm getting an error message displayed when I try to drag
¤ table fields from the server explorer onto the web page
¤ (so that it will automatically create the connection and
¤ produce the sql statement using the query builder).
¤ The error message says that the "format of the
¤ initialization string does not conform to the OLE DB
¤ specification".

Are you actually using the Jet OLEDB provider when you
Click to expand...
build the Data Connection. What is the
Click to expand...
 
¤ Hi Paul
¤
¤ Thanks for replying.
¤
¤ But what do you mean by the Jet OLEDB provider? I'm doing
¤ all this in .net studio.
¤
¤ And how do I find out the ConnectionString property value?
¤
¤

You indicated you are using Server Explorer. I'm assuming you're adding a Data Connection, is this
correct? When you do this a Data Link dialog is displayed with several tabs. The Provider tab
enables you to select the Microsoft Jet 4.0 OLEDB Provider. Is this what you are doing?

When you select the connection you've added to Server Explorer the ConnectionString displays (with
other properties) in the Properties window.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Hi Paul

Yes, I am adding a data connection and I'm selecting
Microsoft Jet 4.0 OLEDB as the provider. I test the
connection and it's fine and the connectionstring is
displayed in the properties window correctly.

The next thing I go to do is to either drag fields from
the tables (in server explorer) or use the
oledbdataadapter (and use querybuilder) to set up my
queries. Oddly I am now not getting the error message!!
All I did was delete my data connection and then reboot my
pc and start again. So my problem appears to have gone
away.

But I'd like to understand the best way to set up
queries. If I do it as above then are these queries just
stored and not so easily accessible but maybe the code is
faster??? And if I write them into my code I can see them
but maybe the code is slower???
What's the best approach?

Thanks in advance
-----Original Message-----
¤ Hi Paul
¤
¤ Thanks for replying.
¤
¤ But what do you mean by the Jet OLEDB provider? I'm doing
¤ all this in .net studio.
¤
¤ And how do I find out the ConnectionString property value?
¤
¤

You indicated you are using Server Explorer. I'm assuming
Click to expand...
you're adding a Data Connection, is this
correct? When you do this a Data Link dialog is displayed
Click to expand...
with several tabs. The Provider tab
enables you to select the Microsoft Jet 4.0 OLEDB
Click to expand...
Provider. Is this what you are doing?
When you select the connection you've added to Server
Click to expand...
Explorer the ConnectionString displays (with
Click to expand...
 
¤ Hi Paul
¤
¤ Yes, I am adding a data connection and I'm selecting
¤ Microsoft Jet 4.0 OLEDB as the provider. I test the
¤ connection and it's fine and the connectionstring is
¤ displayed in the properties window correctly.
¤
¤ The next thing I go to do is to either drag fields from
¤ the tables (in server explorer) or use the
¤ oledbdataadapter (and use querybuilder) to set up my
¤ queries. Oddly I am now not getting the error message!!
¤ All I did was delete my data connection and then reboot my
¤ pc and start again. So my problem appears to have gone
¤ away.
¤
¤ But I'd like to understand the best way to set up
¤ queries. If I do it as above then are these queries just
¤ stored and not so easily accessible but maybe the code is
¤ faster??? And if I write them into my code I can see them
¤ but maybe the code is slower???
¤ What's the best approach?
¤

Personally I haven't been using the Server Explorer on the application side. I primarily use it to
query data and develop packages/stored procedures for Oracle.

I think it's simply a matter of preference. I generally like to write the code because it's
typically easier to change and generally more flexible. However, if I needed to develop a database
application fairly rapidly, which wasn't particularly complicated, I might opt for using Server
Explorer.

Using Server Explorer does have its limitations but you should see significant improvements with
respect to the data binding features in the next version.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Hi Paul

Thanks for your reply. You may be able to help me with
something else sort of related.

Where should the database be set up generally? I've taken
a project over from somebody and he's put the database in
a folder within the project? That doesn't seem like the
right place to me (he didn't do much on it and may have
only been a temporary measure).

I've got the database in a directory on my c: drive and
I've been connecting to that through the server explorer.
But presumably if I choose to do my "own code" then I can
still keep it there or whereever it should go.

Eventually it will go on the server (I think I'm right
with that) but until then do I put it in a directory on
IIS?

Hope you can help.

-----Original Message-----
¤ Hi Paul
¤
¤ Yes, I am adding a data connection and I'm selecting
¤ Microsoft Jet 4.0 OLEDB as the provider. I test the
¤ connection and it's fine and the connectionstring is
¤ displayed in the properties window correctly.
¤
¤ The next thing I go to do is to either drag fields from
¤ the tables (in server explorer) or use the
¤ oledbdataadapter (and use querybuilder) to set up my
¤ queries. Oddly I am now not getting the error message!!
¤ All I did was delete my data connection and then reboot my
¤ pc and start again. So my problem appears to have gone
¤ away.
¤
¤ But I'd like to understand the best way to set up
¤ queries. If I do it as above then are these queries just
¤ stored and not so easily accessible but maybe the code is
¤ faster??? And if I write them into my code I can see them
¤ but maybe the code is slower???
¤ What's the best approach?
¤

Personally I haven't been using the Server Explorer on
Click to expand...
the application side. I primarily use it to
query data and develop packages/stored procedures for Oracle.

I think it's simply a matter of preference. I generally
Click to expand...
like to write the code because it's
typically easier to change and generally more flexible.
Click to expand...
However, if I needed to develop a database
application fairly rapidly, which wasn't particularly
Click to expand...
complicated, I might opt for using Server
Explorer.

Using Server Explorer does have its limitations but you
Click to expand...
should see significant improvements with
Click to expand...
 
¤ Hi Paul
¤
¤ Thanks for your reply. You may be able to help me with
¤ something else sort of related.
¤
¤ Where should the database be set up generally? I've taken
¤ a project over from somebody and he's put the database in
¤ a folder within the project? That doesn't seem like the
¤ right place to me (he didn't do much on it and may have
¤ only been a temporary measure).
¤
¤ I've got the database in a directory on my c: drive and
¤ I've been connecting to that through the server explorer.
¤ But presumably if I choose to do my "own code" then I can
¤ still keep it there or whereever it should go.
¤
¤ Eventually it will go on the server (I think I'm right
¤ with that) but until then do I put it in a directory on
¤ IIS?
¤

If the database is application specific then I would place it in either the application folder or
sub folder of the application. In the case of IIS, the ASPNET account will need full access to the
folder where the database file is located.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top