Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Problem in Network

 
   Database Help (Home) -> Visual Basic -> DAO RSS
Next:  Can't Read Chinese Characters using VB5  
Author Message
HellGrande

External


Since: Oct 29, 2003
Posts: 3



(Msg. 1) Posted: Wed Oct 29, 2003 6:54 pm
Post subject: Problem in Network
Archived from groups: microsoft>public>vb>database>dao (more info?)

Hi
My problem is:
I have a program made in VB6 (SP5), the database is in Access 2000. The
program runs in a network at 100 Mbps. One of the computer's (the "server")
have the database, the other uses a database with all the necessary tables
linked to the "server"... when i use the program without the one in the
server running, the speed is average... if i start the program in the server
(even if i dont do nothing) the speed get's very miserable in the other
computer....
Can anyone help me with this?
Thanks

HellGrande in Africa
PS sorry my poor english

 >> Stay informed about: Problem in Network 
Back to top
Login to vote
Jr Mendonça

External


Since: Oct 23, 2003
Posts: 6



(Msg. 2) Posted: Wed Oct 29, 2003 6:54 pm
Post subject: Re: Problem in Network [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Where are you from? Maybe we can talk in other language.
But, your problem is very dificult to solve.
Did you tried to make connection with ODBC?
Why don't you make an direct connection with your server?
here I have the same database and same VB. I mapped my database folder on
server and configured it to run direct! As a local database.
Are you using DAO?
Your connection string is similar to this:
Set db = Workspaces(0).OpenDatabase("\\server\shared\data.mdb", False,
False, "MS Access; PWD=mypassword;")???
I'm waiting for your feedback.
----------------------------------------------------------------------------
---------------------------
"HellGrande" <zukatruka DeleteThis @hotmail.com> escreveu na mensagem
news:#8T03QinDHA.2424@TK2MSFTNGP10.phx.gbl...
 > Hi
 > My problem is:
 > I have a program made in VB6 (SP5), the database is in Access 2000. The
 > program runs in a network at 100 Mbps. One of the computer's (the
"server")
 > have the database, the other uses a database with all the necessary tables
 > linked to the "server"... when i use the program without the one in the
 > server running, the speed is average... if i start the program in the
server
 > (even if i dont do nothing) the speed get's very miserable in the other
 > computer....
 > Can anyone help me with this?
 > Thanks
 >
 > HellGrande in Africa
 > PS sorry my poor english
 >
 >
 >
 ><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Problem in Network 
Back to top
Login to vote
HellGrande

External


Since: Oct 29, 2003
Posts: 3



(Msg. 3) Posted: Thu Oct 30, 2003 2:45 pm
Post subject: Re: Problem in Network [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hello Jr Mendonça
I m from Portugal leaving in Mozambique

I dont write the connection string, i use the dataenviroment and he does
everything alone....
I m not use to program to network... i dont know to connect with ODBC...
I m allways confuse if i m using DAO or ADO...

Em Português
Olá Jr Mendonça
Parece que nos podemos entender em português, eu já programo à uns anos, mas
em redes sou um principiante. Eu nao uso nenhuma "Connection String", deixo
o dataenvirmoment ligar sózinho, nunca me liguei por ODBC (nunca precisei) e
se uso DAO ou ADO, nunca consegui entender... uma das razões que nao mudei
para o .Net é realmente pelos problemos que posso ter na gestão de Bases de
Dados e tabelas.
Aqui em Moçambique, não existe informação, nem livros, nem ninguem a quem se
possa pedir ajuda... e tudo corria bem até colocarem o meu programa em rede.
Como expliquei, no pc "remoto", uso a Base de Dados com as tabelas
"linkadas" à base de dados do "server" que também usa essa mesma base dados
para correr o programa. Tudo funciona bem se não fizer o "run" do programa
no servidor, porque até aí a base de dados "linkada", funciona com um atraso
razoavel...
Espero que me consigas ajudar
Um Abraço aqui da parte Sul da África

HellGrande

--
Hernâni Dinarte
HD-Serviços de Informática, Lda.
Av.Vladimir Lenine nº 2956
Maputo - Moçambique
Tel/Fax: (258-1) 414984
Cel: 082 314444
hd.RemoveThis@tvcabo.co.mz - hdinarte.RemoveThis@tvcabo.co.mz
"Jr Mendonça" <maujr.RemoveThis@robynet.com.br> wrote in message
news:#vnKfIjnDHA.1960@TK2MSFTNGP12.phx.gbl...
 > Where are you from? Maybe we can talk in other language.
 > But, your problem is very dificult to solve.
 > Did you tried to make connection with ODBC?
 > Why don't you make an direct connection with your server?
 > here I have the same database and same VB. I mapped my database folder on
 > server and configured it to run direct! As a local database.
 > Are you using DAO?
 > Your connection string is similar to this:
 > Set db = Workspaces(0).OpenDatabase("\\server\shared\data.mdb", False,
 > False, "MS Access; PWD=mypassword;")???
 > I'm waiting for your feedback.
 > --------------------------------------------------------------------------
--
 > ---------------------------
 > "HellGrande" <zukatruka.RemoveThis@hotmail.com> escreveu na mensagem
 > news:#8T03QinDHA.2424@TK2MSFTNGP10.phx.gbl...
  > > Hi
  > > My problem is:
  > > I have a program made in VB6 (SP5), the database is in Access 2000. The
  > > program runs in a network at 100 Mbps. One of the computer's (the
 > "server")
  > > have the database, the other uses a database with all the necessary
