RE: MyODBC leaking handles...

2001-12-19 Thread Jens Collin
Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I

RE: MyODBC leaking handles...

2001-12-19 Thread Venu
Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches

MyODBC leaking handles...

2001-12-18 Thread Jens Collin
? Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com

RE: MyODBC leaking handles...

2001-12-18 Thread Venu
Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I

MyODBC availability

2001-12-17 Thread Kevin Donnelly
Does anyone know why it is that the MyODBC authors prefer not to allow that to be distributed in the unixODBC package, or with distros (eg the SuSE CDs don't contain it)? Is it a licensing issue, something to do with the ODBC spec, or just plain don't want to do that, so there (which, I

RE: MyODBC availability

2001-12-17 Thread Venu
Hi Kevin, -Original Message- From: Kevin Donnelly [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 12:47 PM To: [EMAIL PROTECTED] Subject: MyODBC availability Does anyone know why it is that the MyODBC authors prefer not to allow that to be distributed

Re: MyODBC availability

2001-12-17 Thread Trond Eivind Glomsrød
Venu [EMAIL PROTECTED] writes: No such, as long as it is GPL distribution. Actually, it's Public Domain, not GPL. It's included in Red Hat Linux 7.2. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check:

Re: MyODBC availability

2001-12-17 Thread Peter Harvey
Does anyone know why it is that the MyODBC authors prefer not to allow that to be distributed in the unixODBC package, or with distros (eg the SuSE CDs don't contain it)? Peter will answer this, why MyODBC is not included in unixODBC distribution :) Peter, any comments

Unix-Timestamp() in myODBC 02.50

2001-12-16 Thread Bart Goormans
There seems to be a flaw in the myODBC driver 02.50 when working with the Unix-Timestamp() function. Apparently, the driver doesn't know which data-type to use... When I send the sql statement: -- Select ( UNIX_TIMESTAMP(U.lastTime

RE: Unix-Timestamp() in myODBC 02.50

2001-12-16 Thread Bart Goormans
that does the trick. My guess is that the ODBC driver is behaving badly in this case ... Cheers, bart Van: Bart Goormans Verzonden: zondag 16 december 2001 9:21 There seems to be a flaw in the myODBC driver 02.50 when working with the Unix-Timestamp() function. Apparently, the driver

Connecting to MySQL from Oracle using MyODBC driver

2001-12-13 Thread Alfisi, Steve
Dear Sir or Madam, I am currently trying to connect an Oracle 8.1.7 database running on Windows NT 4.0 to a MySQL database running on Linux (not sure of the MySQL or Linux versions). When I try to select from a table I am getting the following error... ORA-28500: connection from ORACLE

Re: Connecting to MySQL from Oracle using MyODBC driver

2001-12-13 Thread styb
it wuld be nice if mysql supported sub queries ie. select A.MESSAGEID from MESSAGEDATA as A where A.MESSAGEID in (select B.MESSAGEID from MESSAGES as B where B.SUBJECT='Invitation to join the hanky panky group') _ Do You Yahoo!? Get

myodbc

2001-12-11 Thread Gustavo A. Baratto
Greetings, We modified our db, host, and user tables (in mysql db) in order to have bigger db names, users... Just 16 characters is really not enough for us. Now the problem: Some of our users use myODBC to connect to their databases. And that driver does not accept db names with more than 16

Re: Problem making myodbc on Solaris 8

2001-12-04 Thread Matthew Dougherty
The same error occurs with 2.50.39. Has anyone successfully made MyODBC on Solaris8 using gcc 2.95?? Matt Dougherty Venu wrote: Hi, -Original Message- From: Matthew Dougherty [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 11:06 AM To: [EMAIL PROTECTED] Subject

MyODBC and Accents

2001-12-04 Thread webpp
I'm programmer of ASP, I'm initiating the use of the data base MySQL with ASP, but I noticed that driver MyOBDC 2.50.39 it correctly does not return the accents from the words. Somebody can help me? Thanks! Marcelo Busana --- WebDeveloper UNIDAVI

Re: Problem making myodbc on Solaris 8

2001-12-04 Thread Matthew Dougherty
. It may be that configure fails to succeed because Solaris 2.8 is not one of it's options? Matt Dougherty [EMAIL PROTECTED] Matthew Dougherty wrote: The same error occurs with 2.50.39. Has anyone successfully made MyODBC on Solaris8 using gcc 2.95?? Matt Dougherty Venu wrote: Hi

RE: Problem making myodbc on Solaris 8

2001-12-03 Thread Venu
Hi, -Original Message- From: Matthew Dougherty [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 11:06 AM To: [EMAIL PROTECTED] Subject: Problem making myodbc on Solaris 8 make fails with mksh: Fatal error in reader: = missing from replacement macro reference

RE: MyODBC Problem with SQL2000 - MySQL Data Transformation

2001-12-02 Thread Venu
Hi, -Original Message- From: Jack A. Fobel [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 01, 2001 3:22 PM To: MySQL List Subject: MyODBC Problem with SQL2000 - MySQL Data Transformation Hi Folks, I'm having a problem when I try to populate a MySQL database using DTS

MyODBC Problem with SQL2000 - MySQL Data Transformation

2001-12-01 Thread Jack A. Fobel
failing with this error code. I'm beginning to think it is the MyODBC driver. I connect to SQL2k with OLD DB and use MyODBC to connect to MySQL. Have any of you tried doing this yet? Just curious that maybe you have run into this before. Thanks, Jack [EMAIL PROTECTED

Problem making myodbc on Solaris 8]

2001-11-30 Thread Matthew Dougherty
make fails with mksh: Fatal error in reader: = missing from replacement macro reference Current working directory /opt/perlModules/MyODBC-2.50.37 I have ODBC working for SQL Server. If I do a make -V is leads me to a bad set of lines in Makefile: DEPS_MAGIC

MyODBC: DSN Creation

2001-11-26 Thread Kevin Smith
Hi All, I need to setup MyODBC DSN's for MySQL access. Does anyone know how to build a simple installer that will create User/System DSN's from a file? ie. like the odbc.inf file included with the MyODBC installer? Can odbcconf.exe be used to install a DSN? If so, what are the parameters

RE: MyODBC: DSN Creation

2001-11-26 Thread Venu
Hi Kevin, -Original Message- From: Kevin Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 9:25 AM To: [EMAIL PROTECTED] Subject: MyODBC: DSN Creation Hi All, I need to setup MyODBC DSN's for MySQL access. Does anyone know how to build a simple installer

Override date format in MyODBC

2001-11-24 Thread Andres Portillo
Hi All, Is there any way to modify the date format used by MyODBC when returning dates? By example, I have a field in the database with the value 2001-11-01 (this is Nov. 1st, 2001). When I read it in my VB program I get the next date 11/1/2001; this is because the computer date format

RE: MySQL with MyODBC Access

2001-11-22 Thread Adam Douglas
Hi I recently upgraded MyODBC as you stated on our terminal server and two PCs. Now I tried running the install.bat file but it didn't seem to work so I just looked at the batch file and did it all manually. I believe for some odd reason the variable %windir% wasn't working. Either way

RE: MySQL with MyODBC Access

2001-11-22 Thread Venu
Hi, -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 22, 2001 6:54 AM To: '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail) Subject: RE: MySQL with MyODBC Access Hi I recently upgraded MyODBC as you stated on our terminal

mysql+myodbc+coldfusion

2001-11-18 Thread berndt
Hi I am currently trying to get coldfusion, mysql, and myodbc to live happily together on a windows 2000 machine. However i keep getting a [TCX][Myodbc]Transactions are not enabled error. In the setup for the system dsn I have NOT disabled transactions. So whats up? any help would be really

RE: mysql+myodbc+coldfusion

2001-11-18 Thread Venu
Hi, -Original Message- From: berndt [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 8:49 PM To: [EMAIL PROTECTED] Subject: mysql+myodbc+coldfusion Hi I am currently trying to get coldfusion, mysql, and myodbc to live happily together on a windows 2000 machine

Help needed with MySql/MyODBC ColdFusion on Win2k

2001-11-14 Thread Markus Wollny
Hi! I am desperately trying to get the following combination to run: MySQL (Win32 3.23.44) on host_1.something.tld ColdFusion Enterprise 4.5.1 SP2 for Windows on host_2.something.tld MyODBC 2.50.39 for NT/2000/XP on host_2.something.tld The MySQL-DB ist hosting one database named TEST with one

myODBC error list?

2001-10-29 Thread Mitch Mooney
Any way of getting a native error,sqlstate,error number list ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

MySQL with MyODBC Access

2001-10-23 Thread Adam Douglas
I've recently setup MyODBC and MS Access to use a ODBC profile that is global to everyone. What I did was make a new user in MySQL and then create a MyODBC User DSN. I made the links to MySQL in Access using this profile. The problem I'm having is this, when you initially go into MS

RE: MySQL with MyODBC Access

2001-10-23 Thread Venu
Hi -Original Message- From: Adam Douglas [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 12:55 PM To: 'David Turner'; '[EMAIL PROTECTED]'; Mysql@Lists. Mysql. Com (E-mail); '[EMAIL PROTECTED]' Subject: MySQL with MyODBC Access I've recently setup MyODBC

DSN-Less connections using MyODBC?

2001-10-05 Thread Sylvain Hamel
Anyone ever tried a MySQL dsn-less connection (I am working in Borland C++ Builder)? I can do it with a dsn but can't seem to make connection in dsn less. - Before posting, please check: http://www.mysql.com/manual.php

RE: DSN-Less connections using MyODBC?

2001-10-05 Thread Venu
Hi !!! -Original Message- From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 1:36 PM To: MySQL Mailing list Subject: DSN-Less connections using MyODBC? Anyone ever tried a MySQL dsn-less connection (I am working in Borland C++ Builder)? I can do

Re: DSN-Less connections using MyODBC?

2001-10-05 Thread Sylvain Hamel
PROTECTED]; MySQL Mailing list [EMAIL PROTECTED] Sent: Friday, October 05, 2001 5:07 PM Subject: RE: DSN-Less connections using MyODBC? Hi !!! -Original Message- From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 1:36 PM To: MySQL Mailing list Subject: DSN

RE: DSN-Less connections using MyODBC?

2001-10-05 Thread Venu
Hi !!! -Original Message- From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 2:26 PM To: MySQL Mailing list Subject: Re: DSN-Less connections using MyODBC? Thx for the quick response... Here's my connection parameters. I always get invalid parameter

Re: DSN-Less connections using MyODBC?

2001-10-05 Thread Sylvain Hamel
Venu. Syl - Original Message - From: Venu [EMAIL PROTECTED] To: Sylvain Hamel [EMAIL PROTECTED]; MySQL Mailing list [EMAIL PROTECTED] Sent: Friday, October 05, 2001 6:12 PM Subject: RE: DSN-Less connections using MyODBC? Hi !!! -Original Message- From: Sylvain Hamel [mailto

RE: DSN-Less connections using MyODBC?

2001-10-05 Thread Venu
Hi ! -Original Message- From: Sylvain Hamel [mailto:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 5:34 PM To: [EMAIL PROTECTED]; MySQL Mailing list Subject: Re: DSN-Less connections using MyODBC? Hi Venu, It doesn't depend upon OPTION value. Can you change the following

confirmation of transferred records from myodbc

2001-10-01 Thread melissa allman
Hi, I am working on a project that involves using a form to populate a MYSQL table. I then need to transfer these records to an Access database. I want to have a flag on the MYSQL table to indicate that the record was successfully sent to Access. It could be an on/off or Y/N value. I am trying

Access as frontend with MyODBC

2001-09-26 Thread Ann Myhre
Hi group I don't know if my problem is Microsoft or MySQL so i try here first. I have installed MySQL and MyODBC on the same machine as I have Access. I would like to connect to MySQL using Access as frontend, but when I have done the whole procedure with ODBC, I get a message, saying

MyODBC vs. iODBC

2001-09-25 Thread Adam Douglas
Is there any advantage of using MyODBC vs. iODBC with MySQL as the backend and M$ Access as the front end? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

MyODBC question

2001-09-18 Thread Valentin Kulikov
I have a problem with MyODBC trying to connect to MySQL from Access 2000 on Windows 2000 pro via dialup connection. On my work machine everything is OK, I'm running WindowsNT 4.0, Access 2000 and have a permanent Internet connection. Connection to MySQL situated at some Internet provider server

Re: MyODBC question

2001-09-18 Thread Adams, Bill TQO
Valentin Kulikov wrote: while:I have set 'myname' as a user name. Somebody (MyODBC? Windows2000?) added a suffix '@mydialup-provider.com' to my db user name. Or maybe a problem is in something else and a diagnostic is incorrect? Unless you connect to MySQL via a unix socket, the hostname

MyODBC properties window / VB data environment / ADODB

2001-09-18 Thread Mikko Lampinen
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

RE: MyODBC properties window / VB data environment / ADODB

2001-09-18 Thread Venu
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 make

MySQL/MyODBC and IMail

2001-09-13 Thread A. Clausen
Has anyone had any experience using Mysql via MyODBC with Ipswitch's IMail mail server? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: MyODBC, DBUG and multi-threaded clients

2001-09-11 Thread Peter Duffy
Hi Monty, Michael Widenius wrote: Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Peter Duffy writes: Hi Sinisa, My problems are within the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side

Re: MyODBC, DBUG and multi-threaded clients

2001-09-10 Thread Peter Duffy
Hi Monty, Michael Widenius wrote: Hi! I have a small comment to this. Note that you will get crashes in the DBUG package if you call any MySQL function inside a thread that hasn't called mysql_init() or mysql_connect(). If you want to use MySQL functions in threads that doesn't

MyODBC Recordset problem.

2001-09-07 Thread Clark, John
Sorry if this e-mail is rather long but I want to give all code I am using as to make sure that everyone has all the information they need. Machine info: MySQL for Win 2000 IIS5 The Table: CREATE TABLE Players ( pid INT AUTO_INCREMENT NOT NULL, RealFullName CHAR(70) NOT NULL, RealAge INT NOT

Re: MyODBC, DBUG and multi-threaded clients

2001-09-06 Thread Michael Widenius
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Peter Duffy writes: Hi Sinisa, My problems are within the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side of the socket.) Both the mysqlclient and MyODBC

Re: MyODBC, DBUG and multi-threaded clients

2001-09-06 Thread Michael Widenius
objective is to fix my application, which, to repeat again, is coredumping during calls to DBUG functions within the mysqlclient and MyODBC libraries. Regards, Peter Sinisa Exactly what I mean. There are several multithreaded clients out there Sinisa all using libmysqlclient and some

Re: MyODBC, DBUG and multi-threaded clients

2001-09-05 Thread Sinisa Milivojevic
Peter Duffy writes: Hi Sinisa, My problems are within the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side of the socket.) Both the mysqlclient and MyODBC libraries do (or in my case did) contain calls to the DBUG functions

Re: MyODBC, DBUG and multi-threaded clients

2001-09-04 Thread Sinisa Milivojevic
Peter Duffy writes: Hi Sinisa, Do you know of any which are specifically accessed by multi-threaded client applications via ODBC? (If so, I'd really like to know, so that I can try to get hold of copies of the client applications to test in my own environment.) As you very well

Re: MyODBC, DBUG and multi-threaded clients

2001-09-04 Thread Peter Duffy
the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side of the socket.) Both the mysqlclient and MyODBC libraries do (or in my case did) contain calls to the DBUG functions. Obviously, given the fact that the libraries are being called

MyODBC, DBUG and multi-threaded clients

2001-09-03 Thread Peter Duffy
-threaded application (based on OpenLDAP) which queries MySQL via libiodbc and MyODBC (issuing many searches and updates in parallel.) It had been running well and stably, 24 hours a day, for over six months. Then, because of a security vulnerability, I upgraded to the latest version of OpenLDAP

Re: MyODBC, DBUG and multi-threaded clients

2001-09-03 Thread Sinisa Milivojevic
the business 8)) OpenLDAP: originally 2.0.7, then 2.0.11. mysql: 3.23.38 MyODBC: 2.50.33 libiodbc: 3.0.5 mpatrol: 1.4.5 (http://www.cbmamiga.demon.co.uk/mpatrol) Hi! As an example, mysql server is a multi-threaded program and when compile --with-debug it uses DBUG function

Re: MyODBC, DBUG and multi-threaded clients

2001-09-03 Thread Peter Duffy
Hi Sinisa, Sinisa Milivojevic wrote: As an example, mysql server is a multi-threaded program and when compile --with-debug it uses DBUG function. I know. As I said, one of my main problems is that MyODBC does not have a --without-debug option. There are literally thousands and thousands

RE: MyODBC between MySQL-Server (Linux) and Linux-Client

2001-09-03 Thread Venu
Hi !! )-Original Message- )From: [EMAIL PROTECTED] )[mailto:[EMAIL PROTECTED]]On Behalf Of Peter Harvey )Sent: Saturday, September 01, 2001 8:13 AM )To: [EMAIL PROTECTED] )Subject: Re: MyODBC between MySQL-Server (Linux) and Linux-Client ) ) ) ) root@workstation3:/home/manuel isql -v

MyODBC between MySQL-Server (Linux) and Linux-Client

2001-09-01 Thread Manuel Ohnemus
I'm new to MySQL and now a problem occured: I'm running a mysql-server on linux with a database test. No I want to connect to this via MyODBC from Windows and Linux clients. So I installed /etc/odbc.ini on the server: [MySQLtest] Description = MySQL fuer DB 'test' auf localhost Driver = MySQL

Re: MyODBC between MySQL-Server (Linux) and Linux-Client

2001-09-01 Thread Peter Harvey
root@workstation3:/home/manuel isql -v MySQLtest dbuser [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [ISQL]ERROR: Could not SQLConnect root@workstation3:/home/manuel It seems to try to connect to a local mysql-server, wich

[unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket

2001-09-01 Thread Peter Harvey
root@workstation3:/home/manuel isql -v MySQLtest dbuser [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [ISQL]ERROR: Could not SQLConnect root@workstation3:/home/manuel It seems to try to connect to a local mysql-server, wich

RE: myODBC?

2001-08-25 Thread Wen Tien
I'm confused about: Do I 1) install both iODBC and myODBC on the Irix system? or 2) install iODBC on the Irix one and myODBC on that Linux machine where the mySQL db physically located? Thanks! Wen -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 9:33

RE: myODBC?

2001-08-25 Thread Venu
Hi !! )-Original Message- )From: Wen Tien [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 1:58 PM )To: [EMAIL PROTECTED]; Werner Stürenburg )Cc: [EMAIL PROTECTED] )Subject: RE: myODBC? ) ) )Hi, maybe I didn't phrase my question correctly. I'm using a SGI machine )running Irix

