Conect database in Server

Hi, I am making a web site, and it have acces to a database. The acces is only for add or see some data, such as name, adress, phone, etc.. But I have a problem, I can't conect the page that I create with the database. The database is a .mdb file and it's allocated in the server "wwww.algo.com.ar/formularios/criaderos.mdb". How i can do for do the $%^@#@# conect. One more thing, I am new in VB5, so you have to tell me step by step (Sorry). Ahh the files that VB5 create is a .VBD.
Thanks
danielmennilliAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

danielmennilliAuthor Commented:
Adjusted points to 200
0
dhwanilshahCommented:
What is the web server and your permissions on the server like?
Is this your own personal web server or are you hosting this on some web hosting provider's server?
0
danielmennilliAuthor Commented:
Ok, good question, No it's not my personal Web Server. I pay for space in server. I request all my permissions to the server.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

dhwanilshahCommented:
do u have the rights to create an system odbc connection on that server?
0
danielmennilliAuthor Commented:
yes, i have to ask for them. But i don't know what ask.
0
dhwanilshahCommented:
ask them if they would allow u to create system odbc connection to your mdb file. also ask them if they would host ur application or not? I mean even if they dont allow u to create odbc connection (which at times is usual) then too there is a way through odbc less connection by which u can use your vbd file. but as it is if they allow u to host vbd file then they must allow for connections. just ask them if they allow such applications to be hosted on their servers or not.
0
danielmennilliAuthor Commented:
OK I will ask them... thanks.. and sorry my very poor english.
0
danielmennilliAuthor Commented:
Hi, i have to work with odbc less connection (what odbc less connection is?). Can you tell me how to do this, i don't know nothing about this connection (of course, i don't know the code for the connection). Thanks
0
dhwanilshahCommented:
I think as u want to access mdb database from the vbd file, then, u must be using ado data control from vb 6.0 so this is the connection string that should work with ur db. paste it into the connection property of the adodc control, change the name of the db to yours (i've used biblio.mdb) also check if the provider is correct. Otherwise u can use the property builder wizard to create the connection string property for the ado dc control.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dhwanilshahCommented:
i am so sorry , i forgot to post the string : here it is :

Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=Biblio.mdb;Mode=Read|Write|Share Deny None
0
danielmennilliAuthor Commented:
Hi, I apreciate your answer. But there is a problem... I don't have VB6.0. I have VB5.0. I can work with it.
0
dhwanilshahCommented:
so what data access option are you using? I mean DAO or RDO? Or are you using ADO?
0
danielmennilliAuthor Commented:
Hi, in this moment i don't work with database, because i don't know what mean DAO or RDO. If you could tellme the diferences between both, i will very thanks with you; and one more thing, what type of data DAO or RDO you think is better and why.

Thanks.


Sorry my questions, this happen because i'm a student in first level, and this is my first work with database in Internet.
0
dhwanilshahCommented:
there are a lot diff. bet. DAO and RDO but basically microsofts first trial with providing uniform db access to all db sources was dao then came rdo with its smaller footprint, improved performance etc. and then now comes ado which is even better then the two.

if u want any other specific info. then please mail me at dhwanil@cilmail.com
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.