tables
  > > linked to the "server"... when i use the program without the one in the
  > > server running, the speed is average... if i start the program in the
 > server
  > > (even if i dont do nothing) the speed get's very miserable in the other
  > > computer....
  > > Can anyone help me with this?
  > > Thanks
  > >
  > > HellGrande in Africa
  > > PS sorry my poor english
  > >
  > >
  > >
  > >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Problem in Network 
Back to top
Login to vote
João Araújo

External


Since: Nov 08, 2003
Posts: 2



(Msg. 4) Posted: Sat Nov 08, 2003 9:41 pm
Post subject: Re: Problem in Network [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Usar ADO ou DAO será simples verificar: através do VB em Project/References
verificar quais as librarias que estão a ser utilizadas. Na verdade ambas as
tecnologias poderão ser utilizadas em simultâneo.
Não percebo bem qual a necessidade das tabelas linkadas.
Qual a rede em causa? Microsoft? Novell? Outra?
O servidor é dedicado ou trata-se de um PC normal com partilha de ficheiros?
João Araújo

"HellGrande" <zukatruka.TakeThisOut@hotmail.com> wrote in message
news:%23nnmVqsnDHA.2304@TK2MSFTNGP11.phx.gbl...
 >
 > Hello Jr Mendonça
 > I m from Portugal leaving in Mozambique
 >
 > I dont write the connection string, i use the dataenviroment and he does
 > everything alone....
 > I m not use to program to network... i dont know to connect with ODBC...
 > I m allways confuse if i m using DAO or ADO...
 >
 > Em Português
 > Olá Jr Mendonça
 > Parece que nos podemos entender em português, eu já programo à uns anos,
mas
 > em redes sou um principiante. Eu nao uso nenhuma "Connection String",
deixo
 > o dataenvirmoment ligar sózinho, nunca me liguei por ODBC (nunca precisei)
e
 > se uso DAO ou ADO, nunca consegui entender... uma das razões que nao mudei
 > para o .Net é realmente pelos problemos que posso ter na gestão de Bases
de
 > Dados e tabelas.
 > Aqui em Moçambique, não existe informação, nem livros, nem ninguem a quem
se
 > possa pedir ajuda... e tudo corria bem até colocarem o meu programa em
rede.
 > Como expliquei, no pc "remoto", uso a Base de Dados com as tabelas
 > "linkadas" à base de dados do "server" que também usa essa mesma base
dados
 > para correr o programa. Tudo funciona bem se não fizer o "run" do programa
 > no servidor, porque até aí a base de dados "linkada", funciona com um
atraso
 > razoavel...
 > Espero que me consigas ajudar
 > Um Abraço aqui da parte Sul da África
 >
 > HellGrande
 >
 > --
 > Hernâni Dinarte
 > HD-Serviços de Informática, Lda.
 > Av.Vladimir Lenine nº 2956
 > Maputo - Moçambique
 > Tel/Fax: (258-1) 414984
 > Cel: 082 314444
 > hd.TakeThisOut@tvcabo.co.mz - hdinarte.TakeThisOut@tvcabo.co.mz
 > "Jr Mendonça" <maujr.TakeThisOut@robynet.com.br> wrote in message
 > news:#vnKfIjnDHA.1960@TK2MSFTNGP12.phx.gbl...
  > > Where are you from? Maybe we can talk in other language.
  > > But, your problem is very dificult to solve.
  > > Did you tried to make connection with ODBC?
  > > Why don't you make an direct connection with your server?
  > > here I have the same database and same VB. I mapped my database folder
on
  > > server and configured it to run direct! As a local database.
  > > Are you using DAO?
  > > Your connection string is similar to this:
  > > Set db = Workspaces(0).OpenDatabase("\\server\shared\data.mdb", False,
  > > False, "MS Access; PWD=mypassword;")???
  > > I'm waiting for your feedback.
 >
 > --------------------------------------------------------------------------
 > --
  > > ---------------------------
  > > "HellGrande" <zukatruka.TakeThisOut@hotmail.com> escreveu na mensagem
  > > news:#8T03QinDHA.2424@TK2MSFTNGP10.phx.gbl...
   > > > Hi
   > > > My problem is:
   > > > I have a program made in VB6 (SP5), the database is in Access 2000.
The
   > > > program runs in a network at 100 Mbps. One of the computer's (the
  > > "server")
   > > > have the database, the other uses a database with all the necessary
 > tables
   > > > linked to the "server"... when i use the program without the one in
the
   > > > server running, the speed is average... if i start the program in the
  > > server
   > > > (even if i dont do nothing) the speed get's very miserable in the
other
   > > > computer....
   > > > Can anyone help me with this?
   > > > Thanks
   > > >
   > > > HellGrande in Africa
   > > > PS sorry my poor english
   > > >
   > > >
   > > >
   > > >
  > >
  > >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Problem in Network 
Back to top
Login to vote
HellGrande

External


Since: Oct 29, 2003
Posts: 3



(Msg. 5) Posted: Wed Nov 12, 2003 1:12 pm
Post subject: Re: Problem in Network [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

O servidor é um pc onde está a base de dados, eu linko as tabelas para poder
usar a "mesma" base de dados com os dois computadores. Pois a minha ligação
no DataEnviroment é "C:\HD-SOFT\basedados.mdb". se nao linkar as base de
dados o segundo programa não funciona.... pois não encontra a base de
dados...
A rede é Microsoft.
eu ligo o programa à base de dados através do DataEnviroment, desculpa a
ignorancia mas nao entendo se uso DAO ou ADO....
O Windows é 2000 Prof. Access 2000. VB 6.0 SP5
Obrigado pela ajuda

Hernâni Dinarte
hd.TakeThisOut@tvcabo.co.mz - hdinarte.TakeThisOut@tvcabo.co.mz
"João Araújo" <joaoribeiroaraujo.TakeThisOut@netc.pt> wrote in message
news:eB0IrfipDHA.2012@TK2MSFTNGP12.phx.gbl...
 > Usar ADO ou DAO será simples verificar: através do VB em
Project/References
 > verificar quais as librarias que estão a ser utilizadas. Na verdade ambas
as
 > tecnologias poderão ser utilizadas em simultâneo.
 > Não percebo bem qual a necessidade das tabelas linkadas.
 > Qual a rede em causa? Microsoft? Novell? Outra?
 > O servidor é dedicado ou trata-se de um PC normal com partilha de
ficheiros?
 > João Araújo
 >
 > "HellGrande" <zukatruka.TakeThisOut@hotmail.com> wrote in message
 > news:%23nnmVqsnDHA.2304@TK2MSFTNGP11.phx.gbl...
  > >
  > > Hello Jr Mendonça
  > > I m from Portugal leaving in Mozambique
  > >
  > > I dont write the connection string, i use the dataenviroment and he does
  > > everything alone....
  > > I m not use to program to network... i dont know to connect with
ODBC...
  > > I m allways confuse if i m using DAO or ADO...
  > >
  > > Em Português
  > > Olá Jr Mendonça
  > > Parece que nos podemos entender em português, eu já programo à uns anos,
 > mas
  > > em redes sou um principiante. Eu nao uso nenhuma "Connection String",
 > deixo
  > > o dataenvirmoment ligar sózinho, nunca me liguei por ODBC (nunca
precisei)
 > e
  > > se uso DAO ou ADO, nunca consegui entender... uma das razões que nao
mudei
  > > para o .Net é realmente pelos problemos que posso ter na gestão de Bases
 > de
  > > Dados e tabelas.
  > > Aqui em Moçambique, não existe informação, nem livros, nem ninguem a
quem
 > se
  > > possa pedir ajuda... e tudo corria bem até colocarem o meu programa em
 > rede.
  > > Como expliquei, no pc "remoto", uso a Base de Dados com as tabelas
  > > "linkadas" à base de dados do "server" que também usa essa mesma base
 > dados
  > > para correr o programa. Tudo funciona bem se não fizer o "run" do
programa
  > > no servidor, porque até aí a base de dados "linkada", funciona com um
 > atraso
  > > razoavel...
  > > Espero que me consigas ajudar
  > > Um Abraço aqui da parte Sul da África
  > >
  > > HellGrande
  > >
  > > --
  > > Hernâni Dinarte
  > > HD-Serviços de Informática, Lda.
  > > Av.Vladimir Lenine nº 2956
  > > Maputo - Moçambique
  > > Tel/Fax: (258-1) 414984
  > > Cel: 082 314444
  > > hd.TakeThisOut@tvcabo.co.mz - hdinarte.TakeThisOut@tvcabo.co.mz
  > > "Jr Mendonça" <maujr.TakeThisOut@robynet.com.br> wrote in message
  > > news:#vnKfIjnDHA.1960@TK2MSFTNGP12.phx.gbl...
   > > > Where are you from? Maybe we can talk in other language.
   > > > But, your problem is very dificult to solve.
   > > > Did you tried to make connection with ODBC?
   > > > Why don't you make an direct connection with your server?
   > > > here I have the same database and same VB. I mapped my database folder
 > on
   > > > server and configured it to run direct! As a local database.
   > > > Are you using DAO?
   > > > Your connection string is similar to this:
   > > > Set db = Workspaces(0).OpenDatabase("\\server\shared\data.mdb", False,
   > > > False, "MS Access; PWD=mypassword;")???
   > > > I'm waiting for your feedback.
  > >
 >
 > --------------------------------------------------------------------------
  > > --
   > > > ---------------------------
   > > > "HellGrande" <zukatruka.TakeThisOut@hotmail.com> escreveu na mensagem
   > > > news:#8T03QinDHA.2424@TK2MSFTNGP10.phx.gbl...
   > > > > Hi
   > > > > My problem is:
   > > > > I have a program made in VB6 (SP5), the database is in Access 2000.
 > The
   > > > > program runs in a network at 100 Mbps. One of the computer's (the
   > > > "server")
   > > > > have the database, the other uses a database with all the necessary
  > > tables
   > > > > linked to the "server"... when i use the program without the one in
 > the
   > > > > server running, the speed is average... if i start the program in
