Illusion Posted September 16, 2003 Posted September 16, 2003 Hi, I'm trying to connect to an odbc database .. which works .. I am pulling out the table but the table has a / in it and it doesnt read it and generates an error. I have tried to put the database into SQL and it cannot read the / in the table name. any ideas please? Quote
Moderators Robby Posted September 16, 2003 Moderators Posted September 16, 2003 surround the table name with [ ] ie... [Table/Name] If at all possible I would remove any non-alpha characters from DB objects including spaces. (except for the under_score) Quote Visit...Bassic Software
Illusion Posted September 17, 2003 Author Posted September 17, 2003 I have, I've tried: [name/name] ([name/name]) """name/name""" """[name/name]""" nothing has worked .. and I cant change the database as the program which uses it was made by another company and _if_ it could be changed the program wouldnt work :( I managed to get access to push the information into SQL ..its not a nice fix .. but its all that works at the moment.. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.