RE: myODBC?

2001-08-25 Thread Venu
Hi !!! )-Original Message- )From: Werner Stürenburg [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 5:59 AM )To: Wen Tien )Cc: [EMAIL PROTECTED] )Subject: Re: myODBC? ) ) )In my understanding, myODBC is a middleware for programs which )don't know how to deal directly with mySQL

myODBC?

2001-08-24 Thread Wen Tien
Hi, I am a newbie that has a question about what exactly is myODBC (for Unix) doing. Is myODBC, 1) a wrapper over the mySQL database to make it conform to the ODBC interface or 2) a plug-in driver that goes with a manager program to allow the access of mySQL db? I am using an Irix

Re: myODBC?

2001-08-24 Thread Werner Stürenburg
In my understanding, myODBC is a middleware for programs which don't know how to deal directly with mySQL. So if you use perl or php, you won't ever use ODBC, as this only slows things down, obviously. ODBC is kind of a workaround in my understanding. Please correct me, if I'm wrong. Wen Tien

myODBC on Irix 6.5 follow-up

2001-08-22 Thread Wen Tien
Hi all, I have now managed to execute the configure script without any errors. However, the Makefile generated still contains errors? Again, has anyone ever managed to build and install myODBC under Irix? Any thoughts is appreciated... thanks! bypass spam filter: sql, mySQL, table

