Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Slive
Starting Member
8 Posts |
 Posted - 2011-05-23 : 08:33:32
|
| Can't figure out why we got this. We were doing a dbload into sql 2008 from Pervasive v10. Here's the error[microsoft][ODBC SQL Server Driver][SQL Server]Column,parameter, or variable #4: Cannot find data type BOOLEAN Just need a jumpstart on this. Groping in the dark at the moment. Thanks a mil in advance |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-23 : 08:38:28
|
| Not such datatype in sql server. Usually use a bit or int or a char set to Y/N.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Slive
Starting Member
8 Posts |
Posted - 2011-05-23 : 10:05:42
|
| Thanks. So would this be originating from pervasive? |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-23 : 10:12:58
|
| It's whatever tool you are using for the load.It should be converting the datatypes to the sql server equivalent.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Slive
Starting Member
8 Posts |
Posted - 2011-05-25 : 09:33:39
|
| Thanks Nigel. Seemed to work after deleting db's that were empty then we ran a db verify to recreate them once the load finished. |
|
|
|
|
|
|
Database Boolean error. Any ideas?