How to connect to a database ...
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.
Re: How to connect to a database ...
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.
Re: How to connect to a database ...
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.!!!
Re: How to connect to a database ...
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.
Re: How to connect to a database ...
I use a win2000 OS like user...
Re: How to connect to a database ...
I just intalled a MDAC_TYP_Es file 2,8 version.. on the win98 pcs but not response.. !!
Re: How to connect to a database ...
there are some pcs with WinXP that work fine...!!!
Re: How to connect to a database ...
Quote:
Originally Posted by groval
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.
Re: How to connect to a database ...
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.. ??
Re: How to connect to a database ...
How i fix that.. i will apreciatte some help or some idea that i can fix my app..!!!
Re: How to connect to a database ...
I can change my OS to Win98.. or download any emulator file that allow to app work fine.. !! I dont know.. !!
Re: How to connect to a database ...
this is the error...
Error 80004005, Microsoft ODBC Driver Manager. Data source name not found and no default driver specifed.
Re: How to connect to a database ...
You might want to map the drive on the W98 machine to the right folder of the db.
Re: How to connect to a database ...
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 :)
Re: How to connect to a database ...
thanks to everybody..
I fix the error maping the drive.. I put a drive unit (P:\) and voilá !! Working !! thanks again..
:wave: