This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Database Import Problem "empty strings" instead of "NULL"
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 19, 2008
10:27 AM
Database Import Problem "empty strings" instead of "NULL"
Hi, I'm using the database import wizard of Installshield 2008 on a MS SQLServer Express 2005. My problem is: Database fields which are set to NULL in the source DB are imported as ''. This causes problems on the target DB. The program on the target machine which accesses the DB is not able to handle ''.
I’m not able to modify the accessing program!
Is it possible to change this import behavior in Installshield or on the SQL Server Express?
What interface is Installshield 2008 using to access the DB? SMO or DMO?
Thanx for help!
I’m not able to modify the accessing program!
Is it possible to change this import behavior in Installshield or on the SQL Server Express?
What interface is Installshield 2008 using to access the DB? SMO or DMO?
Thanx for help!
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Mar 20, 2008
02:23 PM
Is the field type a text, ntext, varchar, or nvarchar? If so, please follow the steps below to change the behavior:
[LIST=1]
Open settings.xml under C:\Program Files\Macrovision\IS2008\Support folder in Notepad.exe
Find DevStudio/IDE/Workspaces/SQLScripts/DBImport_ColumnType tag
Change the Nullable property from 'N' to 'Y' for the field type(s) that you have the problem with.
Save settings.xml
Import your database.
[LIST=1]
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Nov 05, 2008
06:09 AM
Thanx, now it works!!!
But I'm asking my self why there isn't any hint in the "DB Import" section of the Manual/Help?
Regards Octron66x
But I'm asking my self why there isn't any hint in the "DB Import" section of the Manual/Help?
Regards Octron66x
![](/skins/images/A5EADE085F77DE82FB3B14D6B307AE6A/responsive_peak/images/icon_anonymous_message.png)