How To Link Remote MySQL Database To Local Access Database?
i try to create Access DB, and link some tables from remote MySQL DB to this local DB.
it's very easy to do it manually.
could any one tell me how to do it in VB program?
Thank you so much!
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Using A Remote (And Local) Access Database For Login!
Hi,
I am making a small program with multiple users that all need to access the same files, i would like to use an Access Database found on the network to get the users and password, how would I check the username and password typed in against the username and password in the Access database??
I have created the database but have no idea of using Access Databases with VB
How To Link To A Remote Access Database.
I'm trying to build a front end/back end database where the two halves are on two separate PCs on the same LAN.
Is this a stupid idea or is it possible to create a link like this.
I can create a clinet/server type thing that can pass strings and files, but I would just like to be able create links in code.
I could use any advice here...(I have no idea what I am doing really...) :)
Using Visual Basic6 To Access Remote MySQL Database
Newbie-help needed: I've looked through the FAQ and done some searching in the archives but can't find anything specific enough...
I have a MySQL database on a website. I normally access it with .php pages. I don't have .asp.
On my home computer, I have Visual Basic 6. I don't have Visual Basic .Net.
I would like to make a VB6 application that accesses my database. Please can someone point me to a page that starts me off learning how to do this ?
Tim in Ireland.
Edited by - skyscanner on 9/12/2005 1:38:58 AM
Export Data From Local Database To Mysql Database On Web
I have an access database and a clone of that database in mysql format on a webserver. Using vb, is there a way I can populate the mysql database with the data from the access database (It's only one table)? That would save me from having to manually upload a csv to my server all the time...thanks for your help!
Remote Database & Local Database
Hi,
I want to connect Remote(exmp.www.domainname.com/cgi-bin/db.mdb) as well as local database (db1.mdb) for updating new records from local database to remote database. the database should be MS Access.
ThanX
Sudhakara Rao N
Database Locations Local & Remote
Hi,
I'm developing a test application which will principally used by a single user. The application is fairly simple a vb frontend with an access 2003 database.
However I want the frontend to be able to point to two identical (bar data) databases. One will sit on the same machine the vb program is on and will be accessed easily, but I need to be able to point the vb frontend at a remote machine using the IP address of the machine.
Does anyone have any experience of doing this and thus any advice/warnings the would like to share? I'm going to be starting the development tomorrow, and currently imagine a "settings" box which accepts the location of the database to connect to upon start up.
Also does anyone know if its possible to change the connection string in a dataenvironment programatically, the vast majority of my code is using command modules and thus will be easily changable but one or two data report queries reply upon the dataenvironment and could be slightly more tricky.
Thanks all!
{resolved Kinda}Accessing MySQL Database On Local Machine.....
I work for an internet radio station. our DJ program Streaming Audio Manager uses MySQL to control song info, play info, Streaming info, etc.... everytime we lose a DJ we have to change stream server password, then give it to all the other DJ's and make sure theu can still conect. I want to write a program that my DJ's can install on their computer that will automaticaly connect to our webste, download the new data, then edit the MySQL database as needed..... I have worked with MySQL when I worte websites, but I have no Idea how to do anything in VB. any help would be appreciated, more detail can be provided as well as neccisary.... ty all I know that the info i need may have already been shown in these forums, but trying to find it gave me a headache. oh and one restriction, unless someone wants to send me a free copy(yeah right) of VB.NET Enterprise edition, I can only use VB6 capabilities....(I am NOT asking anyone for anything illegal. )
nvm upon further digging I found out that the data I need to change is not stored in th edatabase, but an xml file... that I know how to do...
Tell me, and i will forget...
show me, and I will remember...
Involve me, and I will learn...
-Karaethon
me: http://ffxi.allakhazam.com/profile.xml?45524
Edited by - Karaethon on 7/12/2004 5:44:52 PM
Connecting To A Remote MySQL Database?
Hi all,
I found a script elsewhere on these forums using ADODB or somethin to connect to a remote MySQL database.
Code:
Dim cn As New ADODB.Connection '-- create an ADODB connection object
Dim strConnection As String
'-- specify your connection string, apply appropriate values to the parameters with [ ]
strConnection = "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=(ip masked);" & _
"DATABASE=(masked);" & _
"USER=(masked);" & _
"PASSWORD=(masked);OPTION=3;"
Set cn = New ADODB.Connection '-- initialise you connection object
cn.Open strConnection '-- open your connection object
rs.Close
conn.Close
'-- your codes goes here
'cn.Close '-- close your connection object when you wont use it anymore
'Set cn = Nothing '-- set it to Nothing after closing
But it says invalid login ... apparently it finds the server but I get an invalid login.
I tried using port 3306 but then it wouldn't even find the server. I know the username/pwd are correct.
How can I fix this? Thanks,
-Matt
Get Data From Remote MySQL Database
I'm writing a set of applications that run on multiple clients' PCs and need to access a remote (server-side) MySQL database.
Having an application running on the server and listening for connections is not an option.
Having direct connections from the apps to the database (such as with myODBC, myVBQL) is also not an option.
The only method I have worked out is to browse to a php webpage in a hidden webbrowser object, sending user/password for authentication...
Then if the user is verified, the webpage outputs the required data to hidden html form objects. The number of fields is variable so first it has to send the number of following objects...
Then the vb app reads this html code and strips out the data.
HELP! This is horribly messy and inefficient, but I can't think of any other way to get it to work given those 2 limitations. Coding everything as php/webpages would be even worse and almost certainly wouldn't work anyway.
How else can I do this? Thanks!
How Can We Connect A Remote Mysql Database
Hello everybody .
im murali , I have a doubt in connection strings in Vb 6.0. Im developing a vb application in tht application i have to store datas in a web database that is in MYsql server. How can i connect tht .Any body idea please tell .
im have myodbc driver for Mysql .
How To Import MySql-database Table To Access-database
I'm building a client-database in .NET for my work and I'll have the program copying rows of data from the online MySQL-database to a local offline Access-database. Everything looks alright when opening the local database in Access but when opening it in my app I get an error saying that the index or primary keys will conflict because of duplicates. I have tried endlessly to switch primary keys, creating new ones but nothing seems to help. Any suggestions?
VB Program Accessing Remote MySQL Database
Hai,
I have a program which gets data from a remote database and displays on the screen. Its working fine. But I want to provide some messaging to users when there is no internet connection or the remote server is down. How do i do it?
Please help
Regards
Varrey
Connect To Remote MySQL Database And Get Data
Hi,
Im using Visual Basic 6.
I own and run a website which is powered by a MySQL database. It contains tutorials and stuff like that.
Now what I want to do is to create a program which will connect to that database and will then pull data from it. The first thing I want to pull is the tutorial categories which are in a table called tutorial_cat
Id like them to then be listed in an options box or something...
How do I go about doing this?
Thanks
Syning Between Sql Server And Local Access Database
hi,
i need to sync tables between a sql server and local databases on about 1000 clients over internet!
an both sites tables will be read and write into!
whats the best way to do this? i dont get it by myself!
thx & greets
natarius
Inserting New Records From Local Db(Sql Server) To Web Database(MS Access) Through VB
Dear friends,
I have a scenario . I have an inventory system in VB with SQl Server as back end. I want to insert/update some of the fields in that inventory system(for example say fields like 'product_category', 'product_price', 'product_brand') to a web database (in MS Access) which has the same above fields .Im using ASP for the web pages.
My question is how to insert/update records from the Vb system which is using the Sql server to the web database which is using access ?How can i connect to the web thru VB Code
Is it in the connection string Do i have to pass the Ip address of the web site and then connect ?
please can any one provide me a pseudo code for this if any one one knows?
ITs very very urgent
Thanks
RR
If any mistake is there ,please excuse me as a new user to this forum.
Access MySQL Database Over The Net
Hey guys,
Is it possible to make a VB program that can access a MySQL database over the net?
Basically what I want to do is make a program that, when run, brings up a username and password box. I want this username and password to be the same as a forum that runs on MySQL, so they can use their forum account to access the program.
Is this possible?
Access MySQL Database
hi, I'm a newbie to evb programming.
I've set up a MySQL database and I wanna ask if it's possible to acces the MySQL database through some connector using evb? If so, through what? ADOCE?......
As I read from MySQL manual, it only mention about using vb and ADO...
Pls help! Thanks!
Remote Access Database
I would like to know what is the best solution to setup
our 4 offices to share one central Access database.
Requirements:
- 4 offices in different location.
- All PC has XP office Pro/ XP Home installed.
- Each office has Cable modem for internet.
Since cost-effective is our most concern. We would like to
keep the cost at miminal. Can we achieve this with out
using a server?
Thank in advance!
-- Andy
VB6 Remote Access Database
I am using VB6 to connect to remote MS Access Database
My code so far:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://www.bla.co.za/db/db.mdb"
No User id or Password is reguired.
Tried a few other options but don't seem to get it to work.
Remote Database Access
i have created a database app and i want to be able to update the dbase from my comp. ie i have the program on one computer and the database on another and i want to change the data through either FTP or HTTP. or something like that!
Help!
Remote Database Access
hi all,
I have an access database on a web server (say, www.a-server.com/me/database/mydb.mdb).
anyone knows what should the connection string be if I wanted to access this database from a vb application?
thanks
Remote Access Database
How does one connect to an access database on another machine.
Say my app has two modules - a server and client.
Now this client wants to connect to the machine on which the server resides (only the database - no winsock).
Somewhere I read before - that we are to use the IP address of the remote machine - but it doesnt work(atleast for me).
This is my connection string :
Code:
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\" & RemoteMachine & "sharedFolderNamelibrarydatabaseMyDB.mdb;Jet OlEDB:Database Password=myPassword"
Tell me what part is wrong in the above connetion string - or the whole of it??
Thanks
Remote Database Access
how can I access a database stored at geocities or something and put the info in the program (through code)
Remote MS ACCESS Database
Hi guys,
I am trying to connect to an remote MS Access database over the internet using VB 6 ADO.
I am using the data provider MS Remote and am not able to connect.
Do I need a web server (on the server side like IIS)? and if so how do i configure it?
Can anyone help???????
Regards
Remote Database Access
Hi
I m new to this group.
I m devloping an application in VB and SQL server.
Till now I had a local server on which SQL server is running.
But now i want to make my database accessible to other location also, which are at a far distance..
So my question is how can others access this database thru internet
I have used ADO with ipaddress of the server in connection string.
On same lan it works fine , as IP range is same.
But how will it be accessed thru internet..
regards
Harpreet
Remote Database Access
Hi ya all,
I know that the question I am about to ask has somewhat complicated answer but I would really appriciate some help here.
I am writing my first VisualBasic application for a customer that I have already made the Web Site. On the site I am interacting with the database where I am storing info about the customers and orders they have placed. Now, to speed the process up, the VB application will have the same purpose (to allow customers to create orders), and here I would like to be able to have the option for the user to interact with the same database.
Question: am I correct if I say that this is possible in VB by using RDS? If so, can someone help me out and tell me how? Or at least give me a hint?
any words of wizdom is welcome here. If possible, can someone tell me where can I find an code example that I can study it.
Thanks
Sylvano
Sylvano
dsylvano@hotmail.com
How To Access Remote Database.
Hi.
Now i am using the access database present in local machine.
So i use like this coding.
opendatabase("souther.mdb")
Suppose i place the access file in the network means.. how can i read the file..
Opendatabase("210.210.99.119Southern.mdb");
It is possible or not..
If not how can i read it
VB And Remote Access Database
hi everyone!
i was asked to update a vb app that connects to a database on a local computer or on a networked computer. with the current setup, connection is easily achieved by setting the appropriate path in the connection string. this time, the access database is to be put on a computer outside the intranet, but whose IP address is known. i would like to know how my vb app can connect to that access database (i.e., is it a simple editing of the connection string) given the following information:
1. the computer's ip address is XXX.XXX.XXX.XXX
2. the access database is stored in D:InfoDB folder of the above computer.
3. the name of the access database is DBupdates.mdb
also, i'd like to know how the connection differs between ADO and DAO.
thank you.
Remote Database Access
Hi All,
I have just started developping a new application that will operate over two sites to a single database. As part of the application I wil have to capture data from a hand held terminal that will be connected to the local desktop by serial port, and upload this to the remote database.
I can't use remote desktop as I will be unable to connect to the local com port to capture the data from the hand held terminal.
The question is what database to use.
I could use MS Access (the preferred option), but I am not confident about Access's ability to maintain data integrety accross the vpn as my understanding is that MS Access transfers the data, and any loss of connection could lead to data corruption. However this understanding is based on Access 97. Do the latter versions of Access, 2000 and 2003, have this same restriction. If the answer is yes then I guess I am stuck with SQL Express which seems rather a large hammer to crack a small egg.
Hope someone can help.
Steve
Remote MS ACCESS Database
OK, I'm REALLY frustrated I've not done much database programming at all, but I've figured out how to open a local database. Fine. NOW I'm trying to set up a web site that has a database running behind it. It's being hosted somewhere else. But I also want to run an application here that will connect to it. Simple, right? Just an ADO remote connection. Well, I can't for the life of me figure out how to get it to connect. Currently I'm trying something like:
Code:cn.Open "Provider=MS Remote;Remote Server=http://myserver.com;DSN=mydbase.mdb;UID=admin;PWD=password"
and getting an Internet Server error message. Marvelous. I also did some searching around and found this web site: http://www.able-consulting.com/ADO_Conn.htm ...but how in the world do I know which one to use? Any suggestions would be most welcome. Thanks!
ADO - Remote Access Database?
Ok I need to know if I can connect to a remote Access Database... here is a list of what I have/need
mdb on a website (eg. http://xxx.xxx.x.xxx/Accounts.mdb), actually I have IIS setup on a machine, but it should work the same as a website
Using ADO, connect to the database through VB 6.0 without using ASP or XML
Firstly, I'd like to know if this is possible.
Secondly, If it is, what is the connection string for this?
Thanks in advance!
Jon
DAO 3.6 Link With Access Database Got SQL Problem
Here is my problem. My database got one field call "Status" and it got the value list "", "1" and "2". I want to display just only blank one.
This is the SQL I had try
Set rChunk = dChunk.OpenRecordset("Select Status from Chunk where Status is null ", dbOpenDynaset)
Set rChunk = dChunk.OpenRecordset("Select Status from Chunk where Status ='' ", dbOpenDynaset)
Set rChunk = dChunk.OpenRecordset("Select Status from Chunk where Status <> '1' or '2' ", dbOpenDynaset)
Set rChunk = dChunk.OpenRecordset("Select Status from Chunk where Status <> '1' or Status <> '2' ", dbOpenDynaset)
But all fail
PLease Help
THNKS... JIMFI
Select And Insert From Shared Database Into The Local Database.
Hei hei Kiran;
felt happy for your intrest.
Ya, I will explain a bit more about my problem.
Now I have a MS Access 2002 Database which is working perfectly in one system.
Now I have splitted this database with the 'Database splitter' tools menu.I put the backend in a shared folder and front end in every client system and it is working perfectly, without doing any changes.
But as the databse is in the shared folder and the user will have access to this folder only when he has net connection but most of the time they have to work offline.
The user must have access to change only one set of data at a time.
So I have to copy only that set of data from the database in the shared folder to the tables which are in the frontend MDB file.
I think as I don't need to copy all tables, I have to create empty tables which I need to copy and fill the required data into them with VBA code.
for this I need to kow how to connect to the databse in the shared folder and insert into the local database.(of course I have to use the style of connection to connect to the local database as well.)
Is it comprehensible to you , if not i am sorry , please ask where did u not understand.
Any way Thanks a lot for your intrest .
Kiran Karnati.
Access MySQL UTF8 Database
Hi,
My application is written with VB6,
I would like to insert the data to a MySQL database, which the database charset is utf8_unicode_ci.
Any idea?
Thanks!!!
Felix.
Connect To A Remote MS-ACCESS Database
I have an access database that has shipping information (invoice#, customer name, USPS tracking #). I created an ASP to query the database and that works fine. On the other hand, I have a VB application that updates the tracking information (along with some other data) into my accounting software.
The point is that I would like to modify the VB (VB 6) to also update the remote database with the last invoices shipped. I've spent about 2-3 hours trying to look for the proper ado connection string, but I'm not sure I found it. Can anybody point me in the right direction? Any help would be greatly appreciated.
So far, this is what I have:
I created a sample project that connects to the database using the ADO Data Control. I was able to open the database & table (Tracking) but I get an error when I use the .AddNew method.
Is this the best way of doing, should I deal with the error or is there a better way of doing it.
Remote Access DataBase Problem...
Hi
I have a problem with remote access.
I'm using MS-Access2000 as a database.
My requirement is application has to update the database,which is in the server by client database,which is in the local machine.
Here user can connect the server database by using Dial Up. After connecting to the database it is showing DB path like this... "//ServerName/Folder_Name/Master_DB.mdb".
Previously i developed this application for LAN using DAO and passing the database paths from .ini file. it was working in LAN. but if i pass the above server database path thru .ini file for master database then it fails.
what i have to do now? what technology i have to use to connect database?(DAO,RDO or ADO)
how can i connect Remote Server Database thru VB and how can i update it with client DB?
Thanks
Pradeep
Can Anyone Tell Me How To Connect To Remote Access Database
i'm using vb6 , and access databse for database ,
i want to connect to remote access database on the server
but i don't know how, i think there is some setting in odbc or what?
here is the code i use
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
.Open "Provider=MS Remote;" & _
"Remote Server=http://info;" & _
"Remote Provider=MSDASQL;" & _
"DSN=ourdatabasenew6;" & _
"Uid=admin;" & _
"Pwd="
is it correct?
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
or this is correct?
.ConnectionString = "Provider=MS Remote;Remote Server=http://myServerName;Remote Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:somepathmydb.mdb" '"admin", ""
.Open
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
i tried this 2 codes but didn't work , i think there is some problem in setting in odbc .
thank you
Connection To Remote Access Database
Hi everybody!
I use the following code to connect to an Access Database on a web-server:
Code:
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.ConnectionString = "Provider=MS Remote;" & _
"Remote Server=" & strServer & ";" & _
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & dbDatabasePathName
cn.Open
rs.ActiveConnection = cn
rs.CursorType = adOpenKeyset
rs.LockType = adLockPessimistic
rs.CursorLocation = adUseClient
rs.Open "SELECT * FROM tbUtenti"
The connection is successfull (cn.State is 1).
But when I open the recordset, this error occours:
Run-Time error '8447':
Internet Server Error
Does someone know what is the error?
Has someone a solution?
Thanks very much!
Happy new year!
Access Remote Database - Theory
I have a vb program that has an access database attached to it. We keep track of all out quotations with this system. Currently we have one database/program and each of our facilities. Due to our wonderful economy we have closed a bunch of our plants and are now changing our structure, so I am forced to go to a central database for all. (We did not do this in the past because of network speed).
My theory question is - I would like to keep the main VB program as much in tact as possible (this program has been around for years, and does a lot of things for us), but be able to tie to a central database and not sacrifice a ton of speed.
I see a lot of posts saying that Sql might be a good way to do this. How difficult would it be to make the transfer from access to sql. I feel I understand access and vb very well, but am new to sql server, would it be hard to pick up? Is this the best approach? Any other ideas/approaches?
Just a point of information my individual access databases are all about 2-4meg in size, when I merge them I end up with a 20 meg or so file.
Thanks for any ideas,
Locking Out A Remote Access Database
I have an access database on server "B" and I need to get a copy of it onto Notebook "A". While I am doing the copy I don't want to upset PC "C" that is currently happily using the database.
I was thinking along the lines of some kind of record lock I could put on the database while I am doing the copy, that I could release after the copy has completed. While the lock is ON I would expect PC "C" to just be waiting on (should it be between SQL Requests) until the lock has been released.
Is there such a lock in a Jet database and would it work in this manner?
TIA
Connecting To A Remote Ms-access Database
hi ppl,
i'm new to this group and new to vb too.this might sound dumb, but here goes anywz.
i'v been tryin to connect to a remote Ms-Access database using the m/c's IP address. i tried using the IP address in the connection string. it ain't happening. its recognizing the m/c name though. i need to make it work with an IP address, any help will b greatly appreciated. a few examples of code will speed up things ;-)
thanx
How To Connect Remote Access Database Through Vb
Dear All
How to connect remote ms access database through vb,
thanks in advance
Bhadresh Sangoi
Cell : +91-9892638621
email@removed
I'm careful not to confuse excellence with perfection.
Excellence, I can reach for; perfection is God's business
How To Connect To A Remote MS-Access Database?
hi friends
i am desiging one applciation in that i need to connect to my company website server in that i will have a MS-Access table.
i have created one DSN for this table in the web server (DSN=STBDSN).
think that i have a website called STB.com in that i have DSN called STBDSN this DSN points to the MS-Access file in the server.
so from VB how can i connect to that DSN..
please help for this
thanks in advance.
thanks
---------------------------------------------
Srinivas.
How To Connect To Remote Access Database Using Vb
hi friends
how to connect to a remote MSaccess database using vb6.0.
i m having Msaccess database in the remote server i want to connect to the database and need to do operations like create edit and delete and view the recirds.
plz give as a possibilities to connect to a remote server
if u have a sample it will be better.
thanks
---------------------------------------------
Srinivas.
|
TRACKER
