Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Carriage return in INSERT
Message
From
28/07/2009 12:53:16
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01414914
Message ID:
01415102
Views:
52
>>Do you remember the other thread about the null problem? I was/am using the string as a parameter passed into a SP to overcome the nulls not allowed problem. I have not been able to get the SET NULL to work from within the connection string. :(
>>Here's what was suggested but it doesn't work. Maybe I just didn't understand enough.
>>
>>
>>  <add name="TIPWebEdits" connectionString="Provider=VFPOLEDB.1;Data Source=C:\Inetpub\wwwroot\netTIP\App_Data\Tip_WebEdits\tip_webedits.dbc;NULL=No"
>>   providerName="System.Data.OleDb" />
>>
>>
>Are you sure you want NULL=No, may be you want NULL=Yes ?
>
>See http://www.connectionstrings.com/visual-foxpro
>
>and it's referenced from http://social.msdn.microsoft.com/Forums/en-US/visualfoxprogeneral/thread/2eeed0dc-9199-48cb-910c-c661e9096cfe

I've tried YES,NO,OFF,ON all with the same result. Any other ideas?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform