MyODBC Question

2002-04-30 Thread David M. Peak
I have a question about MyODBC and the results of SQLGetTypeInfo from a table with a column of type TEXT. The results show that the column is of type VARCHAR with a length of 255. Is there a way to show the true datatype? The MySQL that I'm running is 3.23.36. SQL question..

RE: MyODBC Question

2002-04-30 Thread Venu
Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 12:35 PM To: [EMAIL PROTECTED] Subject: MyODBC Question I have a question about MyODBC and the results of SQLGetTypeInfo from a table with a column of type TEXT

Re: MyODBC Question

2002-04-30 Thread David M. Peak
:17 PM Subject: RE: MyODBC Question Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 12:35 PM To: [EMAIL PROTECTED] Subject: MyODBC Question I have a question about MyODBC and the results of SQLGetTypeInfo from a table

RE: MyODBC Question

2002-04-30 Thread Venu
Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:44 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MyODBC Question So what is the best way to store information in a MySQL database through MyODBC

Re: MyODBC Question

2002-04-30 Thread David M. Peak
greater than 255? - Original Message - From: Venu [EMAIL PROTECTED] To: 'David M. Peak' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 2:45 PM Subject: RE: MyODBC Question Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday

RE: MyODBC Question

2002-04-30 Thread Venu
PROTECTED] Subject: Re: MyODBC Question I don't mean to beat a dead horse here, but when the backend checks the length of the datatype for the columns to prepare the statment, the TEXT column comes back as length of 255 so my 1,500 char string gets cut off. Is there a datatype

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 of

Re: myODBC question

2001-02-02 Thread Pat Sherrill
ubject: Re: myODBC question Speaking as one who tried working with such a connection, FORGET IT. While entering data, I might get all or half a record entered when the message arrives telling me the information cannot be posted, because another user was editing that record (which I could tell w

myODBC question

2001-02-01 Thread \(Mr\) Pekka Gaiser
Hi there, A DB newbie question - can I use MS Access for remote mySQL databases using myODBC?? Thanks.

Re: myODBC question

2001-02-01 Thread John Jensen
Speaking as one who tried working with such a connection, FORGET IT. While entering data, I might get all or half a record entered when the message arrives telling me the information cannot be posted, because another user was editing that record (which I could tell was simply NOT the case),