Type name invalid.

[domeika]

I would really appreciate some help with this if anyone has an idea:
I have a web app that calls 2 vb components (.dlls) I created. My .asp files are on a development web server(w2k and yes directory is set as an application directory) and my components are on a development application server. Both components make calls to a development data server (SQL 7). Here is the problem...When running on my machine(localhost), the web app works fine. It is pointing to the .dlls on the application server and using the DB on the data server. The only thing that is local are the .asp files. However, on the develpment web server, certain calls to the components return "Type name invalid.". The pages on both localhost and webserver are identical.
In case someone needs to know the development environment: I can copy files to the web server but that's as far as permissions go (no nuts N bolts access), and on the application server, I submit a migration request to move my .dlls. I have administrator access on my localhost.
Any help would be appreciated.

 

[domeika]

Hello all,
Found an answer to my own question...
The SQL software running on our client development machines is of a later version than that of the server. "Type name invalid." was returned because the server did not recognize the field type "BigInt" which was being used in several tables (but not all) as the primary key. Thus some worked and some did not.
The fix: Changed all the affected fields, stored procedures, and references from COM objects to Integer.