the
   > > > server
   > > > > (even if i dont do nothing) the speed get's very miserable in the
 > other
   > > > > computer....
   > > > > Can anyone help me with this?
   > > > > Thanks
   > > > >
   > > > > HellGrande in Africa
   > > > > PS sorry my poor english
   > > > >
   > > > >
   > > > >
   > > > >
   > > >
   > > >
  > >
  > >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Problem in Network 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Password problem - Hey, I've been using ADO for a few years now and now I need to simply open an access DB using DAO3.6 which has is password protected. set dbtemp = opendatabase("MyDB.MDB",False,False," ;pwd=mypass") I get an error about "canno...

SQL Date Between Problem - Hello... I need some help with my SQL syntax, so it account for all international date formats. For example, if you set your region to Germany (germany), the short date format is DD.MM.YYYY. This will invoke the 3075 run-time error. Here's my..

Problem with 'Dim' ..... As Database ??? - It's worked perfectly in the past. When I have a 'Dim MyDb As Database' statement in my program, it rejects it saying'User-defined type not Declared' (I have checked that the 'VB' library where this resides is available, and it works on new projects..

Sort of a weird problem! - This has just started happening with one of my apps, the program is a VB6 frontend to a mdb backend connected with DAO. The mdb and exe are in the same folder on the HD of a laptop The laptop is connected to a network and the user has to logon. When th...

Strange Data Control problem - Hi all, if anyone can shed some light on this I'd be very happy! I have an large application which uses the DAO version that is loaded on the users system (normally 3.6). There are currently over 300 users of the application and it would appear that....
   Database Help (Home) -> Visual Basic -> DAO All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]