Welcome to dbFreaks.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Databases

  
   Database Help (Home) -> Visual Basic RSS
Related Topics:
sql query returns in wrong format - Hi, Hope someone can help me with this. I have MS SQL 2000 database where i have Table and there a column wich is data type All data in this column is in form So why when i run .asp page with simple query to..

arrays - is there a way to the contents of an array (looping through the array) and storing each item in a comma delimited string? Thanks!

DataReport PageBreak - Hi everyone, I would like to know how to force pagebreak in a for example after 5 records printed. Thank you all

Possible Use of a Cursor - I have a complex query that I hope I can explain it well enough for everyone to I have a table that contains for work Contained in the table are these are groupings of machining

Scroll Bars - Is there a way to find the size of on a system using Visual Basic 6.0? I know how to look and change them on the display but I don't know how to access that from within Visual Basic.
Next:  Visual Basic: Supporting both access and sql  
Author Message
James98

External


Since: Aug 16, 2004
Posts: 7



(Msg. 1) Posted: Wed Feb 16, 2005 2:17 am
Post subject: Re: Databases [Login to view extended thread Info.]
Archived from groups: microsoft>public>vb>database (more info?)
Hi Paul

If the file is only required for developement does that mean I can remove it
from the package completely with out effecting the operation of the program?
As for the database driver, could you please help me clarify this, I am only
using what is in the VB6 package. I have used some SQL code for a few of the
queries but I am not sure of which driver it would be.

Look forwards to hearing from you


"Paul Clement" wrote:

 > On Fri, 4 Feb 2005 09:13:04 -0800, "James" <James DeleteThis @discussions.microsoft.com> wrote:
 >
 > ¤ I am using XP and VB6. Also I checked the list of included files in the
 > ¤ packaging wizard and the file appeared to be there. Do I perhaps have a duff
 > ¤ file? and am I right about the 2 errors being linked?
 > ¤
 >
 > I don't believe that file is required when distributing your application - only for development.
 >
<font color=purple> > <a style='text-decoration: underline;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;299645</font" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;299645</font</a>>
 >
 > The provider error refers to the database driver you are using. What type of database are you
 > working with?
 >
 >
 > Paul ~~~ pclement DeleteThis @ameritech.net
 > Microsoft MVP (Visual Basic)
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Databases 
Back to top
Login to vote
Paul Clement

External


Since: Sep 02, 2003
Posts: 236



(Msg. 2) Posted: Wed Feb 16, 2005 10:06 am
Post subject: Re: Databases [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Wed, 16 Feb 2005 01:17:03 -0800, "James" <James.DeleteThis@discussions.microsoft.com> wrote:


¤ If the file is only required for developement does that mean I can remove it
¤ from the package completely with out effecting the operation of the program?

Yes.

¤ As for the database driver, could you please help me clarify this, I am only
¤ using what is in the VB6 package. I have used some SQL code for a few of the
¤ queries but I am not sure of which driver it would be.
¤

I can't tell you because I don't know what kind of database and database provider you are using.


Paul ~~~ pclement.DeleteThis@ameritech.net
Microsoft MVP (Visual Basic)

 >> Stay informed about: Databases 
Back to top
Login to vote
James98

External


Since: Aug 16, 2004
Posts: 7



(Msg. 3) Posted: Thu Feb 17, 2005 2:21 am
Post subject: Re: Databases [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
sorry if Iam being slow but is there a default database and provider for VB6?
If not then I assume I am using a SQL database but have no ides about the
provider, how do I find out this information? As I have said before I am very
new to the database field.

sorry


"Paul Clement" wrote:

 > On Wed, 16 Feb 2005 01:17:03 -0800, "James" <James RemoveThis @discussions.microsoft.com> wrote:
 >
 >
 > ¤ If the file is only required for developement does that mean I can remove it
 > ¤ from the package completely with out effecting the operation of the program?
 >
 > Yes.
 >
 > ¤ As for the database driver, could you please help me clarify this, I am only
 > ¤ using what is in the VB6 package. I have used some SQL code for a few of the
 > ¤ queries but I am not sure of which driver it would be.
 > ¤
 >
 > I can't tell you because I don't know what kind of database and database provider you are using.
 >
 >
 > Paul ~~~ pclement RemoveThis @ameritech.net
 > Microsoft MVP (Visual Basic)
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Databases 
Back to top
Login to vote
Paul Clement

External


Since: Sep 02, 2003
Posts: 236



(Msg. 4) Posted: Thu Feb 17, 2005 10:13 am
Post subject: Re: Databases [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Thu, 17 Feb 2005 01:21:03 -0800, "James" <James DeleteThis @discussions.microsoft.com> wrote:

¤ sorry if Iam being slow but is there a default database and provider for VB6?
¤ If not then I assume I am using a SQL database but have no ides about the
¤ provider, how do I find out this information? As I have said before I am very
¤ new to the database field.
¤
¤ sorry

Somewhere in your code you should have a connection string (if using ADO) or Data Control property
(Connect, DatabaseName, ConnectionString) that will identify the database you are using.


Paul ~~~ pclement DeleteThis @ameritech.net
Microsoft MVP (Visual Basic)
 >> Stay informed about: Databases 
Back to top
Login to vote
James98

External


Since: Aug 16, 2004
Posts: 7



(Msg. 5) Posted: Fri Feb 18, 2005 2:53 am
Post subject: Re: Databases [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I am just being a bit thick.

In the connection string of the adodc is this line:

Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data
Source=C:\Program Files\Microsoft Visual Studio\VB98\Countryside
Cottages\Countryside.mdb

As I know you will be aware this also includes the address of the actual
database.

should I be using a different provider? is this one too old to use?

Cheers for all your help this far


"Paul Clement" wrote:

 > On Thu, 17 Feb 2005 01:21:03 -0800, "James" <James.DeleteThis@discussions.microsoft.com> wrote:
 >
 > ¤ sorry if Iam being slow but is there a default database and provider for VB6?
 > ¤ If not then I assume I am using a SQL database but have no ides about the
 > ¤ provider, how do I find out this information? As I have said before I am very
 > ¤ new to the database field.
 > ¤
 > ¤ sorry
 >
 > Somewhere in your code you should have a connection string (if using ADO) or Data Control property
 > (Connect, DatabaseName, ConnectionString) that will identify the database you are using.
 >
 >
 > Paul ~~~ pclement.DeleteThis@ameritech.net
 > Microsoft MVP (Visual Basic)
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Databases 
Back to top
Login to vote
Paul Clement

External


Since: Sep 02, 2003
Posts: 236



(Msg. 6) Posted: Fri Feb 18, 2005 10:54 am
Post subject: Re: Databases [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Fri, 18 Feb 2005 01:53:02 -0800, "James" <James RemoveThis @discussions.microsoft.com> wrote:

¤ I am just being a bit thick.
¤
¤ In the connection string of the adodc is this line:
¤
¤ Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data
¤ Source=C:\Program Files\Microsoft Visual Studio\VB98\Countryside
¤ Cottages\Countryside.mdb
¤
¤ As I know you will be aware this also includes the address of the actual
¤ database.
¤
¤ should I be using a different provider? is this one too old to use?
¤

Jet 3.5 is a bit outdated. If possible you may want to use Jet 4.0 instead. The use of 3.5 may be
the source of your missing provider error.


Paul ~~~ pclement RemoveThis @ameritech.net
Microsoft MVP (Visual Basic)
 >> Stay informed about: Databases 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Visual Basic All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]