I'm trying to connect web server that working under linux.
how to make connection to that web server? cause i have try to make the connection with mysql odbc driver 3.51,and its totally failed.
have asking the customer service,and got explain, that's because i run under windows.can i make client application with vb and webserver linux as the database? its use mysql as the webserver database.
Thank You...
User Profile
Collapse
-
Need Master vb help
-
sorry,i really want to know,cause this discussion related what i do now.
i was make my connection like this....
[VB]
Set conn = New ADODB.Connectio n
conn.Connection String = "DRIVER={My SQL ODBC 3.51 Driver};" _
& "SERVER=srv7.89 0m.com;PORT=330 6;DATABASE=data base;UID=a28400 13_guest;" _
& "PWD=mypass ; OPTION=3;STMT=; "
conn.Open
... -
i have tried it...but still cant connect....
now i try to using mysql administrator 1.2.12. still cant connect.... it was connect perfectly with local mysql server. does i must change my default port? "3306" to anything else? "80" maybe?...Leave a comment:
-
i have try that before....
is there i must use the port? or socket configuration?Leave a comment:
-
vb 6 and my sql
i have download mysql odbc 3.51 driver,and make application in VB and working well. now,can i connect mysql,where the mysql server is a webserver? not localhost or lan? how to do that? is there any application i must have?
thank you... -
please give us more detail,like your code,error message,ext....
so we can understand your problem....Leave a comment:
-
i was mistake with double quote... :)
the first i was dont know that one quote is as a string. now i know it ... .
:)
thank you hsriat.... one thing again...
can you explain me...
Code:foreach($_POST[checkbox] as $key=>$selected_id)
can you give me a link that explain this?
thank you...for your help.......Leave a comment:
-
thank you hsriat... that was really helpful. Very glad you help me... :)
now i know where my fault... have the answer now... :)...Leave a comment:
-
can u give us more information? like what the name your datagrid,and your form name,what field that you want to get in other form,Etc? it would be easier to you understand it....Leave a comment:
-
sorry...what event,you want that caption will add? after insert 'txtNoOfChild'? or what? if that so,you can use keypressed event in your text box....Leave a comment:
-
i have write it like this...
[php]
<?
include("test.p hp");
mysql_select_db ("a2840013_Data base",$cipai) or die ("Cannot Connect At Delete Form");
$not_deleted = array();
foreach($_POST[checkbox] as $key=>$selected _id)
{
if (!mysql_query(" DELETE FROM customer WHERE id_Customer = '".$selected_id ."'"))
array_push($not _deleted,...Leave a comment:
-
why you dont try to use filelistbox,dir and drive list box ocx?
it would be easier for your. set the filter at the filelistbox ocx....Leave a comment:
-
thanks for reply,did you mean like this? still have the same result. my primary is id_Customer.
Code:<? include("test.php"); mysql_select_db("a2840013_Database",$cipai) or die ("Cannot Connect At Delete Form"); foreach($_POST[checkbox] as $key=>$selected_id) { echo "$selected_id"; mysql_query("DELETE FROM customer WHERE id_Customer
Leave a comment:
-
just a suggestion....
it would be better if you make one field automatic number. and u can delete by that automatic number. get the record(Select) and delete for AutomaticNumber ='99'.
just something like that.... :)...Leave a comment:
-
change your query :
sql = "Delete * from Agentinfo where AGENTID =" & txtAgtId.Text
with
sql = "Delete * from Agentinfo where AGENTID = '" & txtAgtId.Text & "'"...Leave a comment:
-
thanks for reply... but i dont still get it.. can u help me again? :)
Code:<? include("test.php"); mysql_select_db("a2840013_Database",$cipai) or die ("Cannot Connect At Delete Form"); foreach($_POST[checkbox] as $key=>$selected_id) { mysql_query("DELETE FROM customer WHERE Nom = '{$selected_id}'") or die ("Cannot Delete"); echo
Leave a comment:
-
thank for reply...
i have write this code with your suggest...
Code:<? echo "<form method='POST' action='del_cust.php'>"; while($row=mysql_fetch_assoc($result)){ echo "<table width ='100%'+ border='1'>"; echo " <tr> <td><input type='checkbox' name='checkbox[]' value=''.$row[id_Customer].''></td>
Leave a comment:
-
Make Check Button
hi again... :)
please help me,how to make a check button,so the user can check which one to delete...and how to implement it with "delete" selected check button?
Code:<? while($row=mysql_fetch_assoc($result)){ echo "<table width ='100%' border='1'>"; echo " <tr> <td width = '10%'> $row[id_Customer] </td> <td width
-
thank for the reply... i have resolve it using css that u told me... :)
thanks...i was post my website before and not have a problem like this... this is the first time... thank you...hope see u again if i got a problem...hehe...Leave a comment:
-
need help webmaster...
this is my code:Code:<html> <Title> Explore the new world </Title> <body background="Citrus.gif"> <br> <font color= blue ><center> <h1>Ini Website Buatan Tommy Masih Dalam Tahap Konstruksi hehehe <h1><br> <img src ="smiley.gif" height=50 width=50> <br> Kalau Ada Saran Bikin Website Apaan....<br>
No activity results to display
Show More
Leave a comment: