Jump to content

Error:[ODBC FMP Driver]Invalid Character Value.


This topic is 6968 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I keep getting the following error when trying to bring my table into SQL Server via ODBC:

[DataDirect][ODBC Sequelink Driver][ODBC Socket][DataDirect][ODBC Filemaker Driver]Invalid character value. Error in column 62.

I look at field #62 and it is a global field with nothing in it. I can't figure out what is going on. I have other tables that I imported that had global fields but not this one. Any input would be appreciated!

Thanks!

John

Link to comment
Share on other sites

Never mind, I figured it out. It ended up being two calculation fields that were doing a count(Related field). For some reason it didn't like this. I changed the calculation to IsEmpty(Related field) and it works.

Admins, you can delete this post if you would like.

Thanks!

John

Link to comment
Share on other sites

This topic is 6968 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.