>>>>> "Rehan" == Rehan Ishrat <ishrat_rehan@stripped> writes:
Rehan> MySql is installed on Linux. I created DSN on NT workstation 4.0.
Rehan> Through ADO control in VB 6.0 i tried to connect to the tables. O.K the
Rehan> connection established and it retrieved the records in the Data
Rehan> Grid.Problem is that when i update/insert the records, the operation get
Rehan> failed.
Rehan> Further information is given below.
Rehan> At Server Side i have following resources.
Rehan> O.S=Linux 2.2.7.
Rehan> WebServer=Apachi /1.3.4.
Rehan> MySql=Server version: 3.22.14 b-gamma
Rehan> Protocol: 10
Rehan> Connection: TCP/IP.
Rehan> Machine: intel -586
Rehan> DataBase=rehandb
Rehan> Table Name=abc
Rehan> Field1=f1 char(2)
Rehan> Field2=f2 char(2)
Rehan> At Client Side i have following.
Rehan> O.S=NT WorkStation 4.0
Rehan> DSN=TestMySql
Rehan> Odbc driver=ver=2.50.21.00
Rehan> Programming Language=VB6.0
Rehan> Project Type=EnterPrise Edition Controls.
Rehan> Control that i use in VB to connect to Database =Microsoft ADO DataControl
Rehan> 6.0 (OLEDB).
Rehan> Grid Control=Microsoft Data Grid Control 6.0 (OLEDB)
Rehan> References that i used = Microsoft ActiveX dataobject 2.0 Library.
Rehan> Error that i encountered during update and insert through data control and
Rehan> grid is = [TCX][MYODBC]Table 'rehandb.f1' does not exists.
Rehan> I guessed as the above message tells that the ADO control is unaware of the
Rehan> correct table name. because rehandb is the name of the database and not of
Rehan> the table. It will succeed in inserting records if it founds
Rehan> [TCX][MYODBC]Table 'abc.f1' during the operation.
Hi!
Please check that you don't have the option:
Ignore # in #.table
checked in the MyODBC connect screen
Have you tried to make a MyODBC log to check which query fails? You
can easily check if the query is ok by trying it in the 'mysql command
line tool!
With MySQL 3.22 you can use the database.table name syntax!
Regards,
Monty
