Search results

Thank you. I decided to go round the problem and had a day of some drama. I downloaded PostgreSQL to my RDP server and loved it until I tested the connection when it asked me to "supply the password" even though I had put the password in the connector form. But it wouldn't let me click in the...

Whoa!! My version of mySQL is 5.7.10!!!! I have sent an urgent alert to Hostek .....

Thank you again for all your help

Yes, I tried Unicode but same error. And I discovered i was not telling it properly where to save the dsn so i did that and relinked. Unfortunately the same error. I am in Hong Kong so I have to go to bed now :-)

Duh!!!!!!!!! ODBC;DRIVER={MySQL ODBC 9.0 ANSI Driver};UID=myUID;USER=myUsrName;SERVER=62.3.51.120;PORT=3306;PASSWORD={myPassword};NO_SCHEMA=1;DFLT_BIGINT_BIND_STR=1;DB=gts;DATABASE=gts;FILEDSN=C:\Users\Administrator\Documents\62.3.51.120.dsn; My RDP user name is "trader", not Administrator...

I really appreciate all your help :) So I put your connection string request in Immediate VBA and got the error "Runtime Error 3265 - Item not found in this collection." My mySQL is on Windows!!

tbladdress "CREATE TABLE `tbladdress` ( `pkAddress` int(10) NOT NULL AUTO_INCREMENT, `AddressType` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `NickName` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `Street1` varchar(100) CHARACTER SET utf8 DEFAULT NULL, `Street2` varchar(100)...

I should disclose here that I am accessing Windows server on a remote desktop from my Mac whiich is linking to a different remote server with the data source. I guess there is some networking issue involved.

Yes, all the tables show the right primary key in Design view though they are shown as Long Integer instead of the Integer setting in mySQL. I don't know if that matters

Thanks so much for your prompt response. I don't think I can do Show Create Table as my d/b is remote where I don't have terminal access. But I have full access to all my files in DBeaver - where I created the tables and set the primary keys. And I can even work with the tables in LibreOffice...

I connected my database to my remote mySQL server. The connection succeeded and I could see all my tables and link the ones I wanted. But, when I double clik on the tables, it shows all the field names correctly but all the field data is "Name?" with the error message "ODBC-call failed" I...

i, I used to be reasonably expert in Access 25 years ago!! I am very impressed with my first experience of coming back to the modern version but am already having some problems conecting to my my'SQL d/bs so i am looking for help