By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,982 Members | 1,955 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,982 IT Pros & Developers. It's quick & easy.

odbc

P: n/a
Hi.
I've got a "base.mdb" secured with "system.mdw". There's also a
password set on "base.mdb" . After configuration ODBC driver ( system
DSN ), supplying user and his pass too, when I try to connect do it I
receive error "Invalid password". What I'm doing wrong ? Is it related
to pass which is for "base.mdb" ? Regards.
Rick
Apr 5 '06 #1
Share this Question
Share on Google+
9 Replies


P: n/a
"Rysiek" <ri******@neostrada.pl> wrote in message
news:20*********************@vector.linux.vnet...
Hi.
I've got a "base.mdb" secured with "system.mdw". There's also a
password set on "base.mdb" . After configuration ODBC driver ( system
DSN ), supplying user and his pass too, when I try to connect do it I
receive error "Invalid password". What I'm doing wrong ? Is it related
to pass which is for "base.mdb" ? Regards.
Rick

A database password is a very basic form of security. If you have set up
security with an mdw file, then there is no point adding a database
password. It just complicates other things unnecessarily - so just remove
it.
Creating a dsn with odbc is not normally required either.

What are you trying to do?
Apr 5 '06 #2

P: n/a

A database password is a very basic form of security. If you have
set up security with an mdw file, then there is no point adding a
database password. It just complicates other things unnecessarily -
so just remove it. I can't remove it. I'm writing an application which is to get some data
from existing access database. I have no admin privileges on it, so I
can't do anything with it. I've got only user, password and database
password
Creating a dsn with odbc is not normally required either.

What are you trying to do?


My app it's some php scripts, and afaik only with ODBC I can connect do
*.mdb

Apr 5 '06 #3

P: n/a
"Rysiek" <ri******@neostrada.pl> wrote in message
news:20*********************@vector.linux.vnet...

A database password is a very basic form of security. If you have
set up security with an mdw file, then there is no point adding a
database password. It just complicates other things unnecessarily -
so just remove it.

I can't remove it. I'm writing an application which is to get some data
from existing access database. I have no admin privileges on it, so I
can't do anything with it. I've got only user, password and database
password
Creating a dsn with odbc is not normally required either.

What are you trying to do?


My app it's some php scripts, and afaik only with ODBC I can connect do
*.mdb

I'm afraid I don't know anything about php. Is this running on Windows? If
so, you should be able to use an ADO connection without needing any dsn
file.
But anyway, did you try removing the database password? (hopefully you
believe me that it should be removed)
Apr 5 '06 #4

P: n/a
O


I'm afraid I don't know anything about php. Is this running on
Windows? If so, you should be able to use an ADO connection without
needing any dsn file. As I don't know anything about access :) It's all done under
Windows. Anyway it seems not to be a problem with php. When I try for
example to compact database (on system DSN tab there's a option to do
this), I receive the same error.
Hmm, "ADO connection" could you in short describe this ?
But anyway, did you try removing the database password? (hopefully
you believe me that it should be removed)

Of course I believe, but I'm not allowed do this. I've got access to
this *.mdb file "as is".

Apr 5 '06 #5

P: n/a

"Rysiek" <ri******@neostrada.pl> wrote in message
news:20*********************@vector.linux.vnet...
O


I'm afraid I don't know anything about php. Is this running on
Windows? If so, you should be able to use an ADO connection without
needing any dsn file.

As I don't know anything about access :) It's all done under
Windows. Anyway it seems not to be a problem with php. When I try for
example to compact database (on system DSN tab there's a option to do
this), I receive the same error.
Hmm, "ADO connection" could you in short describe this ?
But anyway, did you try removing the database password? (hopefully
you believe me that it should be removed)

Of course I believe, but I'm not allowed do this. I've got access to
this *.mdb file "as is".

Dobrze.
If you are running Windows, you can create a plain text file with note pad
and cut and paste the code below. Change the username, passwords and file
locations, then close and save the file as TestMe.vbs and then run it by
double-clicking it.

This will verify that you really do have the right details. Once you have
done this test, you can move on to changing the code to do some useful work
with the database - such as reading or updating the data.

' **** Code Starts *******
Option Explicit

If TestDb()=0 Then
MsgBox "I can connect"
Else
MsgBox "I cannot connect"
End If
Function TestDb()

On Error Resume Next

Dim cnn
Dim strConn
Dim strSQL
Dim lngReturn

lngReturn=1

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\MyFolder\Database.mdb;" & _
"Jet OLEDB:System Database=C:\MyFolder\Workgroup.mdw;" & _
"User Id=MyLoginName;Password=MyPassword;" & _
"Jet OLEDB:Database Password=DatabasePassword;"

Set cnn = CreateObject("ADODB.Connection")

cnn.Open strConn

If Not cnn Is Nothing Then
If cnn.State > 0 Then
lngReturn=0
cnn.Close
End If
Set cnn = Nothing
End If

End Function
' **** Code Ends *******
Apr 5 '06 #6

P: n/a
I left out the last very important line in the function!!
Just before the End Function, you need TestDb=lngReturn
For clarity, the text is now:

' **** Code Starts *******
Option Explicit

If TestDb()=0 Then
MsgBox "I can connect"
Else
MsgBox "I cannot connect"
End If
Function TestDb()

On Error Resume Next

Dim cnn
Dim strConn
Dim strSQL
Dim lngReturn

lngReturn=1

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\MyFolder\Database.mdb;" & _
"Jet OLEDB:System Database=C:\MyFolder\Workgroup.mdw;" & _
"User Id=MyLoginName;Password=MyPassword;" & _
"Jet OLEDB:Database Password=DatabasePassword;"

Set cnn = CreateObject("ADODB.Connection")

cnn.Open strConn

If Not cnn Is Nothing Then
If cnn.State > 0 Then
lngReturn=0
cnn.Close
End If
Set cnn = Nothing
End If

TestDb=lngReturn

End Function
' **** Code Ends *******
Apr 5 '06 #7

P: n/a
O


Dobrze. :)
If you are running Windows, you can create a plain text file with
note pad and cut and paste the code below. Change the username,
passwords and file locations, then close and save the file as
TestMe.vbs and then run it by double-clicking it.

This will verify that you really do have the right details. Once you
have done this test, you can move on to changing the code to do some
useful work with the database - such as reading or updating the data.


Thank you for your support. I'll be able to test it on Saturday.
Rick

Apr 6 '06 #8

P: n/a
So, I've tried to test your func but it hasn't worked. After
running this i've got an error something like this "Improper character
at line 1, char 1". I've searched the web for solution for my problem
and found some infos that it's impossible to pass both passwords via
ODBC. So I decided to use other methods to access mdb file.
Thank you for your help
Rick
Apr 11 '06 #9

P: n/a
"Rysiek" <ri******@neostrada.pl> wrote in message
news:20*********************@vector.linux.vnet...
So, I've tried to test your func but it hasn't worked. After
running this i've got an error something like this "Improper character
at line 1, char 1". I've searched the web for solution for my problem
and found some infos that it's impossible to pass both passwords via
ODBC. So I decided to use other methods to access mdb file.
Thank you for your help
Rick

The file was tested on my machine - so it really does work. If you are
getting this error, it looks like the text has not been copied and pasted
properly.
Although I mentioned that having a username and password as well as a
database password is not a good idea, you can do it and you can write code
to connect to it. If you are happy with these other methods you mention
then OK, but if you need further help, just post back.
Apr 11 '06 #10

This discussion thread is closed

Replies have been disabled for this discussion.