Yes - I have the ones from CoreLab but that doesn't give me the data in the server explorer. I read thread 796-638057 - she said she could do it and there are some nice features of the server explorer that are not supported by CoreLab. I was just wondering how she got the stuff working. I sent...
Thank you for responding - I can connect through ODBC - I am sorry I wasn't clear enough. I read that someone connected to MYSql through the Server Explorer - I do it through ODBC. Is there any way I can connect to mysql through the Server Explorer so I can use the drag and drop functionality...
I am trying to connect to MySQL through the Server Explorer and can't get to the data - I connect to the db, can view the tables and fields but when I try to drag a field onto the form I get the message "You cannot use an ole db provider for ODBC drivers". I use MyODBC, Visual...
GaryC123 - THANK YOU - I appreciate your quick response :o) ... even if it works only between same type db's it saves a lot of time - thank you again for the tip
GaryC123 - I try to copy a table from Pervasive to Mysql - needs to be done at least once a day -and the recordset to recordset is SLOWWWW. Is the above code suppose to work when you copy between different types of databases and or servers? Also - if the new table doesn't exist - why does it...
I am new to vb.net and MySQL. I am trying to connect to MySQL (installed on my machine for now) through the Server Explorer and can't get to the data - I connect to the db, can view the tables and fields but when I try to drag a field onto the form I get the message "You cannot use an ole...
I am new to vb.net and MySQL. I am trying to connect to MySQL (installed on my machine for now) through the Server Explorer and can't get to the data - I connect to the db, can view the tables and fields but when I try to drag a field onto the form I get the message "You cannot use an ole...
I have a table in pervasive sql 7 with a type TIME field
EVTime TIME(4)
When I pull this in VB(6) or SQL it shows the time in a 24h format.
In Crystal, the field appears as a number and I can't make it to show up as a time field. I made sure that the report options are checked to keep...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.