How to connect to a database ...

[groval]

Hi.. everyones.

How i can connect to five pcs to other wich have a database mdb files ...

I have a Pc with W2000 not server.. and 5 pcs somes with w98 and others WinXP.
In a WIn2000 pc (ip 173.25.30.65), i have a 4 database mdb files, I need conect 5 pcs to WIN2000 pc using VB6.
How i can do that..??

Groval.

[Hack]

Is the folder in which the databases reside set up as shareable?

If not, you can't get to them. If they are, then it should be an easy matter of just connecting to them like you would any network share.

[groval]

Tks Hack, i shared the folder named "f" under c:\, but i have some problems with w98 pcs.

This is the code for my connection:

sFileName1 = "\\172.24.30.66\F\"
sFileName2 = "bd\pepo.mdb"

sFileName = sFileName1 & sFileName2
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" _
& " Data Source= " & sFileName & ";Persist Security Info=False"

I will appear the error like follow:

80004005 [Microsoft][ODBC Driver Manager]Data source name not found and no default drive specified

I will apreciatte some help.!!!

[Hack]

It has been a long time since I used Win98. I'm not sure you can make folders sharable on that OS. You need to be running some form of NTFS and I'm not sure if Win95/98 supports that.

[groval]

I use a win2000 OS like user...

[groval]

I just intalled a MDAC_TYP_Es file 2,8 version.. on the win98 pcs but not response.. !!

[groval]

there are some pcs with WinXP that work fine...!!!

[Hack]

there are some pcs with WinXP that work fine...!!!

And that is because WinXP supports NTFS whereas, as I said, I don't believe Win98 does.

[groval]

Yes.. but... look that. Until the past week everything work fine... then i added some lines of code y suddenly the win98 pcs doesnt work... Whats wrong.. ??

[groval]

How i fix that.. i will apreciatte some help or some idea that i can fix my app..!!!

[groval]

I can change my OS to Win98.. or download any emulator file that allow to app work fine.. !! I dont know.. !!

[groval]

this is the error...

Error 80004005, Microsoft ODBC Driver Manager. Data source name not found and no default driver specifed.

[dglienna]

You might want to map the drive on the W98 machine to the right folder of the db.

[Pradeep1210]

I think sFileName1 = "\\172.24.30.66\F\" won't work with Jet engine on win98. As dglienna already said try mapping it with a drive letter.

Pradeep

[groval]

thanks to everybody..

I fix the error maping the drive.. I put a drive unit (P:\) and voilá !! Working !! thanks again..