I just installed my new license and I am receiving errors any time I try to do any kind of database operation.
For example, When trying to add a category, this is the error:
Perl Version: 5.006001
Links SQL Version: 2.1.1
DBI.pm Version: 1.28
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: 'SELECT ID FROM lsql_Category WHERE FatherID = ? AND Name = ? ' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from datatype 'varchar' to datatype 'int'
Table: 'somd.somd_admin.lsql_Category', Column: 'FatherID'
Use the CONVERT function to run this query. (SQL-37000)(DBD: st_execute/SQLExecute err=-1)
This is a Windows 2000 Server with SQL Server 6.5. I am thinking that maybe this product doesn't really support MSSQL 6.5? I asked if it did in a pre-sales thread and was told yes.
For example, When trying to add a category, this is the error:
Perl Version: 5.006001
Links SQL Version: 2.1.1
DBI.pm Version: 1.28
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: 'SELECT ID FROM lsql_Category WHERE FatherID = ? AND Name = ? ' Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Disallowed implicit conversion from datatype 'varchar' to datatype 'int'
Table: 'somd.somd_admin.lsql_Category', Column: 'FatherID'
Use the CONVERT function to run this query. (SQL-37000)(DBD: st_execute/SQLExecute err=-1)
This is a Windows 2000 Server with SQL Server 6.5. I am thinking that maybe this product doesn't really support MSSQL 6.5? I asked if it did in a pre-sales thread and was told yes.