HI I installed MyODBC on an NT server to connect via the internet to my Linux box that runs mysql3.23. I have already populated tables in a db that I am trying to link to the NT server via ODBC, but I am getting errors when trying to do this. The table is created with an id field ( BIGINT (255)) , a key field varchar(16) and then a whole bunch of other fields of type text. All have Null = No yet some of the fields do have null entries (not sure if this is where the problem comes in). So, when we tried to connect, MS SQL complains about a fieldname that has no entry and quits. As soon as I temporarily put something in that field for that specific row, it goes further, to the next empty field and then complains about it. So it seems like MS SQL doesn't like the fact that I either used text as the type, or it doesn't like the fact that some fields are empty.
Strangest of all, when I do a "statis" import in access of the same table as is, it imports it 100%. How can I fix this? Is this a problem of conversion between mysql and ms-sql? Should I "fix" this on the mysql side or on the ms-sql side? What is the correct type to use for my fields ( I only read normal form text field data from websites, so I though text was the correct type to use as I don't really cae if some of the fields are empty), and what should my fields be then, null or not null? I normally use phpMyAdmin to create new tables on the fly and it's default setting is Null = no, and it always worked fine for me so far. Please can someone help me to fix this, I don't want to change my field types fi not absolutely necessary due to incorrect practise on my side. I already have an entire system running on these tables and wouldn't want to go and fiddle around with field types and run the danger that some obscure sql string somewhere in my long forgotten code will now fail to add to some tables because of that, so, basically I'd like to see a ms-sql fix for this unless, like I said, you can clearly show me that I used improper protocol to create my tables from the start, and that to conform to accepted SQL standards, I should change field types... Thanks for your help. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
