field name issues

[striker73]

I have a really long field name (ie: Date_RMA_Part_Received_From_Customer) in my SQL Server database. When I pull the data out in my php form, I get an error: Warning: Field "Date_RMA_Part_Received_From_Customer not found in ... I have typed the field name correctly- I copy and pasted it into enterprise manager and it worked fine. Anyone have an idea of what's going on?

Thanks!

 

[sleipnir214]

How are you connecting to MSSQL?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[striker73]

I'm using odbc_connect() to connect to the database. I'm using other field names that are working correctly.

 

[sleipnir214]

Is this on Win32 or *nix?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[striker73]

Um.. Win32? I'm using Windows XP. The DB is hosted on a Windows Server 2000 machine.

 

[sleipnir214]

Are any of the field names that work longer than the problematic one?

I'm wondering if your ODBC installation simply can't handle the long field name. Enterprise Manager, to the best of my knowledge, doesn't use ODBC to connect to MSSQL.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[striker73]

Nope, the only one that doesn't work is the super long one. I guess I'll just rename it.

 

[sleipnir214]

That's the only thing I can think of. I found some oblique comments in some web pages that some SQL Server ODBC driver versions don't like names longer than 32 characters.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!