myODBC on Irix 6.5

2001-08-21 Thread Wen Tien
Hi all, I downloaded the latest Unix source of myODBC drivers but the configure script failed under Irix 6.5. (Unexpected end of file) I looked at some web resources and it seems that many developers also have similar difficulties configuring/compiling myODBC for Irix. I was wondering

MyODBC, MySQL, and a little bit of perl

2001-08-18 Thread John Meyer
Here's the error message that I am getting: [911] [2] [0] [Microsoft][ODBC Driver Manager] Invalid string or buffer length And here is the code my $sqlcommand = INSERT INTO EMAILS(PERSONALITY_ID,EMAIL_HEADER,EMAIL_EMAIL,EMAIL_FROM,EMAIL_SUBJECT) VALUES( . $personalid . ,\ . $headerlines

Re: MyODBC, MySQL, and a little bit of perl

2001-08-18 Thread s. keeling
On Sat, Aug 18, 2001 at 04:25:50PM -0700, John Meyer wrote: Here's the error message that I am getting: [911] [2] [0] [Microsoft][ODBC Driver Manager] Invalid string or buffer length And here is the code my $sqlcommand = INSERT INTO

RE: MyOdbc to unix

2001-08-07 Thread SRIVATSAN RAGHURAMAN
Hi Venu, I want some sample codes for ODBC connection to MySQL. Where can I get it? R.Srivatsan [EMAIL PROTECTED] - Before posting, please

RE: MyOdbc to unix

2001-08-07 Thread Sinisa Milivojevic
SRIVATSAN RAGHURAMAN writes: Hi Venu, I want some sample codes for ODBC connection to MySQL. Where can I get it? R.Srivatsan [EMAIL PROTECTED] To connect from Unix or from Windows ?? -- Regards, __

RE: MyOdbc to unix

2001-08-07 Thread SRIVATSAN RAGHURAMAN
Hi Sinisa, Sorry I should have mentioned this earlier. From Windows. R.Srivatsan [EMAIL PROTECTED] ___ Sinisa Milivojevic [EMAIL PROTECTED] Wrote---

RE: MyOdbc to unix

2001-08-07 Thread Venu
Hi ! -Original Message- From: SRIVATSAN RAGHURAMAN [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 6:13 PM To: [EMAIL PROTECTED] Subject: RE: MyOdbc to unix Hi Sinisa, Sorry I should have mentioned this earlier. From Windows

Re: floor/ceiling with myodbc

2001-08-04 Thread Sinisa Milivojevic
Kevin X Lin writes: Hi there, I'm running into problems with functions floor/ceiling when I use Visual Basic to talk to mySQL through myODBC. My code looks like this: sSQL = select floor(3.2) Set rs = MySQL_conn.Execute(sSQL) I got rs.eof = true after execution of the query. However

floor/ceiling with myodbc

2001-08-03 Thread Kevin X Lin
Hi there, I'm running into problems with functions floor/ceiling when I use Visual Basic to talk to mySQL through myODBC. My code looks like this: sSQL = select floor(3.2) Set rs = MySQL_conn.Execute(sSQL) I got rs.eof = true after execution of the query. However the following codes works fine

Re: myodbc from windoze to unix

2001-08-03 Thread Stefan Hinz
Dear Glyndower, All remote db connections are blocked so This says it! You are not allowed to connect to the database server from anywhere else but from localhost. Try: GRANT ALL ON *.* TO me_as_odbc_user@% IDENTIFIED BY my_password This will grant access to me_as_odbc_user from everywhere

myodbc from windoze to unix

2001-08-01 Thread Glyndower
This is the email I recieved from tech support of the host i'm using, in reference to using MyOdbcand MyAccess to connect from Access on a windoze machine to MySql on a unix machine. All remote db connections are blocked so phpmyadmin or using ssh to connection (secure telnet) is the two

RE: MyOdbc to unix

2001-07-31 Thread Glyndower
should be able to figure the rest. Can somebody help me answer this? I know the user pass dbname etc, but i'm unsure as to the format that MyOdbc uses to send it along, is it telnet, php, cgi? database - Before posting, please

RE: MyOdbc to unix

2001-07-31 Thread Venu A
Hi ! -Original Message- From: Glyndower [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 9:49 AM To: [EMAIL PROTECTED] Subject: RE: MyOdbc to unix Re my previous message about tech support and access from windoze to unix. follows is the response i recieved from them

RE: MyOdbc to unix

2001-07-31 Thread Venu
Hi ! -Original Message- From: Glyndower [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 9:49 AM To: [EMAIL PROTECTED] Subject: RE: MyOdbc to unix Re my previous message about tech support and access from windoze to unix. follows is the response i recieved from them

strange myodbc problem

2001-07-30 Thread Conor McTernan
Hey there, Sorry for posting to this list, but I'm not so sure it's a myodbc problem exclusively. I am currently trying to get a mysql database to work with lotus approach. The plan is to port a current .dbf database over to mysql, and so far I have not had many problems. Until now. I am

RE: Help with myODBC

2001-07-27 Thread Venu Anuganti
Hi Nikhil Is there any chance for you to provide the ODBC trace generated by ODBC DM / MyODBC ? Thanks in advance Venu -Original Message- From: Nikhil Goyal [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 26, 2001 11:33 AM To: [EMAIL PROTECTED] Subject: Help with myODBC Hello

Re: Help with myODBC

2001-07-27 Thread Grigory Bakunov
Date |Thu, 26 Jul 2001 14:32:48 -0400 From |Nikhil Goyal [EMAIL PROTECTED] Hello! NG Hello people, NG I've a mysql database which is quite large and I needed to create a backup NG for it, which I can use offline in MS Access or such. I've tried using NG MyODBC, but one strange problem has come

Problem with MyODBC

2001-07-27 Thread asfar . sayeed
Hi , I'm trying to access database on MySQL server which is on a Unix box from a windows system through odbc. I'm using MyODBC for this purpose. When ever i connect i get the error message access denied for the user. I have inserted the user in the db, user and host tables in mysql database

MyOdbc to unix

2001-07-27 Thread idesign
Ok, I can't seem to find the answer to this which leads to believe its obvious, but anyway. MyOdbc can be used to connect an Access database on a Windoze machine to a MySql server on a unix machine, correct? The reason I;m asking is that tech support went , huh? So now I'm questioning my

RE: MyOdbc to unix

2001-07-27 Thread Venu A
Hi ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 11:54 AM To: [EMAIL PROTECTED] Subject: MyOdbc to unix Ok, I can't seem to find the answer to this which leads to believe its obvious, but anyway. MyOdbc can be used to connect

RE: MYODBC DSN creation

2001-07-23 Thread Martin Jeremic
/ -Original Message- From: David Rickerl [mailto:[EMAIL PROTECTED]] Sent: nedelja, 22. jul 2001 23:57 To: [EMAIL PROTECTED] Subject: MYODBC DSN creation Have successfully installed MYODBC, driver shows up in Windows Control Panel, and when I try to add a new User DSN the setup screen appears. I

MYODBC DSN creation

2001-07-22 Thread David Rickerl
Have successfully installed MYODBC, driver shows up in Windows Control Panel, and when I try to add a new User DSN the setup screen appears. I add the info as outlined in the Mysql manual for 3.23.39 and everything appears ok, but I can't find the DSN when I want to connect to Mysql. Did a file

Re: MYODBC DSN creation

2001-07-22 Thread Dennis Salguero
- Original Message - From: David Rickerl [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, July 22, 2001 2:57 PM Subject: MYODBC DSN creation Have successfully installed MYODBC, driver shows up in Windows Control Panel, I assume that you mean in the Data Sources window/utility

MyODBC installation

2001-07-20 Thread shane
Hi, i've installed mysql on a win2000 os and downloaded myodbc zip file and went through the process of setting it up. it says sucessful installation but the environment tab of my mysqladmin says that myodbc is not found. what do i need to do? thks shane

Fw: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

2001-07-19 Thread Venu Anuganti
___/ www.mysql.com - Original Message - From: Luc Lalancette [EMAIL PROTECTED] To: Venu Anuganti [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 10:04 PM Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Thanks again... It seems that I

RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message

2001-07-19 Thread shane
Hi, the driver which i am using is type IV. do i still need to install myodbc? thks -Original Message- From: Venu Anuganti [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 2:04 PM To: shane Cc: [EMAIL PROTECTED] Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied

Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

2001-07-19 Thread Venu Anuganti
Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Hi, the driver which i am using is type IV. do i still need to install myodbc? thks -Original Message- From: Venu Anuganti [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001

java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message

2001-07-18 Thread Luc Lalancette
I am starting using mysql and I made a java SimpleQuery servlet that is suppose to retreive one row from the database. However, when I try to connect I get that message from the Subject. I know I'm suppose to pass the password but can't seem to find a way of doing it. I was wondering if the

Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message

2001-07-18 Thread tj marlin
the method signature for getConnection is: public static synchronized Connection getConnection(String url, String user, String password) throws SQLException try PURE JSP Java Server Pages by James Goodwill from Sams. a nice book. has some coding errors. At 04:02 PM 7/18/01 -0600, you

Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

2001-07-18 Thread Venu Anuganti
] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 3:02 PM Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message I am starting using mysql and I made a java SimpleQuery servlet that is suppose to retreive one row from the database. However, when I try

Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message

2001-07-18 Thread Venu Anuganti
Hi Shane To connect to MySQL using JDBC Driver, it depends up on the type of JDBC driver you are using. If you are using a JDBC-ODBC Bridge (TYPE 1 DRIVER) then you need MyODBC installed on the system and configured properly as explained in the earlier mail in the mysql list. Here is the link

Re: MyODBC 2.50.37 and Access 2000

2001-07-14 Thread Sinisa Milivojevic
Venu Anuganti writes: Hi Kevin Can you please send us the ODBC trace generated by MyODBC as well as ODBC DM ? Thank you Venu Anuganti Hi! This was simply a case that Access table did not have auto-increment and timestamp columns in it. Unfortunately, there are some restrictions

MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Kevin Smith
Hi All, I've installed MySQL 3.23.39 on my Windows 2000 Pro Server and I am currently developing a database using Access 2000 as a front-end to MySQL using MyODBC 2.50.37. I have all my MySQL tables linked as ODBC tables in Access. When I am inputting data into an Access Form and then save

Re: MyODBC 2.50.37 and Access 2000

2001-07-13 Thread Kevin Smith
Hi, I didn't get a reply to this, so I guess no one knows, or, it's on the wrong forum. Can any set me straight on this? Cheers, Kevin - Original Message - From: Kevin Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 13, 2001 10:24 AM Subject: MyODBC 2.50.37

<    1   2   3   4   5   6   >