Hi,
I am looking for sample VB.net code for working with Access 97 database. I
know how to work with SQL but I dont know how to read and writ into access
97. Any help is very much appreciated.
There was suggestion that connecting to an MS Access database through VB.NET
is exactly same as SQL and I only need to change the provider name.
Dim sConnString As String = _
"Provider=Microsoft.Jet.OLEDB.3.51;" & _
"Data Source=C:\myPath\myJet.mdb;" & _
"User ID=Admin;" & _
"Password="
but when i try to connect i get the error that Keyword not supported:
'microsoft.jet.oledb.3.51;data source'
I am running access 2002 but the database i am trying to connect is in
access 97.
Al 5 5711
Use the 4.0 provider, not 3.51. Also, the User ID and password is not
necessary as Access will log you on silently as the Admin user with no
password (unless you've implemented user-level security, in which case
you'd need to specify the workgroup file as well).
--Mary
On Fri, 26 Nov 2004 09:11:02 -0800, "Al"
<Al@discussions.microsoft.com> wrote: Hi, I am looking for sample VB.net code for working with Access 97 database. I know how to work with SQL but I dont know how to read and writ into access 97. Any help is very much appreciated.
There was suggestion that connecting to an MS Access database through VB.NET is exactly same as SQL and I only need to change the provider name.
Dim sConnString As String = _ "Provider=Microsoft.Jet.OLEDB.3.51;" & _ "Data Source=C:\myPath\myJet.mdb;" & _ "User ID=Admin;" & _ "Password="
but when i try to connect i get the error that Keyword not supported: 'microsoft.jet.oledb.3.51;data source'
I am running access 2002 but the database i am trying to connect is in access 97.
Al
Thanks Mary do i need to also include provider?
Provider=Microsoft.Jet.OLEDB.4.0?
do you have sample code for OldeDB?
thanks
Al
"Mary Chipman" wrote: Use the 4.0 provider, not 3.51. Also, the User ID and password is not necessary as Access will log you on silently as the Admin user with no password (unless you've implemented user-level security, in which case you'd need to specify the workgroup file as well).
--Mary
On Fri, 26 Nov 2004 09:11:02 -0800, "Al" <Al@discussions.microsoft.com> wrote:
Hi, I am looking for sample VB.net code for working with Access 97 database. I know how to work with SQL but I dont know how to read and writ into access 97. Any help is very much appreciated.
There was suggestion that connecting to an MS Access database through VB.NET is exactly same as SQL and I only need to change the provider name.
Dim sConnString As String = _ "Provider=Microsoft.Jet.OLEDB.3.51;" & _ "Data Source=C:\myPath\myJet.mdb;" & _ "User ID=Admin;" & _ "Password="
but when i try to connect i get the error that Keyword not supported: 'microsoft.jet.oledb.3.51;data source'
I am running access 2002 but the database i am trying to connect is in access 97.
Al
Al
When Herfried was active now, you would have had this link already a long
time. http://www.connectionstrings.com/
When you do not find it there than here one extra http://www.able-consulting.com/ADO_Conn.htm
I hope this helps?
Cor
"Al" <Al@discussions.microsoft.com> Thanks Mary do i need to also include provider? Provider=Microsoft.Jet.OLEDB.4.0? do you have sample code for OldeDB? thanks Al
"Mary Chipman" wrote:
Use the 4.0 provider, not 3.51. Also, the User ID and password is not necessary as Access will log you on silently as the Admin user with no password (unless you've implemented user-level security, in which case you'd need to specify the workgroup file as well).
--Mary
On Fri, 26 Nov 2004 09:11:02 -0800, "Al" <Al@discussions.microsoft.com> wrote:
> Hi, >I am looking for sample VB.net code for working with Access 97 database. >I >know how to work with SQL but I dont know how to read and writ into >access >97. Any help is very much appreciated. > >There was suggestion that connecting to an MS Access database through >VB.NET >is exactly same as SQL and I only need to change the provider name. > >Dim sConnString As String = _ > "Provider=Microsoft.Jet.OLEDB.3.51;" & _ > "Data Source=C:\myPath\myJet.mdb;" & _ > "User ID=Admin;" & _ > "Password=" > >but when i try to connect i get the error that Keyword not supported: >'microsoft.jet.oledb.3.51;data source' > >I am running access 2002 but the database i am trying to connect is in >access 97. > >Al
Your connection string looked like it was OK, except for the 3.51.
--Mary
On Fri, 26 Nov 2004 14:09:01 -0800, "Al"
<Al@discussions.microsoft.com> wrote: Thanks Mary do i need to also include provider? Provider=Microsoft.Jet.OLEDB.4.0? do you have sample code for OldeDB? thanks Al
"Mary Chipman" wrote:
Use the 4.0 provider, not 3.51. Also, the User ID and password is not necessary as Access will log you on silently as the Admin user with no password (unless you've implemented user-level security, in which case you'd need to specify the workgroup file as well).
--Mary
On Fri, 26 Nov 2004 09:11:02 -0800, "Al" <Al@discussions.microsoft.com> wrote:
> Hi, >I am looking for sample VB.net code for working with Access 97 database. I >know how to work with SQL but I dont know how to read and writ into access >97. Any help is very much appreciated. > >There was suggestion that connecting to an MS Access database through VB.NET >is exactly same as SQL and I only need to change the provider name. > >Dim sConnString As String = _ > "Provider=Microsoft.Jet.OLEDB.3.51;" & _ > "Data Source=C:\myPath\myJet.mdb;" & _ > "User ID=Admin;" & _ > "Password=" > >but when i try to connect i get the error that Keyword not supported: >'microsoft.jet.oledb.3.51;data source' > >I am running access 2002 but the database i am trying to connect is in >access 97. > >Al
AL,
Did this all work for you?
Thanks,
Steve
"Mary Chipman" wrote: Your connection string looked like it was OK, except for the 3.51.
--Mary
On Fri, 26 Nov 2004 14:09:01 -0800, "Al" <Al@discussions.microsoft.com> wrote:
Thanks Mary do i need to also include provider? Provider=Microsoft.Jet.OLEDB.4.0? do you have sample code for OldeDB? thanks Al
"Mary Chipman" wrote:
Use the 4.0 provider, not 3.51. Also, the User ID and password is not necessary as Access will log you on silently as the Admin user with no password (unless you've implemented user-level security, in which case you'd need to specify the workgroup file as well).
--Mary
On Fri, 26 Nov 2004 09:11:02 -0800, "Al" <Al@discussions.microsoft.com> wrote:
> Hi, >I am looking for sample VB.net code for working with Access 97 database. I >know how to work with SQL but I dont know how to read and writ into access >97. Any help is very much appreciated. > >There was suggestion that connecting to an MS Access database through VB.NET >is exactly same as SQL and I only need to change the provider name. > >Dim sConnString As String = _ > "Provider=Microsoft.Jet.OLEDB.3.51;" & _ > "Data Source=C:\myPath\myJet.mdb;" & _ > "User ID=Admin;" & _ > "Password=" > >but when i try to connect i get the error that Keyword not supported: >'microsoft.jet.oledb.3.51;data source' > >I am running access 2002 but the database i am trying to connect is in >access 97. > >Al
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Krish |
last post by:
Hi Friends,
Does anyone know how to connect access database into Visual C++ in
Visual Studio 6.0. I know the procedure to connect access database
into Visual Studio .Net. But Visual Studio 6.0...
|
by: carl.manaster |
last post by:
I'm new to this game. I can find my way around C# without any trouble,
and I've used Access, a little bit, in the past. Now a friend wants an
application of mine to read from his Access database....
|
by: Krish |
last post by:
Hi Friends,
Does anyone know how to connect access database into Visual C++ in
Visual Studio 6.0. I know the procedure to connect access database
into Visual Studio .Net. But Visual Studio 6.0...
|
by: ej1008 |
last post by:
HI all
I am having a windows Control running on ASP.Net webform. From this windows control I am trying to connect to database to do some database operations.
Now I am facing problem while...
|
by: Nick Gilbert |
last post by:
Hi,
I have an asp.net application which runs from a CD-ROM using Cassini. As
such, it is single user only.
The application connects to an Access database when it is loaded, and
keeps the same...
|
by: CM Manager via DotNetMonster.com |
last post by:
I am very frustrated due to this exception error I am receiving. I've tried
searching numerous user support groups, Microsoft Support Net, Google, etc.
and haven't found exactly my situation....
|
by: Randy |
last post by:
Hi,all
I met one problem of connecting Access database in asp.net web program.
I use ODBC link to Access, the connection string like
"PWD=12345;DSN=QADLinkMDB;DriverId=25;MaxBufferSize=2048;FIL=MS...
|
by: Yew12 |
last post by:
Hi, I'm having problems connecting to a Microsoft Access database. Im using PHP and ODBC but im not using a DNS.
The scripts below give no errors but I they only give me a blank white screen.
...
|
by: David McColl |
last post by:
Dear all,
We recently migrated a SQL database from one server to another. Now,
when you try to run some code in an Access Database which links to the
SQL one, you get a 3704 error "Operation is...
|
by: mehdi4467 |
last post by:
Hi,
I am trying to connecting Access DataBase to C#,
my data base hase 3 table.
in c# when I configure data adapter and run SELECT account.*
FROM account query, there is no...
|
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...
|
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: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |