Forum Replies Created
-
AuthorPosts
-
ShadowMember
MySql socket? What do you mean by that? If the port MySql listens to, then it can be set on the connection window.
ShadowMemberNow, that would be a really tough job! Just think, the program should be able to use at least three different APIs, should have to understand three types of SQL, not to mention the internal pogramming languages of Oracle and MS SQL Server, plus user rights… I would say, supporting one db is enough for one product.
ShadowMemberI don't think so. I use SQlyog and both MySql 4.012 and 4.1 alpha, and I have both servers running on drive D: without any problem. Don't you happen to have a my.ini in your windows directory or any other config file that could possibly overwrite your settings in my.cnf?
You could check winmysqladmin as well…
ShadowMemberOn Win98 I can connect to Excel via ODBC without any problem, but I doesn't work on Win2K. Interesting. It seemst to be an ODBC issue to me.
ShadowMemberInstead of choosing the copy table option, you could write a script that would do the importing.
ShadowMemberQuote:Yog is a Sanskrit work which means work with dedication . Thats what we stand for work with dedication to create GREAT PRODUCTS
Ritesh ([email protected])
That's it…
ShadowMemberSQLyog is a Win32 application and doesn't run on linux/unix.
ShadowMemberInteresting, it works fine for me, at least from Access (MS Access 2000). But I cannot create any connection to Excel…
ShadowMemberAre you sure that this is the sql statement that causes the error? It seems OK to me. Perhaps you could try to add a primary ket to the table manually.
ShadowMemberSQLyog does work with MySql 4.1, but not perfectly since 4.1 implements a new binary protocol. If you don't use passwords then it is capable of connecting to the server (delete existing passwords). The new version of SQLyog is promised to be compatible with 4.1. Perhaps you could volunteer to beta test it…
ShadowMemberIt works perfectly for me (v3.11). What is the exact column type?
ShadowMemberNot just phpMyAdmin, virtually every other MySql client allows it…
You should create 3 tables insted of the one you have curently:
– one to hold the data for awards,
– another to store the data of the persons,
– a third one holding the primary keys of the previously mentioned tables.
ShadowMemberSure it has, but it requires direct connection to the MySql db…
ShadowMemberProbably you can set up phpMyAdmin on the remote server. It is entirely script based (php) and has all the RDBMS features you may require.
ShadowMemberYou may not have the right permissions to connect to the MySql server or if you do then the portnumber may not be the default. Usually ISP's allowing MySql on their servers provide a way to connect, otherwise it would not make too much sense. Ask them!
-
AuthorPosts