myODBC connect problems

2004-06-08 Thread Annie Law
Hi, I would appreciate help on the following. I have installed myODBC 3.51 on my Windows 2000 computer. I am trying to connect mysql database on a linux server. I configured the ODBC data source adminstrator from the administrative tools. After trying to add a new data source and entering all

Re: Initiate perl script in linux from a Windows VBA program

2004-06-07 Thread Annie Law
Thanks for the response. Does this mean that I would not use perl and only program in VBA? If I do need perl does it have to be installed on the Windows side? Where can I get some examples with ODBC in VBA? thanks. Mike Hillyer [EMAIL PROTECTED] wrote: Annie Law wrote: Hi,I would

Initiate perl script in linux from a Windows VBA program

2004-06-02 Thread Annie Law
Hi,I would appreciate help with the following. I would like to be ableto initiate a perl script that is residing on a linux server from anExcel workbook. I am working on the Excel workbook in Windows. Iwould appreciate any pointers, sample code for accomplishing this inVBA or some other

parsing a column

2004-03-25 Thread Annie Law
Hi, I would appreciate help on the following. I have a column in a table. Each entry in the column can have 0,1,2,3... maybe four entries in it. I would like to parse the column and grab each of the entries and feed it into another select statement. This entry that needs to be parsed would be

Strings and variables in select statements

2004-03-23 Thread Annie Law
Hi, I would appreciate help with the following. I have a table where each of the values in a column consists of a combination of letters and numbers followed by a decimal then a single digit. Examples of the two types of entries that could be found in this column(accession_num) are: BQ877252.1

Application using mysql, perl, Excel

2004-01-28 Thread Annie Law
Hi, I would appreciate help on the following. I would like to create a small application that would involve Excel XP on Windows 2000, and perl and mysql on RedHat linux 9.0 The front end of the application will be Excel since it has a lot of useful functions. Columns from the Excel sheet

Re: Starting up MySQL :(

2004-01-22 Thread Annie Law
the mysql processes? thanks very much Annie Law wrote: Hi, I would appreciate any help on the following. I have searched the mailing list for information But have not come up with a solution for my situation which has been frustrating. I think I need some things need to be clarified