MYSQL :: Connection String From Windows, Please Help

Connection String
If i'm right, all MySql databases are stored in some subfolders under InstallDir/Data...
This folder can be set using some configuration parameters like 'Datadir' or something like this.

Well, i want to connect to some database stored in some folder outside this one. For example i want to manage one database in drive D:myDatadata1 and a second one stored in drive F:somedatamyDatadata123.

Using Interbase i write my ConnectionString in this way:
'..... DatabaseName=192.168.1.60:C:staffibITI.gdb....'
In MySql this does not work|

Is it possible to connect to a database outside the 'Datadir' settings?

Connection String
I am using the following code in Access 2k to establich a connection to a
MYSQL database

Dim conn As ADODB.Connection

Set conn = New ADODB.Connection

conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};DESC=;USER=" &
myUsername_
& ";DATABASE=" & mySQLDatabase_
& ";SERVER=" & myServer_
& ";PASSWORD=" & myPassword_
& ";PORT=;OPTION=;STMT=;" ';TABLE=" & myTable
conn.Open

I get a Catostrophic failure error on the conn.Open line.

Connection String
Why this is not working
I'm putting this connection string with the follwing batch file:
mysql --user=root --password=mypassword < batchfile.txt
It never executes the batchfile. How do I have to do it

Connection String
i need to write the connection string in c# for .Net 1.1 with Mysql.

i am new to MySql,can somebody tell me how to do it

Connection String From Db.asp To MySQL DB
I have a project that was originally developed to run on an access db due to it's lack of traffic, now I trying have the same project use MySQL as it's db in anticipation of more traffic.

Below is the connection string for my Dev (local) site.

ConString = "Driver={MySQL ODBC 3.51 Driver}; Server=216.251.43.11; Database=c:/program files/mysql/MySQL Server 4.1/cdi_cdnsys_com; UID=****; PWD=****; Option=3"

DSN_Less Connection String
I am trying to get a dsn-less connection string to work with MySQL version 4.0.12/ODBC 3.51. What I have is:

driver={MySQL};database=doitquick;server=127.0.0.1;uid=username;pwd=password;option=16386;

Anyone shed some light on this?

Ado Connection String Error Through Vb
I'm using mysql-5.0.1-alpha-snapshot-win & VB 6.0

  I'm having trouble connecting to the database server over a lan.

  When I use the following connection string from the server it works fine. -

adoCon.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=MyDatabase;uid=root;"

  When I use the the following connection string from another computer I get this error -

adoCon.ConnectionString = "Driver={MySQL ODBC 3.51 Driver};SERVER=192.168.0.2;DATABASE=MyDatabase;uid=Tom;pwd=X12;"

Run-time error '-2147467259(80004005)'

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '192.168.0.2' (10060)

Also when I try the last connection from the database server and in vb (not compiled) I get the following error -

Run-time error '-2147467259(80004005)'

[MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server; consider upgrading MySQL client

In MySQL CC under users -
Username = Tom
Host = %
Password=X12

Global privileges and MyDatabase are checked with All Privileges

Ado Connection String For Tcpip Port
Currently I connect to MySql using the following vbscript:

set conn = createobject("ADODB.Connection")
conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_
& "DATABASE=test;"_
& "UID=venu;PWD=venu;OPTION=3"
conn.open()

I would like to change my connection string so that I connect using
TCP/IP and I would like to specify port 3306 inside the string. I
know how to do this with MS SqlServer, but does someone know how to do
this with MySQL?

Connection String Authentication To My Server
I'm having a tough time figuring out the proper connection string to connect to my existing database.

Using:
* MySQL server 4.0 on a remote Linux Server.
* Developing in VS 2005 (VB) on a PC that is apart of our corporate MS domain.
* Downloaded and installed Connector/Net 2.0

Problem:
I'm using the connection string: ("server={0}; user id={1}; password={2}; database=test; pooling=false", server.Text, userid.Text, password.Text)

When executed with userid="sam" the error message that is returned is "Access denied for user: "sam@<mypc>.<corporatedomain>.com"

When executed with the userid="sam@<remotehost> the error message returned is "Access denied for user "sam@<remotehost>@<mypc>.<corporatedomain>.com". No matter what I do, the connector keeps appending my current domain id to the end of the user string.

"sam" is a authorized user for the MySQL on the remote linux host (been using it for years).

Server 2003 Connection String
I am running an sql script as part of an installer and it works fine on an XP machine, however when i run it on Windows Server 2003 it fails when it tries to open a connection.The connection string i am using is:

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=mysql;UID=root;PWD=;OPTION=16427"

My question is, does it need to changed for Server 2003?

MYSQL OleDb Connection String
I have this connection string
"Provider=MySQLProv; Location=localhost; Data Source=test_db;User ID=testuser;Password=testpass";
It works fine on the local host. However I need to connect to a data source on a different computer so I put in the host name for location and Im supposed to be able to use PORT=my_port_num for the port but whenver i use this string
"Provider=MySQLProv; Location=localhost; Data Source=test_db;User ID=testuser;Password=testpass; Port = 9999"; it comes up with a dsn box to fill in the port.

Connection Problem !!! Windows To Linux
I wrote a program application for windows which can add and delete data
from this application, it working fine with my own MySQL install on the
same windows OS.. Now I try to change the connection this dayabase to
the server whihc runnign under linux, and create the same database, same
user and password. But when I connect the error message said:
[MySQL][ODBC 3.51 Driver] Host'219.95.155.119' is not allowed to
connect to this MYSQL Server.

But form the database, I added the host "%", means hsould be allow any
host... anyone can help me on this? the application I wrote will be
using with dynamic IP everytime user dial-up to the internet connect.

MYSql Windows 2003 - Connection Error
I installed MYSql/PHP/Apache on my Windows 2003 server. I created my database, added users and granted FULL perrmissions to all my uses but when i go to connect i get:

There seems to be a problem with the MySQL server, sorry for the inconvenience.

So I start the MYSql server by the command:
mysqld --skip-grant-tables

and I can get in fine from the webside but once i get it out of this mode i can't hit it from the webside BUT i can hit it with MYSql GUI tools to setup users/db/grants/etc.

Making Connection To Mysql From A C Program On Windows
can any one please tell me "how to make a conncetion to mysql database
from a C program on windows " .
Please help me by giving possible code for making a
conncection,selecting data etc.
i.e. what library files i need to include,what are the functions needed
to be called.

Format Function In SQL String To Return From Numeric Field In Table To String
How would i form a format function in SQL string to return from numeric field in table to string:

1 --> '001'
5 --> '005'
57 --> '057'
125 --> '125'

How Do You Replace A String With Another String
How do I write a query in myPHP admin to search through a particular field in a particular table for a string and replace it with another string? The string is only a part of the value of that field. For example, how would I change "Hello there" to "Hi there"?

Changes Made In One Connection Does Not Reveal In Another Connection At Once.
I use many connection and the same as many threads in my server app to gain performance on a multicpu machine.

Firstlly i call "set autocommit=0" and wrap every statements with "start transaction " and "commit". i use mysql_stmt_execute for every statement rather than mysql_real_execute except those that can't be prepared. The version of mysql is 4.1.11 under Debian linux.

In one connection of one THREAD i insert a row into a table. After i got the sucess code and the last insert id, i then do a "select" from another connection in another THREAD with the "last insert id" return by the previous insert . I expect the select can fetch the row that i have just insert , but some time it does and some time it doesn't.

is there any funtion like "mysql_....flush...cache.." to make the changes from one connection to be reveal to the global at once?

SQL String
I have VB6 app connected to a MySQL 4.1 database.
I am using ADO and myODBC to connect to the database on a webhost, and successfully return data to my forms.
My problem is that I need an SQL string to call records where the date is equal to today.

The string I've used is like "SELECT * FROM tblCalls WHERE CallDate='" & Format(Date,"yy-mm-dd")'". When I populate my ADO control, with the SQL as its recordsource, I get all records back, i.e. it won't filter by today's date.
Can anyone tell me how I need to construct my SQL string to apply the filter I want?
Apologies if there's already a post about this, but I've tried to search this forum, and the MySQL forum with no luck.

Get String Of Certain Fields
Hi all! please bear with me as im not familiar with mysql... just can set up a database but thats about it.
I have a table for clothing, and for each item i have an 'enum' field for every colour available where i choose a Ɔ' or Ƈ' depending whether that colour is available for that item or not. There are many other fields in this table but the colours are the only ones im concerned with at the moment.
I'm just after how to get the string with the colours, that i can then explode onto my page. Once they are set out in a list im after adding a checked="checked" option to the radio button of the 1st item displayed.
Im not sure whether i'm making any sense whatsoever so you can view the original thread i made in the php forum that reffered me to here. Sorry if this is pretty vague let me know if u want me to elaborate on anything

String As Primary Key
www.site.com/abc
www.site.com/xyzzzz

"abc" and "xyzzzz" are names of products, and are unique.

This would mean that in my database design, I store the product ID as a string (primary key). Does this impact performance speed at all, vs. if I stored the product IDs separately as a number?

I've thought of storing them as numbers, but then it wouldn't be as easy to remember. Users would have to type:

www.site.com/3235389

to get to product "abc". However nobody would remember a number. It would be easier for them to remember "abc".

What are your thoughts? Storing a string (can be up to a few hundred characters long) as the primary key, is it ok for performance?

Which String Type Should I Use?
I am currently using a Text string type to store some webpage data. The webpage is not that large.

What is the maximum number of characters a Text string type can hold?

String And Memo
I am a delphi programmer.

I have created (manualy on the server) one table with this structur:

id - int auto increment primary key
name - varchar(50)
nipc - varchar(9)
....

After creating the table i tried to access to the table with my delphi application but it gets the fields varchar like memo.

But if i insert values with the line

insert into teste(nome,nipc) values('Marco','teste');

it interpretes the fiels like string, what is the problem?

I access the tables via odbc, with delphi 7, Mysql 4.1.

Searching A String
1. I have a list of states in a single variable, as such.

AZ CA NY NM OR

2. What is the best method to pull a match on a single state?

WHERE variable is LIKE value?

In JavaScript, I would use the indexOf like so.

if(var.indexOf(value) > -1){
THEN TRUE
}

Is there something that matchs the JavaScript IndexOf ?

TYIA!

String Matching
If i have the following table:

--------------
| ID | Color |
--------------
| 1 | Blue |
| 2 | Red |
--------------

If I have a HTML form and the user inputs in a textfield "The sky is usually blue in color".

String Comparison
I need to search a table for certain area codes. Because the office does not have a uniform way of entering phone numbers into the database, some are entered as (555)555-5555 and others as 555-555-5555.

I have a select statement in which I want to return phone numbers beginning with a certain area code indepent of how the phone number was entered.
I've tried the following:

CODESELECT customers_telephone FROM customers WHERE customers_groups_id = 3 AND customers_telephone
like '(310)%' OR customers_telephone
like '310%'

String Parsing
I am having a problem making an online form and I am fairly new to php and MySQL. I have an online form that errors when either single quotes are used. My code looks like this:

"INSERT INTO ".$_POST['gender']. " SET " .
"Name='".$_POST['school']."', "....

So if for example the name of the school were O'Connor, there would be an error with the parsing. Is there a way to fix this issue.

String Comparison
I would like to search a column of strings for matches to a given prefix. Is there a way to use existing string comparison functions to do this? Specifically I'm looking for the number of leading characters identical to my (variable) search string:

Example: looking for matches to prefix "Robb"

SELECT names, some_functions(names, "Robb") AS m FROM etc, etc, etc...

| names | m |

| Roger | 2 |
| Robert | 3 |
| Roseanne | 2 |
| Cary | 0 |
| Randy | 1 |
| Robby | 4 |
| Allison | 0 |

Return the highest value of m for which LEFT(names,m)=LEFT("Robb",m).

I've been reading through the section on string comparison function, but can't find anything suitable. But perhaps there is some combination of funtions you could use?

String Comparison
When i update a table i am carrying out a check to see if that entry already exists. This is ok when it is the same case but when it is different it allows it.

select
count( entityid ) as COUNTENTITIES
from
entities
where
code = '%1%'

I have tried LIKE but that didn't work either

What i am after is if there is a code 'c1' in database and someone tries 'C1' i want that to fail because 'c1' is already there. Is this possible?

Binary String?
In what case, I could use binary string?

String Comparisons
can someone please tell me where this statement evaluates true

select 'C:Documents and SettingsJudyVMy DocumentsDSC02062.JPG'='C:Documents and SettingsJudyVMy DocumentsDSC02072.JPG'

and how do i get it to evaluate false.

Format String
I have a large text file that I need to format so I can use a mysql command to populate a blob cell.

Is there an insert comand what will take my txt file and insert it into a cell from a remote computer?

Remove From String
I'm looking for some way to remove a part of a string from a table.

I have a table with a field called id. It contains data like this:
;1;6;9;34;54

What i want to do is to be able to remove ie. ";34" from this data, kind of oppisit of CONCAT. Hope that I explain myself well enough.

Do I have to extract all data, remove the substring and save the data in the db again, or is there an easier way?

How To Turn A String Into A Set?
If the string is in the form, say,

'setvalue1,setvalue3,setvalue7'

or 'setvalue2' if the row is a member of just one set.

Using An Apostrophe In A String.
Is there a way to pass an apostrophe from a webpage to a MySQL TEXT column? I have an area on my site where users can update their project details and I can foresee running into problems with the usage of apostrophes. I understand the error is in passing the INSERT command:

***
"INSERT INTO projects VALUES('1', '123456', 'Some Client', 'These are the project's details', 'Project Leader') ...

***

I understand that MySQL is thinking I mean to close the variable with the ' in project's.

Converting In To String
I have a table that has a field, subscription_id that is an unsigned long, and an account_number that is a string. I want to set the value of acct_number to be equal to the subscription_id converted to string form.

Get Min & Max Values Of A String
I have a field 'zip' in a table in my database that records values in the form on 'something/023/something', 'anything/346/somemore','kztt/1984/asdg'

I want to get the min and max values of this field in particular the numbers in the string. Initially, I simply run a query to get the min and max value of this field which works until the numbers in the string went to 4-digits instead of the usual 3.

Example query: select min(zip) as min, max(zip) as max from $dbtable

Then I run an explode function to retrieve the numbers in the string.

This query now return values like min=999, max=1000 instead, when the min number should be 023 and max is 1984

Selecting String
I am having a problem on selecting strings in mysql.

I have the folowing column:

|////////////////////////////////A\\\\\\\\|
+-------------------------------------------------------------------+
| 1A11B01C01D11E12A12B02C02D12E03A03B03C03D13E2 |
+-------------------------------------------------------------------+

What I would like to do is get this string giving a letter. Example:

I want letter B, then the result should be this: 1B02B03B0.

Got it? I give the letter and it returns me the prev char, the letter, next char. Only. Can mysql do this?

Efficiency Of String Vs Int
Is the difference in efficiency of a string in mysql vs the efficiency of an int drastic enough to avoid using an int? I'd like to use strings for readability of types but I can just as easily use ints like a C enum.

Error In String
I'd like to use placeholders but it looks difficult to use with $dbh->do() as I am not particularly familiar with this.

CODE $dbh->do("INSERT INTO storage (url, altavista, yahoo, msn, teoma, google, alltheweb,Total, lastsearch, totalsearch) values($url, $altavista_results, $yahoo_results, $msn_results, $teoma_results, $google_results, $alltheweb_results, $total,$time, $total)") unless $dbh->do(UPDATE storage SET (url = "$url", altavista = "$altavista_results", yahoo = "$yahoo_results", msn = "$msn_results", teoma = "$teoma_results", google = "$google_results", alltheweb = "$alltheweb_results", total = total +1, time="$time") > 0;

Interpret String As Sql
Is there a way to interpret the content of a string as sql?

String Operation
If i store a comma separated string(1,2,3,4) in a varchar field.Is there any operation using which i can retrieve the valuse 1,2,3,4 individually an use them in another query.

Incorrect String Value
while length(trim(mytext)) > 0 do
set var1 = SUBSTRING_INDEX(ltrim(rtrim(mytext)),' ', 1);
set pos = pos + 1;
set textlength=length(var1);
set mytext= SUBSTRING(trim(mytext), textlength+1);

insert into pddt values(doc_id,pos,var1);
end while;

When this loop runs i encounter this error "Incorrect String Value".
I was checking each and every line in this loop and found out that substring_index is causing this error(I Believe).

Mytext va

String Manipulation
I need to remove the html tags from a varchar field in the where clause. do you know how I could achieve this? this is how I planned to do it, but I can't find the appropriate function:

select * from test where replace(myfield,"<*>","") = "xoxox";

this replace function would replace all of the <html>, <a>,... from myfield with "".

String In The Database
Can i have a MySQL query which checks the table containing a list of
names?

I might have the following names on the table
Sony
Compaq
Logitech
Cabinet
Fedora
Angel
Incident

Can i get the results using the query for sounds like??

select name from table where name sounds like "sonny"

This should pick up Sony.. and a query like

select name from table where name sounds like "Kompaq"

This should pick up Compaq.

This is possible in MSSQL and Oracle. Is it possible in MySQL?

Trim A String
I have a MYSQL database which has a student name, year and register number(rno) fields.

In this rno filed length is 8 characters

I use PHP with this query
$result="select * from $tabname where RNO like '%$rno%'"

My problem is, I have some hundred candidates whose register number length is only 4
The regular length is 8 eg. 56001234

Some have like this 1034

Index By END Of String
for example, if you have a list of email addresses, searching for
something like '%@yahoo.com' would need to do a full table scan.

why doesn't mysql offer a feature where it indexes by the END of the
string, so we can do these types of searches efficiently?

an index for email addresses of length 3 would only contain the last 3
chars, but it would still be a useful index type.

Backslash In A String
backslash is usually used as an escape marker in a string. but when I need the backslash as a real backslash, for example in paths, how can I write them?

String Functions
Not sure if this is a MySql mistake, but it seems to be. I am trying to execute a query that returns all the records where the first 3 characters of the username are equal to "cd-". After many successive, frustrating combinations of different string formatting / comparison functions, I figure I need some help. Here is my code.

$sql = "SELECT username, officer1, officer2 FROM login WHERE SUBSTR(username, 0, 2) = 'cd-'";

here is my error
Parse error: parse error, unexpected T_LNUMBER on line blah.. blah..

My questions are as follows...
1. I know the code doesn't work, but is this a legal use of the SUBSTR() function. If so... will it (hopefully not) modify the contents of username?
2. In a previous version of this code i used LIKE intstead of =, without the SUBSTR(). Can anyone explain to me how the 'wildcard' characters % _ work. The manual was vague at best.

Inexact String
I've been looking for a way to match up search queries for music against a database and am evaluating MySql.

Now it looks like Full-Text indexing takes care of issues such as finding results for

The Beatles if the user passes in a search string of "Beatles"

My question is if MySql has some sort of Sound-ex like algorithms to also find results if the search query was "Beetles" "Beatlles" and things like that.

I was told (but have not verified) MS-SQL's full-text indexing provides this feature somehow.