Multiple Step OLE DB Problem, pls help, i know u can....

[Mag-Net]

Ok people i need some serious help, I am having a problem with my access 2000 database and vb6 sp4. i can get to the database, but if the password isnt set, ne ideas? I need to password protect the database. second problem is the goddamn error i keep on getting:

Error Number: -2147217887, description: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.

What does that mean? how do i fix it? thanks a lot ppl, i appreciate it.

[Jimbob]

i had that error once

it can be caused by all manner of things, but in my case I seem to remember that I was trying to assign a value to an auto number column

try doing a usenet search on http://www.dogpile.com for your error message - usually turns up loads of stuff for me

to set the password for a database you need to join a workgroup using the workgroup administrator
after that it's easy - just specify the username and password in your connection string, or if you're using DAO, open up a workspace before you open the database

[Clunietp]

Is the database password protected right now? And you need to know how to connect with it?

What code is giving you that error?

[Mag-Net]

I get my error when trying to add a new record to the database.

I looked on Dogpile and found no way of fixing it. How do i get around it?

The password protect thing i am doing how it should be, in the connection string, and in the bit in access where u said, but it still doesnt connect properly, i get an error that it cant connect to database?

Thanks

[Mag-Net]

The code for the adding new records (or ammending others) is correct, it is just a bug in vb, is there a way around it?

[Clunietp]

what does your connection string look like?

[Mag-Net]

This is my connection string:

"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\CustomerDB.mdb"

I havent got the username or password set in this because it doesn't connect when i have them set. The following is the connection string that I tried when using a username and password:

"Provider=Microsoft.Jet.OLEDB.4.0; Password=Password; Data Source=" & App.Path & "\CustomerDB.mdb; Mode=Write|Share Deny None; Persist Security Info=True; Jet OLEDB:Database"


Is this wrong? It is what the string builder built for me, then i used it and didnt use the data control (i dont like using that thing)

thanks

[Clunietp]

I responded to your other post about Password protecting

http://forums.vb-world.net/showthread.php?threadid=23390

[lirlir]

I m trying to use this code to connect to a DB on VB5
and it aint working ,do you know why ?

Set GetRecordSet = Nothing

Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset

THIS :

sConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & App.Path & "\Phones.mdb"

OR THIS:

sConn = "DNS=Phones;DATABASE=phones"

OR THIS:

sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=Phones.mdb;Jet OLEDB:Database ;"


conn.Open sConn


NONE OF THEM WORKS !!!!


HELP !HELP !HELP !HELP !HELP !HELP !HELP !

[Mag-Net]

i like ur tag, that is really very true (tag = the thing at the bottom).

what i would do is just insert a ADODB control (ActiveX Data Objects Control).....i cant remember exactly what it is called, and then goto custom and get it to build the string itself, you can then test the connection then use the desired connection string. Hope it helps :D