Abdullah Ibn Hamad Al-Marri wrote:
Invalid SQL:
INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location,
styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation,
useragent, bypass, profileupdate)
Hello folks,
I'm having hard time with MySQL, I posted this issue t the vb board, and they
claimed it's MySQL issue.
I have this issue since I upgraded to MySQL 5.0.22 and now it's still I going
on since I upgraded to MySQL 5.0.24 too.
Database error in vBulletin 3.6.
s recordcount.
The adUseClient returns the actual recordcount.
Please also take a look at:
http://dev.mysql.com/doc/refman/5.1/en/programs-known-to-work-with-myodbc.html
HTH, Cor
- Original Message -
From: "Manuel Betanzos" <[EMAIL PROTECTED]>
To:
Sent: Thursday, May 04, 2
Hi everybody, Please I need help on this.
I am beginning a new application. I am doing it with VB 6.0 - MySQL 5.0 -
MyODBC 3.51 on Windows
Is there any parameter i need to establish in order to be able to work with
RecordSets in the Client side , actually i can't because
On 4/24/06, Gabriel Mahiques <[EMAIL PROTECTED]> wrote:
>
> but, when the fields are float type, this error don't happen. When the
> fileds are float the result is the correct (if I have 1.2569 in the
> table, in the application I see "1.2569".)
Ok, so, I didn't quite understand. Let me see, you c
but, when the fields are float type, this error don't happen. When the
fileds are float the result is the correct (if I have 1.2569 in the
table, in the application I see "1.2569".)
Daniel da Veiga escribió:
Check the way your forms deal with the data from the resultset, any
implicit conversi
Check the way your forms deal with the data from the resultset, any
implicit conversion? Maybe a declaration of type that is casting
another type for the value returned from the resultset.
Also check this:
http://dev.mysql.com/doc/refman/5.0/en/precision-math-decimal-changes.html
On 4/24/06, Gabr
Hi.
A Brief description about my problem.
We have many applications development in Visual Basic 5. These
applications read data from MySQL 4.0 installed on Linux (and odbc
3.51.06). Many fields in our tables are in decimal format.
Last weekend we installed MySQL 5 on Linux
When we ran the appli
vishal wrote:
i am sending the files.
all details are in the source code
what you have to do is to create a database name test2 and have to set the
password of the server.
the code will automatically create a table name test2 with two double fields
and it will reture the error while adding the
i am sending the files.
all details are in the source code
what you have to do is to create a database name test2 and have to set the
password of the server.
the code will automatically create a table name test2 with two double fields
and it will reture the error while adding the record through r
Hello.
I'm not a VB expert, but some notes about methods of establishing such
connections can be found at:
http://dev.mysql.com/doc/mysql/en/Windows_and_SSH.html
http://dev.mysql.com/doc/mysql/en/mysql_ssl_set.html
William Blair Wagner <[EMAIL PROTECTED]> wrote:
> I
but can easily and happily upgrade to 3.51
(is 3.51 needed?)
I have no idea what to do (set properties?) to cause my VB client to
connect to the MySQL DB server using SSL?
Any help would be huge! Thanx.
--
William Blair Wagne
Curlys wrote:
hi ,
mysql databse server is in Red Hat Linux 8 box. I have an application
which is developed from Visual Basic . So that application included a
reqiurement to connect mysql data base.
Can somebody help me how to connect mysql database via VB ?
thanx in advance
curlys
First
can u kindly send me a sample coding for that
requirement plz ?
crlys
- Original Message -
From:
Peter Van
Eeckhoutte
To: Curlys ; MySql
Sent: Saturday, July 17, 2004 7:46
PM
Subject: Re: connect via VB
Use a ODBC connection (I believe you can download
Look at vbmysql.com. You should find some tutorials and primers.
-Original Message-
From: Curlys
To: MySql
Sent: 7/17/04 8:05 AM
Subject: connect via VB
hi ,
mysql databse server is in Red Hat Linux 8 box. I have an application
which is developed from Visual Basic . So that
hi ,
mysql databse server is in Red Hat Linux 8 box. I
have an application which is developed from Visual Basic . So that application
included a reqiurement to connect mysql data base.
Can somebody help me how to connect mysql database
via VB ?
thanx in advance
curlys
--
MySQL
Loftis [mailto:[EMAIL PROTECTED]
Sent: Monday, June 14, 2004 2:53 PM
To: Nawal Lodha; [EMAIL PROTECTED]
Subject: Re: How to Restore MySQL Database from VB?
\. is the MySQL CLI/monitor SOURCE command.
read your file in one statement at a time and execute it (search for
unquoted/unescaped ;'s a
in a mysql database though VB. One way of
doing it is writing the Create Database command and the mysql restore
command 'mysql -options < sql_file' in a batch file and executing it.
Is there any other better way of doing it?
Btw, I try to make an ADO connection and call the command &qu
Hi all,
I wish to restore an sql file in a mysql database though VB. One way of
doing it is writing the Create Database command and the mysql restore
command 'mysql -options < sql_file' in a batch file and executing it.
Is there any other better way of doing it?
Btw, I try t
t;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 03, 2004 1:25 PM
Subject: RE: VB .NET & MYSQL - LOCK TABLES
> You will need to reuse your database connection, do not open a new
> connection with each call or the lock will not be there.
> LOCK TABLE table1 READ;
You will need to reuse your database connection, do not open a new
connection with each call or the lock will not be there.
LOCK TABLE table1 READ;
SELECT * FROM table1;
UNLOCK TABLES;
-Original Message-
From: Mirco Santori
To: [EMAIL PROTECTED]
Sent: 6/3/04 2:17 PM
Subject: VB .NET
Hello MySql List,
I have create connection with VB .NET & MySql, and now i must use the LOCK TABLES
statment.
I want to know how i can use this sintax ..
i must open connection - begin the LOCK TABLES - begin the select statment, and then
UNLOCK TABLES ..
I think so that is not corre
I am new to mysql and started a tutorial for it and php. Mysql is running ok on my
redhat server. I thought VB might be to unstable. VB is easy to use but I think its
not web based. Also all the job adds I see want mysql and php.
thanks for responding
Walt
- Original Message -
From
Walt
You can also use VB with MySQL without problems. There are several
connectors available at the MySQL site
Freddie
-Ursprüngliche Nachricht-
Von: Walt [mailto:[EMAIL PROTECTED]
Gesendet: Sonntag, 7. März 2004 18:01
An: [EMAIL PROTECTED]
Betreff: VB and mySql
I used to program
You shouldn't have any problems using VB to write software with MySQL.
-Original Message-
From: Walt [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 07, 2004 11:01 AM
To: [EMAIL PROTECTED]
Subject: VB and mySql
I used to program with VB using MS access as the db. VB was very qui
I used to program with VB using MS access as the db. VB was very quick to develope
nice looking forms. Which language would be the best to use with mysql to create
similiar forms. These forms would be for scrolling through the db, adding, updating,
deleteing, printing...
Walt
Hi,
What is the easiest way to update data in a database field from withing VB.
Do I have to build an sql statement that can then be executed on a
connection or is their some way to get the update method to work as in
access?
This is probably a dimbo question but until my books arrive im
Hai ..
Iam Sreedhar , If iam not wasting ur time - please help me out.
Prob: Is it neccessary to instal MYSQL Software in clients place to do transactions
with database.
for example: If an an application is developed using MS-Access and VB then we have to
add ".MDB" f
> From: <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, September 26, 2003 05:52
> Subject: Can't execute code in VB 6.0
>
>
> > I'm trying to execute a code with multiple SQL statement over VB
6.0. The
> > code includes the
TED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 26, 2003 05:52
Subject: Can't execute code in VB 6.0
> I'm trying to execute a code with multiple SQL statement over VB 6.0. The
> code includes the creation of temporary tables, multiple inserts and one
> final
I'm trying to execute a code with multiple SQL statement over VB 6.0. The
code includes the creation of temporary tables, multiple inserts and one
final select...
It looks like i can only excecut one single SQL statement... does any one
know how to fix that?
I can run the code wit
"Optik Bacik Scheibbs" <[EMAIL PROTECTED]> wrote:
>
> So this is my first time here...
>
> I am using myODBC 3.51 Server 4.0.14
>
> So I created a table with one columm called "GebDat" - format Date
>
> I connect to this DB using VB6 (SP5) with ADO.
> OK - So when I add a new data it works fine
Hi,
What is the table definition? Have you got a primary index?
I work with date fields without problems in this way:
Update table set Date_Field = '2003-08-01' Where Date_Field = '2003-01-19'
Lourdes.
Optik Bacik Scheibbs escribió:
Hey!
So this is my first time here...
I am using myODBC 3.
Hey!
So this is my first time here...
I am using myODBC 3.51 Server 4.0.14
So I created a table with one columm called "GebDat" - format Date
I connect to this DB using VB6 (SP5) with ADO.
OK - So when I add a new data it works fine. But when I will update any one data I
always get an error!
No answers?
No suggestions?
Surely, someone must have got these errors.
> -Ursprungligt meddelande-
> Från: Datatal AB - Gauffin, Jonas
> Skickat: den 22 september 2003 14:16
> Till: [EMAIL PROTECTED]
> Ämne: errors
>
>
> Hello
>
> I often get these errormessages. Why?
>
> * X
Hi,
If you don't wish to use ODBC you can try GMySQL Type Library(Extension
library for libmysql.dll).Interface between VB or VBA and MySQL API
functions.
You can download it from :
http://www.a1vbcode.com/app.asp?ID=1764
or
http://www.simtel.net/pub/pd/59731.html
Regards,
If you're in VB and want to connect to a mySQL database then why not use
myODBC? it's what it's there for.
A simple connection string would be:
strConnectionString="DRIVER={MySQL}; SERVER=server;
DATABASE=database; UID=username; PWD=password;"
To access and ma
Hi list,
I am developing a program in visual basic, ans as I am brand new to mysql
database, I would like to know from you which are the proper ways to access
the database from my vb program. I know there could be using odbc, but I
would rather not to use it at all.
We´re working for windows
off topic: any VB programmers out there?
I've got a strange problem using VB to connect to a mysql database via ODBC.
The problem isn't with connecting, but rather with one particular control --
the "datalist/combo" control. In fact, the "problem" doesn't seem t
I've got a strange problem using VB to connect to a mysql database via ODBC.
The problem isn't with connecting, but rather with one particular control --
the "datalist/combo" control. In fact, the "problem" doesn't seem to have
anything to do with databases di
nothing doing
Someone give me some sample VB code to connect to mySql and use transactions
Thanx a heap
Harrison Njamba
Somak Travel Limited
P.O. Box 48495
Tel 535509 / 0733-923214
Nairobi
Kenya
- This email and any files
Character ² 2 m² meter to square hangs odbc insert into varchar VB 6 SP5
and access 2000/2002 XP
Myodbc 2.50.37 hangs insert into varchar(16) values ('m²'):
Access 2002 SR1 myodbc (MYSQL 2.50.37)
Mysql on SuSE-linux 3.23.41
But m3 dosn'
(tab delimited text files) to create the report
in design view.
hth
Chris
mcdba mcse
www.mydba2000.com
>From: yue cheng <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: VB/MySql/CrystalReport Problem?
>Date: Thu, 14 Mar 2002 08:09:57 -0800 (PST)
>
>Dear folks,
Dear folks,
Now i try to migrate my Visual Basic Application from
MS SQL Server to My SQL, I met problem when my crystal
report connect ot My SQL, Below is my code:
CrystalReport1.connect = "DSN=testDB;uid=amy;pwd=test"
CrystalReport1.Destination = 0
CrystalReport1.ReportFileName =
"c:\localfo
Hi ppl,
I have an application that used to run on ODBC to MS Access, but the
application started "slowing" down after a period of time. Some of my
friends suggested that it maybe due to the database. Which is why i am
switching to mySQL.
Can Anyone please provide me with the sample codes to conn
://www.dbtools.com.br/
Best regards.
Eugenio
-Mensaje original-
De: Victoria Reznichenko [mailto:[EMAIL PROTECTED]]
Enviado el: viernes, 01 de marzo de 2002 14:52
Para: [EMAIL PROTECTED]
Asunto: ODBC for VB application
Alvin,
Friday, March 01, 2002, 12:26:20 PM, you wrote:
AA> I am having prob
Alvin,
Friday, March 01, 2002, 12:26:20 PM, you wrote:
AA> I am having problem with my existing application (writen in VB with ODBC to
AA> an Access database). The program "starts crawling.." after running for a
AA> period of time. Slow down the entire production process.
Hi ppl,
I am having problem with my existing application (writen in VB with ODBC to
an Access database). The program "starts crawling.." after running for a
period of time. Slow down the entire production process.
I was advise to change the database as the problem was most likely to
hi,
I have connected mysql & vb. But unable to update the records.
Could you suggest any sample program.
help me out.
[EMAIL PROTECTED]
WWW.COM - Where the Web Begins! http://www.www
Is there an OLE DB Provider for MySQL or should I use the Generic ANSI SQL
provider (if there are one of those)? Trying to use MySQL as a backend
database for a project but performance is slower than using even MS Access -
surely there must be a provider out there that blow away at least MS Acces
Hi,
> -Original Message-
> From: yousif shams [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 29, 2001 7:34 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Vb DbGird Limitation
>
>
> hi there,
>
> I was writing a MS VB 6 code and I have added
hi there,
I was writing a MS VB 6 code and I have added to the form a DBGIRD component
(unbound) to display the data, which was retrieved by an sql statment to the
from from a MySQL database into a recordset.
But I got an error in the VB mentioned the following:
Rowset not Bookmarkable
I
Hello,
Is it possible to distribute a MySQL db with a visual basic application - in
other words, use MySQL as the backend DB for a Visual Basic app?
Karl Stubsjoen
www.excelbus.com/info-m
-
Before posting, please check:
h
<[EMAIL PROTECTED]>
>Sent: Thursday, November 01, 2001 14:44 PM
>Subject: VB/MySQL
>
>
>Hi,
>
>Is it possible to work with VB and MySQL directly using dlls, just like
>working with VB and SQL Server.
>
>QB
>
>-
Sent: Thursday, November 01, 2001 14:44 PM
Subject: VB/MySQL
Hi,
Is it possible to work with VB and MySQL directly using dlls, just like
working with VB and SQL Server.
QB
-
Before posting, please check:
http://www.mysql.
Hi,
Is it possible to work with VB and MySQL directly using dlls, just like
working with VB and SQL Server.
QB
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi !
)-Original Message-
)From: Mikko Lampinen [mailto:[EMAIL PROTECTED]]
)Sent: Tuesday, September 18, 2001 12:33 PM
)To: [EMAIL PROTECTED]
)Subject: MyODBC properties window / VB data environment / ADODB
)
)
)Hi,
)
)I'm using Data environment (Visual Basic) and MyOdbc to m
Hi,
I'm using Data environment (Visual Basic) and MyOdbc to make a connection to
Mysql database. Every time my program establishes a connection using Data
environment, the MyOdbc property window pops up. This dialog does not appear
if connection is established using ADODB.
So, firstly, is there
What data type should be used to store jpeg with MySQL connecting with VB
ADO. I think the answer would probably be Blob or Long Blob, but how? VB
complains MySQL's Long Blob data type is not compatible!
-Jason
-
B
I want to build a VB application that connects to mysql (over the internet)
running on linux. i have mysql currently running on LAMP system fine, but do
i just need to install MyODBC for linux on the mysql server or what?
also, are there any major security issues to this i should know about? any
Hi,
Try
http://www.avukatpro.com/mysql.html
http://www.dwam.net/MySQL/
Ken
- Original Message -
From: "Pablo Javier Gonzalez Mateos" <[EMAIL PROTECTED]>
To: "Lista MySQL Ingles" <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 5:12 PM
Subject: VB wit
At 06:12 PM 8/21/01 -0300, Pablo Javier Gonzalez Mateos wrote:
>Hello, im new in the list, im a VB 6.0 programmer, and im learning the
>MySQL basics with the Paul DuBois Book... i have a question to do... its
>possible to make a connection from an VB app. to a MySQL database ???,
You can use ODBC for mysql ... (download from www.mysql.com )
Install it , then just use it ...
To try it, make a Datasource for the ODBC ...
In vb make use a Datawizard form, select remote ODBC ...
then select the datasource you create it ...
and you have a simple maintainance form to a table
Hello, im new in the list, im a VB 6.0 programmer, and im learning the
MySQL basics with the Paul DuBois Book... i have a question to do... its
possible to make a connection from an VB app. to a MySQL database ???, if
its possible, how can i do it ???.
Thanks you.
Best Regards
le < -- as requested "
> I try to execute mySQL query from VB:
>
> strSQL = "SELECT @BF:= Date From Results Where GameID=" & GameID & " Order
> by Date ASC LIMIT 1;"
> strSQL = strSQL & "SELECT @BL:= Date From Results Where GameID="
g
Venu> functionality and how you can make it up.
Venu> http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#
Venu> Missing_Sub-selects
Venu> Regards
Venu> Venu
Venu> )From: Mariusz Muszalski [mailto:[EMAIL PROTECTED]]
Venu> )Sent: Wednesday, August 15,
my question was not about subqueries
Mariusz Muszalski
> -Original Message-
> From: Venu [mailto:[EMAIL PROTECTED]]
> Sent: 15 August 2001 16:29
> To: Mariusz Muszalski; [EMAIL PROTECTED]
> Subject: RE: MySQL + VB problem
>
>
> Hi !
>
> MySQL doesn
.html#
Missing_Sub-selects
Regards
Venu
)-Original Message-
)From: Mariusz Muszalski [mailto:[EMAIL PROTECTED]]
)Sent: Wednesday, August 15, 2001 7:48 AM
)To: [EMAIL PROTECTED]
)Subject: MySQL + VB problem
)
)
)I try to execute mySQL query from VB:
)
)strSQL = "SELECT @BF:= Date From Results Wh
I try to execute mySQL query from VB:
strSQL = "SELECT @BF:= Date From Results Where GameID=" & GameID & " Order
by Date ASC LIMIT 1;"
strSQL = strSQL & "SELECT @BL:= Date From Results Where GameID=" & GameID &
" Order by Date DESC LIMIT 1;
Roger Larsson writes:
> I'm posting to this general list because there doesn't seem to be any
> list to report a spontaneous crash to.
>
> Have tested MySQL 3.23.39-nt for some days by implementing a small
> project. It has been running fine up to now when I after having dropped
> a column from a
I'm posting to this general list because there doesn't seem to be any
list to report a spontaneous crash to.
Have tested MySQL 3.23.39-nt for some days by implementing a small
project. It has been running fine up to now when I after having dropped
a column from a table using MySQL GUI, tried to r
yes :
check :
http://www.avukatpro.com/mysql.html
for Visual Basic & Mysql , Asp & Mysql , Mysql & Myodbc silent installation
- Original Message -
From: Evan James Dembskey <[EMAIL PROTECTED]>
To: Mysql <[EMAIL PROTECTED]>
Sent: Tuesday, July 17, 2001 11:2
Hi,
Is it possible to use Visual Basic to access a MySQL db running under NT?
Regards,
Jim
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
Yes, you can run MySQL on a Windows machine and you'll need MyODBC if you're
connecting through ODBC.
- Original Message -
From: "Simon Metz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 9:05
Subject: mySQL & MS VB
> I a
I am developing a Visual Basic application requiring a database on a win32
machine running 98SE and wanted to know if mySQL will run on this machine. I
would like to avoid using MS SQL server as I will not require stored
procedures and this will be running on a laptop for demo purposes.
Also, my
Hi There!
I have some trouble with a webaplication.
I used to run it with an Access dbase but have changed to a nice MySQL dbase and then
i got problems with the commands Addnew,Update,MoveFirst I use the samt locks and
cursors as I did earlyer.
Any good solution? Are there any parameters to s
see this :
About mysql & vb6
http://www.avukatpro.com/mysql.html
- Original Message -
From: Dennis Salguero <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, June 29, 2001 6:03 AM
Subject: Re: Connecting to MySQL w/VB
> - Orig
ehalf
> Of [EMAIL PROTECTED]
> Sent: 29 June 2001 10:41
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE: Connecting to MySQL w/VB
>
>
> Give MyODBC a try, its on the mysql.com site
> and its given my no problems at all in vb.
>
> Sean
>
> -Origin
Give MyODBC a try, its on the mysql.com site
and its given my no problems at all in vb.
Sean
-Original Message-
From: Robert Skinner [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 29, 2001 3:45 AM
To: [EMAIL PROTECTED]
Subject: Connecting to MySQL w/VB
I am trying to connect to MySQL
]>
Sent: Thursday, June 28, 2001 11:38 PM
Subject: Re: Connecting to MySQL w/VB
> - Original Message -
> From: "Jason Brunk" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, June 28, 2001 8:18 PM
> Subject: Re: Connecting to MySQL w/VB
- Original Message -
From: "Jason Brunk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 8:18 PM
Subject: Re: Connecting to MySQL w/VB
> i know i am definitly knew at this, but his permissions could be set more
or
> less for read on
i know i am definitly knew at this, but his permissions could be set more or
less for read only.
i am just spitting junk out, i am new, but i don't like sitting idle in a
group. i have been watching this thread closely, because i do developement
on a large scale in ASP and VB.
so just i
- Original Message -
From: "Robert Skinner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 28, 2001 7:44 PM
Subject: Connecting to MySQL w/VB
> I am trying to connect to MySQL using a connection string using VB6. The
> read part is great bu
I am trying to connect to MySQL using a connection string using VB6. The
read part is great but I don't seem to be able to add records. Can anyone
steer me in the right direction?
[EMAIL PROTECTED]
-
Before posting, please ch
I'm using Visual Basic with DAO 3.6 and I try to execute this query
dim rsPersonen as dao.recordset
Set rsPersonen = db.OpenRecordset( _
"SELECT Mitglieder.* FROM Mitglieder " + _
"WHERE Mitglieder.geb='1978-08-26'")
Here I get an Error-Message:
"Runtime-Error 3464, ..."
If I use any other SQL
>I'm using Visual Basic with DAO 3.6 and I try to execute this query
>
>dim rsPersonen as dao.recordset
> Set rsPersonen = db.OpenRecordset( _
> "SELECT Mitglieder.* FROM Mitglieder " + _
> "WHERE Mitglieder.geb='1978-08-26'")
>
>Here I get an Error-Message:
>
>"Runtime-Error 3
I'm using Visual Basic with DAO 3.6 and I try to execute this query
dim rsPersonen as dao.recordset
Set rsPersonen = db.OpenRecordset( _
"SELECT Mitglieder.* FROM Mitglieder " + _
"WHERE Mitglieder.geb='1978-08-26'")
Here I get an Error-Message:
"Runtime-Error 3464, ..."
If
Or MyVbQL ... http://www.icarz.com/mysql/
Eric
Rolf Hopkins wrote:
> Can connect using MyODBC.
>
> - Original Message -
> From: "Andrew" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, June 15, 2001 13:52
> Subject: RE: MySQL
Can connect using MyODBC.
- Original Message -
From: "Andrew" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 15, 2001 13:52
Subject: RE: MySQL on VB
>
> I need some help.
>
> I would like to know if VB can interface directly with MySQ
I need some help.
I would like to know if VB can interface directly with MySQL.
If possible, then how shall I go about on it.
Thanks.
Andrew.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
s best to ditch it in favor of
re-writing all of the code in ADO. As someone else already stated, the less
complex the application, the better than VB and MySQL will work together.
Otherwise, proceed with caution and get yourself a good ADO reference.
Goo
This works fine from VB6. Install the MyODBC driver (get it from the
MySQL web site), then set up a datasource just as you usually would.
Ideally, you won't have to change any of your VB code - just bind the
ADO/DAO controls to the MySQL datasource rather than the Access
datasource.
rol to the backend...
Good Luck.
ChrisB
MCSE MCDBA
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 29, 2001 11:14 AM
To: Thompson, Mike; [EMAIL PROTECTED]
Subject: Re: VBA/VB DAO/ADO MS Access to MySQL?
Yes it can, via ODBC.
I've never done it t
Yes it can, via ODBC.
I've never done it though. (I don't work in VB)
Cal
- Original Message -
From: "Thompson, Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 29, 2001 12:37 PM
Subject: VBA/VB DAO/ADO MS Access to MySQL?
Howdy,
I currently have an application which uses DAO and ADO coding in VBA/VB as
well as databound objects in VB to access a MS Access database. Can DAO and
ADO in VBA/VB and databound objects in VB be made to work with a MySQL
database?
Anybody done this successfully?
Cheers,
Mike
Hi All,
I have created a simple MySQL database with a blob field. I would
greatly appreciate it if someone could help me upload a file to a particular
BLOB field using a ASP page with JavaScript or VBScript.
Thanks in advance for all your help,
Anoop
The difficult we do immediately,
t
m/mysql/
> Good Luck!
> -Original Message-
> From: Warren van der Merwe [mailto:[EMAIL PROTECTED]]
> Sent: Friday, May 11, 2001 7:37 AM
> To: 'Eugénio Veiga'
> Cc: [EMAIL PROTECTED]
> Subject: RE: how to access mysql using vb as front end
>
> Hi there
>
> He
AM
To: 'Eugénio Veiga'
Cc: [EMAIL PROTECTED]
Subject: RE: how to access mysql using vb as front end
Hi there
Herewith is the DLL you require (sent on seperate email so as not to clog
the group). This zip file includes the source for the dll as well as some
documentation. Really easy
:[EMAIL PROTECTED]
> ]On Behalf
> Of Eugénio Veiga
> Sent: 11 May 2001 12:54
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: how to access mysql using vb as front end
>
>
> Hi
>
> I've been looking in mysql.com and I didn't find myvbql.dll.
>
Hi
I've been looking in mysql.com and I didn't find myvbql.dll. The MySql website you
talk is www.mysql.com?
You know all the functions and Sub of the dll that can be used ?
Thanks
Eugénio Veiga
Warren van der Merwe wrote:
> Hi
>
> I am successfully developing with VB
1 - 100 of 113 matches
Mail list logo
